Re: Moving data directory

From: "Srinivas Kotapally" <ksrinivas(at)coriendo(dot)com>
To: "'Linux Geeks'" <indolinux(dot)geeks(at)gmail(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Moving data directory
Date: 2007-05-12 16:53:34
Message-ID: 026d01c794b6$14f29770$800101df@srinilaptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org]
On Behalf Of Linux Geeks
Sent: Saturday, May 12, 2007 12:48 PM
To: pgsql-admin(at)postgresql(dot)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(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Linux Geeks 2007-05-12 17:57:57 Re: Moving data directory
Previous Message Linux Geeks 2007-05-12 16:47:46 Moving data directory