Re: - Mailing list pgsql-general

From He Weiping (Laser Henry)
Subject Re:
Date
Msg-id 39B30D1A.5018ABDC@zhengmai.com.cn
Whole thread Raw
In response to  ("JinMing Qiu" <cukechina@hotmail.com>)
List pgsql-general
JinMing Qiu wrote:

> Hello everyone! How to move a postgresql database to another
> directory?

I think the procedure below would work:

1, create the new directory and assign the read write previlege to
postgres  superuser;
2, shut down all your postmaster using command like (assume you are
using bash on linux):
postgres@db$ killall -SIGTERM postmaster
3, move the totally data base to the new directory using command like:

 postgres@db$   tar cvf - /the_old_db_location | tar  -C
/the_new_db_location xvf -

4, remove the file in old location: (of course, make a backup is a good
idea)
postgres@db$ rm -r /the_old_db_location

5, make a symbol link to the new location, thus avoid the environment
variable changes:

postgres@db$ln -s /the_new_db_location /the_old_db_location

6, restart your postmaster:
postgres@db$ (something you've used before)

that's it



pgsql-general by date:

Previous
From: "JinMing Qiu"
Date:
Subject: Ask Chris?
Next
From: Paul Hardiman
Date:
Subject: if (SQLCODE != 0) { sprintf(rMsg,"ERROR: ERROR on SELError Unknown type 'oid8'