PostgresSQL 10 on remote server - Socket is not connected (0x00002749/10057)

2020-01-22 Thread Tanja Savic
Hi, I’m running a pgAdmin from Windows 10 : pgAdmin Version: 4.17 Python Version: 3.7.3 (v3.7.3:ef4ec6ed12, Mar 25 2019, 21:26:53) [MSC v.1916 32 bit (Intel)] and I’m able to connect to the remote server. I can see schemas and tables, but when I want to run a query I get this error: could not

RE: PostgresSQL 10 on remote server - Socket is not connected (0x00002749/10057)

2020-01-24 Thread Tanja Savic
5:15 PM To: Tanja Savic ; pgsql-general@lists.postgresql.org Subject: Re: PostgresSQL 10 on remote server - Socket is not connected (0x2749/10057) On 1/22/20 2:18 AM, Tanja Savic wrote: > Hi, > > I'm running a pgAdmin from Windows 10 : > > pgAdmin Version: 4.17 >

RE: PostgresSQL 10 on remote server - Socket is not connected (0x00002749/10057)

2020-01-27 Thread Tanja Savic
Hi, I reset tcpip stack but didn't work, same error and behavior. Tanja -Original Message- From: Adrian Klaver Sent: Friday, January 24, 2020 5:30 PM To: Tanja Savic ; pgsql-general@lists.postgresql.org Subject: Re: PostgresSQL 10 on remote server - Socket is not conn

pg_ctl can't start db server

2020-05-29 Thread Tanja Savic
Hi, We did the upgrade of PostgreSQL 10 to 12 on linux server. Everything was fine (can connect via pgAdmin, data is there...) except two tablespaces which are still in directory for PostgreSQL 10. So we followed these steps to move tablespaces: https://www.enterprisedb.com/blog/moving-tablespa

RE: pg_ctl can't start db server

2020-06-01 Thread Tanja Savic
24538 online postgres /var/lib/postgresql/12/main /var/log/postgresql/postgresql-12-main.log Thank you for your replies. BR, Tanja -Original Message- From: Tom Lane Sent: Friday, May 29, 2020 5:32 PM To: Tanja Savic Cc: pgsql-general@lists.postgresql.org Subject: Re: pg_ctl can&#x

Move configuration files with pg_upgrade

2020-06-04 Thread Tanja Savic
Hello, I did Postgresql upgrade from v10 to v12 using pg_upgrade (on Linux Ubuntu server). Of course i wanted settings in pg_hba.conf and postgresql.conf to keep, but after the upgrade there were new configuration files and I moved it manually. Is it possible somehow to migrate these old config