> -----Mensaje original----- > De: > > On Thursday 14 January 2010, Fernando Hevia elucidated thus: > > An Ubuntu install creates a postgres cluster automatically on > > /var/lib/postgresql/8.4/main Whats the best procedure for > moving this > > cluster to an other location? Should I just rerun initdb? > What happens > > then with the default cluster or how could I delete it? > > The easiest way is to shut down Pg, move the 'main' directory > somewhere else, and then point a symlink to the new location. >
Thanks for your reply. I had considered this first but then I wasn't sure if there would be any performance penalty. The current main directory sits on a 'slow' RAID 1 volume while the new one will sit on a 'fast' 12 disk RAID 10 volume. I guess the symlink shouldn't be troublesome but I don't know if some PG process will continually be reading this link encumbering somehow the RAID 1 disks. Regards, Fernando. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
