Re: backup restore

From: Andrew Rawnsley <ronz(at)ravensfield(dot)com>
To: "Colm De Barra" <colm(at)aruke(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: backup restore
Date: 2003-11-12 03:07:54
Message-ID: 688D8595-14BD-11D8-86F5-000393A47FCC@ravensfield.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message pginfo 2003-11-12 05:19:13 Re: vacuum full problem
Previous Message Colm De Barra 2003-11-12 02:51:18 backup restore