Thread: backup restore

backup restore

From
"Colm De Barra"
Date:
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
 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Re: backup restore

From
Andrew Rawnsley
Date:
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