Re: Changing the data directory path before the initial configuration of PostgreSQL 10.7.1

Поиск
Список
Период
Сортировка
От Keith Christian
Тема Re: Changing the data directory path before the initial configuration of PostgreSQL 10.7.1
Дата
Msg-id CAFWoy7GO_gXyjAyFAX_OPqc19U3HiBtVcOH76hgP2R=RmrQPow@mail.gmail.com
обсуждение исходный текст
Ответ на Changing the data directory path before the initial configuration of PostgreSQL 10.7.1  (Keith Christian <keith1christian@gmail.com>)
Список pgsql-general

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 по дате отправления:

Предыдущее
От: Keith Christian
Дата:
Сообщение: Changing the data directory path before the initial configuration of PostgreSQL 10.7.1
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Missing rows after migrating from postgres 11 to 12 with logical replication