[ADMIN] Postgres 8.0 Log Configuration

2005-01-21 Thread Pallav Kalva
Hi, Whenever i start my postgres 8 server i do "pg_ctl restart -D /var/lib/pgsql/data -l /var/log/postgresql/postmaster" where /var/log/postgresql/ is the dir and postmaster is the output log file for all postgres logging and errors. This above command works fine and logs all the postgres r

Re: [ADMIN] [GENERAL] Restoring fscked up postgres 7.1

2005-01-21 Thread Kristaps Armanis
Friday, January 21, 2005, 5:30:07 PM, Jus rakstijat: MvO> Looks like XID wraparound, you hit the 4 billion transaction mark. This MvO> was fixed in 7.2 IIRC. Unfortunatly I don't know of an easy way to MvO> recover, but this should give you something to search the archives for. Till how sorted th

Re: [ADMIN] Trouble Escaping Quotes

2005-01-21 Thread Haron, Charles
Yes, but how do you escape the quote when the value of the string isn't know until the function is run? If $rma_data->{\'company_name\'} is returning Bob's Fixit at run time, how do escape the quote BEFORE Perl interprets the string and generates an error? Regards, Chuck > -Original Message

Re: [ADMIN] [GENERAL] Restoring fscked up postgres 7.1

2005-01-21 Thread Martijn van Oosterhout
On Fri, Jan 21, 2005 at 03:33:28PM +0200, Kristaps Armanis wrote: > Last night no crash, not anything, just @ one moment all records for > last year where gone, all ros created for last year & tables created > while this time - and not in only one database, but all 6 DB's on this > server. Looks l

[ADMIN] Restoring fscked up postgres 7.1

2005-01-21 Thread Kristaps Armanis
Greetings, Some really strange things happened here. We were using old 7.1 postgres on 2.4 linux and db files living on ext3 partition for some time, vacuuming regulary and not upgrading only because software didn't worked with 7.2+. (developers where in progress, but not yet). Last night no cra