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

recover or move databases

From: PJ <af(dot)gourmet(at)videotron(dot)ca>
To: pgsql-admin(at)postgresql(dot)org
Subject: recover or move databases
Date: 2008-12-08 23:27:07
Message-ID: 493DAD4B.50005@videotron.ca (view raw or flat)
Thread:
Lists: 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

Responses

pgsql-admin by date

Next:From: Scott MarloweDate: 2008-12-08 23:36:31
Subject: Re: recover or move databases
Previous:From: Isabella GhiureaDate: 2008-12-08 22:20:35
Subject: dba and tables spaces questions

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