[ADMIN] Postgres user with a shell of /bin/false

2009-05-21 Thread Cliff Pratt
I've browsed my history of the list, and the Internet for information regarding giving the unix 'postgres' user a shell of /bin/false, so that it cannot be logged into directly. It seems from my research that if I set the user's shell to /bin/false it will not prevent the running of postgres itself

[ADMIN] cascade deleting

2009-05-21 Thread Duan Ligong
Hi. I am wondering whether the following problem can be avoided by using Cascade Deleting while the DB is in Read Committed Isolation Level: In the following scenario, The "DEL item1 from tb_pk" command fails because of involating foreign key constraints. (The tb_fk1, tb_fk2, and tb_fk3 tab

Re: [ADMIN] Audit Log Destination

2009-05-21 Thread Arnold, Sandra
Actually PostgreSQL calls it logging. I am using the "csv" form of logging. I am logging connections, disconnections, and statements. I can use this for auditing purposes. -Original Message- From: Peter Eisentraut [mailto:pete...@gmx.net] Sent: Wednesday, May 20, 2009 6:49 PM To: pgsq

Re: [ADMIN] [GENERAL] compilation test fails

2009-05-21 Thread Tom Lane
"Sofer, Yuval" writes: > I have compiled 8.3.7 on HP-Itanium > After the build I have continued to the tests (gmake check) > One of the tests failed (division by zero error test) Hm, what compiler and what optimization level? We have seen a report or two about this before, all from people using

[ADMIN] virtual savings

2009-05-21 Thread Ray Stell
>From interop attending, IT golf guys: "Yet 55 percent told the network analysis vendor they experience more problems than benefits with the technology, while the remaining 45 percent said they had realized the benefits of virtualization. Among the problems were a lack of visibility and tools to t

Re: [ADMIN] [GENERAL] Inserts hang in DB and error messages in log

2009-05-21 Thread Bill Moran
In response to "Moshe Ben-Shoham" : > > We're working with version 8.3.5-1. > > Lately we started seeing insert statements hang in the DB. The > statements come from two different clients. > > When it happens, I see the following messages in the log every second or > so: > > 2009-05-21 08:56:49

Re: [ADMIN] [GENERAL] Inserts hang in DB and error messages in log

2009-05-21 Thread Adrian Klaver
On Wednesday 20 May 2009 11:36:38 pm Moshe Ben-Shoham wrote: > Hi, > > > > We're working with version 8.3.5-1. > > > > Lately we started seeing insert statements hang in the DB. The > statements come from two different clients. > > > > When it happens, I see the following messages in the log every

[ADMIN] compilation test fails

2009-05-21 Thread Sofer, Yuval
Hi, I have compiled 8.3.7 on HP-Itanium After the build I have continued to the tests (gmake check) One of the tests failed (division by zero error test) The regression.diffs file shows the diff regarding of the expected result and the actual result: *** ./expected/errors.out Sat Nov 10 1