Difference between revisions of "PostgreSQL data directory"

From wikieduonline
Jump to navigation Jump to search
Line 11: Line 11:
  
 
  data_directory = '/var/lib/postgresql/10/main'
 
  data_directory = '/var/lib/postgresql/10/main'
 +
 +
 +
systemctl stop postgresql@14-main
  
 
{{postgreSQL.conf}}
 
{{postgreSQL.conf}}

Revision as of 11:27, 15 February 2023


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


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


systemctl stop postgresql@14-main

postgresql.conf

Advertising: