Re: [BUGS] postgresSQL data directory

2005-07-08 Thread Thanh Q Lam
Thanks Richard! I finally got it work. It was caused byethe PGDATA environment variable. I fixed it the .cshrc and reran initdd, then everything's back to normal. Yes, our current postgres is very old and I'm setting up 7.4.8 on another box. Thanks again, Thanh Richard Huxton wrote:

Re: [BUGS] postgresSQL data directory

2005-07-08 Thread Richard Huxton
Thanh Q Lam wrote: Hi, We have a problems with postgresSQL 7.1.3 that suddenly all databases don't work, and it logged the following message, I'm sure you know that's an old version, but I'll recommend upgrading anyway. pq_recvbuf: unexpected EOF on client connection pq_recvbuf: unexpecte

[BUGS] postgresSQL data directory

2005-07-08 Thread Thanh Q Lam
Hi, We have a problems with postgresSQL 7.1.3 that suddenly all databases don't work, and it logged the following message, pq_recvbuf: unexpected EOF on client connection pq_recvbuf: unexpected EOF on client connection Smart Shutdown request at Fri Jul 8 09:19:47 2005 DEBUG: shutting down DE