|
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:bob@xxxxxxxxxxxxx]
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.Ram@xxxxxxxxxx> wrote:
-- Thanks, |
