Skip site navigation (1) Skip section navigation (2)

Re: recover or move databases

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: PJ <af(dot)gourmet(at)videotron(dot)ca>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: recover or move databases
Date: 2008-12-08 23:36:31
Message-ID: dcc563d10812081536l3274927aia1a3a52904453c07@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Mon, Dec 8, 2008 at 4:27 PM, PJ <af(dot)gourmet(at)videotron(dot)ca> wrote:
> I am trying to recover postgres databases from a crashed disk.
> I have set up a new installation of FreeBSD 7.0 with postgresql8.3.
> The old databases are accessible when the repaired disk is mounted :
> /oldfsb/local/pgsql/data/base/.
> How can I move these databases to the new /usr/local/pgsql/data/base/ ?
> Old and new are both v. 8.3
> Copying does not do it.
> This seems to be one way, but it seems rather long... and complicated..
> Any help would be appreciated,

Not copy, you need to start the postmaster on the old directory, use
pg_dump or pg_dumpall to get the data out, the stop the db and start
it back up on the new directory and use psql or pg_restore.

In response to

pgsql-admin by date

Next:From: Suresh BorseDate: 2008-12-09 05:48:17
Subject: Re: dba and tables spaces questions
Previous:From: PJDate: 2008-12-08 23:27:07
Subject: recover or move databases

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group