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
gt; < 2017-11-24 04:00:40.780 UTC >DETAIL: Permissions should be u=rwx (0700). > > > > For more details please refer to trail mail > > Regards, > > Daulat > > *From:* Bob Strecansky [mailto:b...@mailchimp.com] > *Sent:* 24 November, 2017 9:07 AM > *T

RE: Re: Issue with postgres login

2017-11-23 Thread Daulat Ram
< 2017-11-24 04:00:40.780 UTC >DETAIL: Permissions should be u=rwx (0700). For more details please refer to trail mail Regards, Daulat From: Bob Strecansky [mailto:b...@mailchimp.com] Sent: 24 November, 2017 9:07 AM To: Daulat Ram Cc: pgsql-performa...@postgresql.org Subject: [EXTERNAL]R

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