PostgreSQL data directory

sed -i s"/\/var\/lib\/postgresql\/14\/main"/"\/data"/ /etc/postgresql/*/main/postgresql.conf

Feb 11 11:12:24 ip-10-12-1-184 postgresql@14-main[10891]: Error: Data directory /data must not be owned by root

Feb 11 11:24:33 ip-10-12-1-79 postgresql@14-main[9806]: pg_ctl: directory "/data" is not a database cluster directory

Feb 11 11:32:02 ip-10-12-1-79 postgresql@14-main[9871]: 2023-02-15 11:32:02.088 UTC [9876] DETAIL:  Permissions should be u=rwx (0700) or u=rwx,g=rx (0750).
Feb 11 11:32:02 ip-10-12-1-79 postgresql@14-main[9871]: 2023-02-15 11:32:02.088 UTC [9876] FATAL:  data directory "/data" has invalid permissions

data_directory

data_directory = '/var/lib/postgresql/10/main'

postgresql.conf:#data_directory = 'ConfigDir'		# use data in another directory

systemctl stop postgresql@14-main

See also

• postgresql.conf