Hi,
a week ago, we have migrated our production setup -- three amd64
machines on RHEL4 running only postgres and slony -- from pg 8.1 to
pg 8.4.
Since 8.4, we encounter rare crashes (between two and ten times
per day for the whole setup) of single backend server processes,
loosely related to very
On 19/03/2010 8:34 PM, Dennis Koegel wrote:
We automatically SIGTERM long running queries (bad situation, of
course, but necessary under certain load conditions here). This has
been the case for 8.1 as well and worked fine ever since. Even with
8.4 it works fine most of the time.
I'm not sayin
The following bug has been logged online:
Bug reference: 5380
Logged by: Krishnamoorthy
Email address: krishnac...@gmail.com
PostgreSQL version: 8.0.3
Operating system: RHEL 3
Description:error in xlog
Details:
Dear Sir/Mam.
Kindly find the below error,when i am t
The following bug has been logged online:
Bug reference: 5383
Logged by: Roberto Rivera Mardones
Email address: rorive...@gmail.com
PostgreSQL version: 8.4.2
Operating system: Debian 5
Description:Problemas con GROUP BY
Details:
Si hago esto:
SELECT SUM(campo1), cam
The following bug has been logged online:
Bug reference: 5384
Logged by: Jon Nelson
Email address: jnel...@jamponi.net
PostgreSQL version: 8.4.2
Operating system: openSUSE 11.2
Description:pg_dump hard-codes use of /tmp
Details:
I was trying to dump a database (with
Dennis Koegel writes:
> [ crash when a SQL function is killed by SIGTERM ]
Frankly, I would expect this to fail with even higher probability in
8.1. We didn't even pretend that SIGTERM'ing individual backends was
a safe thing to do in 8.1. You ought to rethink your connection
management methodo
"Jon Nelson" writes:
> I was trying to dump a database (with --format=tar).
Do you have a really good reason to be using tar rather than custom
format? If so what is it?
> 1. why is pg_dump using a temporary directory (other than the $CWD) anyway?
Tar format is sufficiently weird that we have
On Tue, Mar 16, 2010 at 3:06 AM, beulah prasanthi wrote:
> i deleted DB and created new DB when i execute my queries i got the
> following error.please help me
>
> could not load library "C:/Program Files/PostgreSQL/8.4/lib/pldbgapi.dll":
> The specified module could not be found
Please see:
h
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, Mar 19, 2010 at 05:30:30AM +, Krishnamoorthy wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5380
> Logged by: Krishnamoorthy
> Email address: krishnac...@gmail.com
> PostgreSQL version: 8.0.3
>