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

2017-11-23 Thread Daulat Ram
plication postgres::1/128 ident Plz suggest Regards, Daulat From: Bob Strecansky [mailto:b...@mailchimp.com] Sent: 24 November, 2017 9:56 AM To: Daulat Ram Cc: pgsql-performa...@postgresql.org Subject: [EXTERNAL]Re: Re: Re: Issue with postgres login It appears our file permission

Re: Re: Re: Issue with postgres login

2017-11-23 Thread Bob Strecansky
* > > *port = 5432 * > > *max_connections = 100 * > > *unix_socket_directories = '/tmp'* > > *unix_socket_group = '' * > > *unix_socket_permissions = 07

RE: Re: Re: Issue with postgres login

2017-11-23 Thread Daulat Ram
'/tmp' unix_socket_group = '' unix_socket_permissions = 0777 Regards, Daulat From: Bob Strecansky [mailto:b...@mailchimp.com] Sent: 24 November, 2017 9:37 AM To: Daulat Ram Cc: pgsql-performa...@postgresql.org Subject: [EXTERNAL]Re: Re: Issue with postgres login It appears the p

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