Thread: backup restore
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."
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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."
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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