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
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
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
"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
>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
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
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
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