Postgres Pro
Downloads
Home   >   mailing lists

Re: Changing the data directory path before the initial configuration of PostgreSQL 10.7.1 - Mailing list pgsql-general

From Keith Christian
Subject Re: Changing the data directory path before the initial configuration of PostgreSQL 10.7.1
Date
Msg-id CAFWoy7GO_gXyjAyFAX_OPqc19U3HiBtVcOH76hgP2R=RmrQPow@mail.gmail.com
Whole thread Raw
In response to Changing the data directory path before the initial configuration of PostgreSQL 10.7.1  (Keith Christian <keith1christian@gmail.com>)
List pgsql-general
Tree view

The easiest way is moving /var/lib/pgsql/data under /xyz directory
(when the db is not running) and create a symlink in the original
location:

chown postgres: /xyz
su - postgres
mv /var/lib/pgsql/data /xyz/10-data
ln -s /xyz/10-data /var/lib/pgsql/data

Then you can use setup script as usual.

Another alternative is creating a copy of the unit file under
/etc/systemd/system, changing $PGDATA inside that file and run the
setup script. This should be documented on the top of the unit file.

Devrim,

Appreciate your quick reply and complete insructions, I'm certain that will work!

Thank you.


pgsql-general by date:

Previous
From: Keith Christian
Date:
Subject: Changing the data directory path before the initial configuration of PostgreSQL 10.7.1
Next
From: Adrian Klaver
Date:
Subject: Re: Missing rows after migrating from postgres 11 to 12 with logical replication