Re: [SL] Where does SL keep the data, and can you move data from dead system to new system?

[Ted O. <te...@on...>]

PG_DATA is an environment variable that tells postgres where its databases are. 
  If you copy the data to /tmp/pgsql/data and set PG_DATA=/tmp/pgsql/data and 
start up postgres, you should be able to read you database.

You need to make sure you are running the same version of postgres on your new 
box that you were running on your old box.

ATM Logic wrote:
> Thanks Dieter, 
> 
> 	Can you help me or 'point' me in the right direction to get a little
> bit more info about 'pointing to PG_DATA'  
> 
> Thanks,
> Andrew
> 
> -----Original Message-----
> From: sql...@li...
> [mailto:sql...@li...] On Behalf Of Dieter
> Simader
> Sent: May 2, 2006 10:41 AM
> To: sql...@li...
> Subject: Re: [SL] Where does SL keep the data, and can you move data from
> dead system to new system?
> 
> copy /usr/local/pgsql/data to a new drive and directory and point PG_DATA to
> it. With the same version of postgres you should be able to read the data.
>