You can do an initdb -d /var/lib/postgresql to initialize the data directory in the /var/lib/postgresql directory. If you also have data in the /usr/lib/postgresql - make sure you back it up and restore it in the new directory.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Linux Geeks Sent: Saturday, May 12, 2007 12:48 PM To: pgsql-admin@postgresql.org Subject: [ADMIN] Moving data directory Hi All, I'm very new to postgresql and would like to move my data directory to another partition in Ubuntu. The standard installation is in /usr/lib/postgresql. How do I move it into /var/lib/postgresql. Regards, Dino -- To Analyze Is To Know Batte Field, Differ from Battle Itself ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
