data_directory symlinks

From: Kieren Scott <kierenscott(at)hotmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: data_directory symlinks
Date: 2014-03-12 15:44:09
Message-ID: DUB127-W24399E9071F1865BDAA8DCAE760@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Trustypg 9.3
Thanks in advance!

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dhananjay Singh 2014-03-12 16:47:47 Re: data_directory symlinks
Previous Message Moen, Paul T. 2014-03-10 21:33:22 pgbench Connection to database "bench" failed: