PostgreSQL Administration - Problem in restore data

Author

Problem in restore data

Ramesh Patel

2005-08-11, 3:25 am

Dear All

My FC3 is cresh . but i copy my /usr/local/pgsql/data folder

how to i use this folder for replace data.

Please help me

Ramesh Patel
System Dept.
Banasdairy, Palanpur(B.K.)
E-Mail : ramesh@banasdairy.coop
Mobile : 94263 91295

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Alvaro Herrera

2005-08-11, 1:27 pm

On Thu, Aug 11, 2005 at 01:03:24PM +0530, Ramesh Patel wrote:
> Dear All
>
> My FC3 is cresh . but i copy my /usr/local/pgsql/data folder
>
> how to i use this folder for replace data.

Install the same version of Postgres in a similar server, do not start
it, and drop the "data" folder somewhere. Then start the postmaster
giving the -D option pointing to that directory.

--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org> )
"I would rather have GNU than GNOT." (ccchips, lwn.net/Articles/37595/)

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Sponsored Links