Re: data_directory symlinks

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Either way is good. You can either create symlinks or move data directory to new mount point. Both will work fine.
You can also use use pg_ctl -D to point to new data_directory.

Regards
Dhananjay
OpenSCG


On Wednesday, 12 March 2014 9:15 PM, Kieren Scott <kierenscott@xxxxxxxxxxx> wrote:
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!



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux