Re: [ADMIN] pg_hba.conf & putty

2007-03-06 Thread Moritz Bayer
Thanks a lot, the change of the tunnels IP address to 127.0.0.1 made it! :-) Great! 2007/3/6, Phillip Smith <[EMAIL PROTECTED]>: I know your problem (I think) Your SSH forward you said is defined as: Lserver.ip.address:5432 So the requests will be coming from your server's IP address

[ADMIN] postgres 8.2.3 transaction xid wraparound

2007-03-06 Thread Sriram Dandapani
I have been using postgres 8.1 for a while now with large databases (over 300-400G). The biggest issue I have faced is the routine vacuumdb command that takes care of the transaction id wraparound problem (I run this once a week on each postgres box and it takes about 24-48 hours depending on the l

[ADMIN] pg_dump and pg_dumpall is hanging

2007-03-06 Thread Karthikeyan Sundaram
Hi, I am using 8.1.0 for my production. The pg_dumpall was working fine on all these days. Suddenly from yesterday, the pg_dumpall command fails. Fails means, it hangs (no dump) is taking place. What may be the problem? Regards skarthi _