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
Last activity: Jul 27, 2021, 08:27 PM