Re: backup restore - Mailing list pgsql-admin

From Andrew Rawnsley
Subject Re: backup restore
Date
Msg-id 688D8595-14BD-11D8-86F5-000393A47FCC@ravensfield.com
Whole thread Raw
In response to backup restore  ("Colm De Barra" <colm@aruke.com>)
List pgsql-admin
You ought to be able to just start up Postgres pointing to the existing
data. So assuming the
data directory is /db, just doing 'postmaster -D /db' should work.

Provided, of course, you installed the exact version that was there
before, with the same user/uid
as before.

On Nov 11, 2003, at 9:51 PM, Colm De Barra wrote:

> Hi
> I'm in charge of a linux DB server running postgres 7.3.2.
> The OS disk recently died taking the postgres installation
> with it but the data directory of postgres was on a seperate SCSI
> disk and is still OK.
>  
> I've put in a new OS disk, installed linux on it again, mounted the
> data
> disk, and installed postgres up as far as the "make install" stage. 
> Can anyone tell me where to go from here to get postgres to run with
> the
> old DB ?? is all the DB structure information stored in the data
> directory ?
>  
> Any help would be appreciated
> Colm
>  
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> If a kid asks where rain comes from, I think a cute
> thing to tell him is, "God is crying." And if he asks
> why God is crying, another cute thing to tell him is, "Probably
> because of something you did."
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>  
>      My Website  :http://www.angelfire.com/ia/japan/
>      BoomBox     :http://www.b00mb0x.org
>  
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
--------------------

Andrew Rawnsley
President
The Ravensfield Digital Resource Group, Ltd.
(740) 587-0114
www.ravensfield.com


pgsql-admin by date:

Previous
From: "Colm De Barra"
Date:
Subject: backup restore
Next
From: Shane Wright
Date:
Subject: Re: Trying to pg_restore a 7.1.3 db into 7.3.4 - stalling