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 16:05 pgsql/
drwxrwxr-x. 4 postgres postgres   66 Nov 24 04:00 9.3/
drwxrwxr-x. 16 postgres postgres 4096 Nov 24 03:42 data/

-rwxrwxrwx. 1 postgres postgres     4 Nov 23 09:09 PG_VERSION
drwxrwxr-x. 2 postgres postgres     6 Nov 23 09:09 pg_twophase
drwxrwxr-x. 2 postgres postgres     6 Nov 23 09:09 pg_tblspc
drwxrwxr-x. 2 postgres postgres     6 Nov 23 09:09 pg_snapshots
drwxrwxr-x. 2 postgres postgres     6 Nov 23 09:09 pg_serial
drwxrwxr-x. 4 postgres postgres    36 Nov 23 09:09 pg_multixact
-rwxrwxrwx. 1 postgres postgres  1636 Nov 23 09:09 pg_ident.conf
drwxrwxr-x. 3 postgres postgres    60 Nov 23 09:09 pg_xlog
drwxrwxr-x. 2 postgres postgres    18 Nov 23 09:09 pg_subtrans
drwxrwxr-x. 2 postgres postgres    18 Nov 23 09:09 pg_clog
drwxrwxr-x. 5 postgres postgres    41 Nov 23 09:09 base
-rwxrwxrwx. 1 postgres postgres    59 Nov 23 09:12 postmaster.opts
drwxrwxr-x. 2 postgres postgres    18 Nov 23 09:12 pg_notify
drwxrwxr-x. 2 postgres postgres    32 Nov 23 09:12 pg_log
drwxrwxr-x. 2 postgres postgres  4096 Nov 23 09:12 global
-rwxrwxrwx. 1 postgres postgres  4232 Nov 23 10:50 pg_hba.conf_backup
-rwxrwxrwx. 1 postgres postgres  9273 Nov 23 13:27 pg_hba.conf
drwxrwxr-x. 2 postgres postgres     6 Nov 23 14:32 pg_stat_tmp
drwxrwxr-x. 2 postgres postgres    63 Nov 23 14:32 pg_stat
-rwxr-xr-x. 1 root     root     20137 Nov 23 14:41 postgresql.conf.bak_231117
-rwxrwxrwx. 1 postgres postgres 20230 Nov 23 15:03 postgresql.conf_original
-rwx------. 1 postgres postgres 20137 Nov 24 03:30 postgresql.conf_24_nov
-rwx------. 1 postgres postgres 20124 Nov 24 03:42 postgresql.conf

Also we have change the below parameters in Postgres.conf file to resolve the 
issue but still not resolved.

listen_addresses = '*
port = 5432
max_connections = 100
unix_socket_directories = '/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 <daulat....@cyient.com>
Cc: pgsql-performa...@postgresql.org
Subject: [EXTERNAL]Re: Re: Issue with postgres login

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 
<daulat....@cyient.com<mailto:daulat....@cyient.com>> wrote:
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: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<mailto:b...@mailchimp.com>]
Sent: 24 November, 2017 9:07 AM
To: Daulat Ram <daulat....@cyient.com<mailto:daulat....@cyient.com>>
Cc: pgsql-performa...@postgresql.org<mailto:pgsql-performa...@postgresql.org>
Subject: [EXTERNAL]Re: Issue with postgres login

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 
<daulat....@cyient.com<mailto:daulat....@cyient.com>> wrote:
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 locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
-bash-4.2$


OS: Centos
AWS environment

Regards,
Daulat

________________________________

DISCLAIMER:

This email message is for the sole use of the intended recipient(s) and may 
contain confidential and privileged information. Any unauthorized review, use, 
disclosure or distribution is prohibited. If you are not the intended 
recipient, please contact the sender by reply email and destroy all copies of 
the original message. Check all attachments for viruses before opening them. 
All views or opinions presented in this e-mail are those of the author and may 
not reflect the opinion of Cyient or those of our affiliates.
--
Thanks,

-B
--
Thanks,

-B

Reply via email to