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 :
> 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 Borse||Date: 2008-12-09 05:48:17|
|Subject: Re: dba and tables spaces questions|
|Previous:||From: PJ||Date: 2008-12-08 23:27:07|
|Subject: recover or move databases|