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: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org]
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 majordomo@postgresql.org so that your
message can get through to the mailing list cleanly