RE: Re: Re: Re: Issue with postgres login

2017-11-23 Thread Daulat Ram
Thanks for your response. But now I am giving below error while restore the backup ./pg_restore -i -h localhost -p 5432 -U postgres --role postgres -d fleotan -W -v /backup/fleotanOne11.backup >& /backup/fleotanOne32_restore.log pg_restore: [archiver (db)] connection to database "fleotan" failed

Re: Re: Re: Issue with postgres login

2017-11-23 Thread Bob Strecansky
It appears our file permissions are too wide open (which correlated with the error message you shared in your previous email. Changing those to 700 should get you going in the correct direction. -B On Thu, Nov 23, 2017 at 23:23 Daulat Ram wrote: > Hello team, > > > > We have the data directory

RE: Re: Re: Issue with postgres login

2017-11-23 Thread Daulat Ram
Hello team, We have the data directory under /var/lib/pgsql/9.3/data/ FYI. Below are the permissions to group and user on each directory. Please do help . drwxr-xr-x. 19 root root 267 Nov 22 08:42 var/ drwxr-xr-x. 30 root root 4096 Nov 23 09:09 lib/ drwxrwxr-x. 3 postgres postgres 129 Nov 23

Re: Re: Issue with postgres login

2017-11-23 Thread Bob Strecansky
It appears the permissions with your data directory have changed. According to the error message, you should set the appropriate permissions for /var/lib/pgsql/9.3/data -B On Thu, Nov 23, 2017 at 23:04 Daulat Ram wrote: > Hi team, > > > > But it was working fine earlier. > > > > Another message

RE: Re: Issue with postgres login

2017-11-23 Thread Daulat Ram
Hi team, But it was working fine earlier. Another message I have seen after starting by -bash-4.2$ /usr/pgsql-9.3/bin/pg_ctl -D /var/lib/pgsql/9.3/data/ -l logfile start < 2017-11-24 04:00:40.780 UTC >FATAL: data directory "/var/lib/pgsql/9.3/data" has group or world access < 2017-11-24 04:00

Re: Issue with postgres login

2017-11-23 Thread Bob Strecansky
It seems you may have just the postgresql package installed and not the postgresql-server package. This Linode guide may be helpful: https://www.linode.com/docs/databases/postgresql/how-to-install-postgresql-relational-databases-on-centos-7 -B On Thu, Nov 23, 2017 at 22:28 Daulat Ram wrote: > H

Issue with postgres login

2017-11-23 Thread Daulat Ram
Hi team, We are facing the below issue while logging with postgres as given below: [centos@ip-192-90-2-208 ~]$ su - postgres Password: Last login: Thu Nov 23 16:15:45 UTC 2017 on pts/1 -bash-4.2$ psql psql: could not connect to server: No such file or directory Is the server running local

pgpool + repmgr - who should be responsible for failover

2017-11-23 Thread Mariel Cherkassky
I configured replication with repmgr on 2 postgresql 9.6.3 nodes. Both of those utilities can handle failover but I should let only one of them do it. So, I wanted to know who should be the one responsible for the failover and why ? Thanks .

Re: Query became very slow after 9.6 -> 10 upgrade

2017-11-23 Thread Tom Lane
Dmitry Shalashov writes: > We tried to apply the patch on 10.1 source, but something is wrong it seems: > patch -p1 < ../1.patch > (Stripping trailing CRs from patch; use --binary to disable.) > patching file src/backend/optimizer/plan/analyzejoins.c > (Stripping trailing CRs from patch; use --bin

Re: Query became very slow after 9.6 -> 10 upgrade

2017-11-23 Thread Dmitry Shalashov
We tried to apply the patch on 10.1 source, but something is wrong it seems: patch -p1 < ../1.patch (Stripping trailing CRs from patch; use --binary to disable.) patching file src/backend/optimizer/plan/analyzejoins.c (Stripping trailing CRs from patch; use --binary to disable.) patching file src/

Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade

2017-11-23 Thread Henrik Cednert (Filmlance)
On 22 Nov 2017, at 22:07, Patrick KUI-LI mailto:pku...@hipay.com>> wrote: Hello, I had this behaviors when the upgraded pg 9.5 was on ssl mode by default. So i deactivated ssl mode in postgresql.conf. That's all. Regards, Patrick Hello And you just uncommented the 'ssl = off' line in t