data_directory symlinks

Поиск
Список
Период
Сортировка
От Kieren Scott
Тема data_directory symlinks
Дата
Msg-id DUB127-W24399E9071F1865BDAA8DCAE760@phx.gbl
обсуждение исходный текст
Ответы Re: data_directory symlinks
Список pgsql-admin
Hi

By default pg_createcluster will create a new cluster in /var/lib/postgresql/<version>/<cluster>

I wan't to move my data_directory from this location to another volume (with lots more space). Is it best practice to set the data_directory location --datadir with pg_createcluster, or to just move the data_directory contents to the new volume and then create a symbolic link (as postgres) from /var/lib/postgresql/<version>/ to the new volume? This seems to be essentially the same thing, but I wondered if there were any gotcha's with using symbolic links in this way (e.g. if we tried to run multiple clusters on one host), rather than specifying the data_directory at pg_createcluster time - which subsequently sets this parameter in the postgresql.conf?

Ubuntu Trusty
pg 9.3

Thanks in advance!

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Moen, Paul T."
Дата:
Сообщение: pgbench Connection to database "bench" failed:
Следующее
От: Dhananjay Singh
Дата:
Сообщение: Re: data_directory symlinks