Sample Header Ad - 728x90

Need to Alter PostgreSQL Startup on CentOS 7?

0 votes
1 answer
207 views
I am planning a move of Postgres' data directory from one disk to another on a CentOS 7 server. All of the data and configuration files reside in /var/lib/pgsql/12/data/. I have previously migrated data directories before, but this time I am going to migrate the configuration files (postgresql.conf, pg_hba.conf, etc.) from the existing data directory to a new one in /etc. I see that the postgresql.conf file has the following file location configurations, with the caveat that they are driven from the -D option on startup, however startup is managed through systemctl:
#data_directory = 'ConfigDir'
#hba_file = 'ConfigDir/pg_hba.conf'
#ident_file = 'ConfigDir/pg_ident.conf'
So my question is: Will the changes in postgresql.conf be all that needs to occur so the database starts up after migration -OR- is there something within systemctl that needs to change in tandem with the configuration so it starts up as expected?
Asked by vPilot (47 rep)
Jul 27, 2021, 06:43 PM
Last activity: Jul 27, 2021, 08:27 PM