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

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

The environment variable is PGDATA (not PG_DATA) on my system.

Ted Onley wrote:
> 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.
>>
> 
> 
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job 
> easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>