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

[Angus C. <ac...@sa...>]

Hi, Andrew,

On my system (Fedora-based) PGDATA points by default to 
/var/lib/pgsql/data, but that's postgres 8.1.3. For earlier versions, it 
was /var/lib/pgsql

You can override it by putting entries into /etc/sysconfig/pgsql/posgresql

What I would do is copy the files off the old machine, then start an 
extra copy of postgresql to interpret the data and pgdump it to a dump 
file. The command line switches for the postmaster can point it to an 
unusual PGDATA location and an unusual port number so you can run it 
concurrently.

You will need a corresponding version of postgresql, however, and that 
will be your biggest challenge, most likely. Other than that, it's 
fairly simple.

I automate the daily dump for archiving purposes, myself. The dump gets 
checked into a subversion repository on another machine, and I can 
reconstruct a local copy for testing with no fear of back-contamination. 
That lets me test new revisions of SL without fear of having problems.

Angus.

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.
>
>