pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedrecover or move databases
2+ messages / 2 participants
[nested] [flat]
* recover or move databases
@ 2008-12-08 23:27 PJ <af.gourmet@videotron.ca>
2008-12-08 23:36 ` Re: recover or move databases Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: PJ @ 2008-12-08 23:27 UTC (permalink / raw)
To: pgsql-admin
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,
PJ
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: recover or move databases
2008-12-08 23:27 recover or move databases PJ <af.gourmet@videotron.ca>
@ 2008-12-08 23:36 ` Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Scott Marlowe @ 2008-12-08 23:36 UTC (permalink / raw)
To: PJ <af.gourmet@videotron.ca>; +Cc: pgsql-admin
On Mon, Dec 8, 2008 at 4:27 PM, PJ <af.gourmet@videotron.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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-12-08 23:36 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-12-08 23:27 recover or move databases PJ <af.gourmet@videotron.ca>
2008-12-08 23:36 ` Scott Marlowe <scott.marlowe@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox