Re: [GENERAL] unstable postgres on freebsd

2006-10-24 Thread Wes Sheldahl
Yes, it's a VPS running FreeBSD 6.1, so presumably it's in a FreeBSD jail. I'll verify that with my hosting provider and probably follow up along these lines. http://www.postgresql.org/docs/8.1/interactive/kernel-resources.html seems to recommend running as different uid's as well. Right now it's r

Re: [GENERAL] unstable postgres on freebsd

2006-10-22 Thread Tom Lane
"Wes Sheldahl" <[EMAIL PROTECTED]> writes: > I seem to have an unstable/unreliable installation of postgresql, and I'm > not sure how to troubleshoot it. > Symptoms: > $ psql postgres > psql: FATAL: semctl(851974, 3, SETVAL, 0) failed: Invalid argument AFAICS the only documented reason for that s

Re: [GENERAL] unstable postgres on freebsd

2006-10-21 Thread Marc G. Fournier
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Are you running this in a FreeBSD jail under 6.1? It sounds like the problem that I had where a second postmaster starts up and stomp's on the previous postgresql's shared memory ... To "fix", you have to make sure that both instances run as diffe

[GENERAL] unstable postgres on freebsd

2006-10-20 Thread Wes Sheldahl
Hi,I seem to have an unstable/unreliable installation of postgresql, and I'm not sure how to troubleshoot it.Symptoms:$ psql postgrespsql: FATAL:  semctl(851974, 3, SETVAL, 0) failed: Invalid argument (restart postgresql)$ psql postgresWelcome to psql 8.1.4, the PostgreSQL interactive terminal.(res