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

[ATM L. <atm...@km...>]

Thanks Angus,
	Yes, my data was at /var/lib/pgsql/data, however no config file at
/etc/sysconfig/pgsql/posgresql  (ends at pgsql)

I cannot find PGDATA or PG_DATA on my system, but working remotely.. So will
look harder when I get back home...

	Anyone know what file I have to change on a SME 7.xx box?  I was
able to SCP the data over to /sql-old/data


---Andrew




-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of Angus
Carr
Sent: May 2, 2006 5:29 PM
To: sql...@li...
Subject: Re: [SL] Where does SL keep the data, and can you move data from
dead system to new system?

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



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