[BUGS] BUG #2609: server crash at 182 connections still alive.

2006-09-07 Thread Joek Hondius
The following bug has been logged online: Bug reference: 2609 Logged by: Joek Hondius Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Windows Description:server crash at 182 connections still alive. Details: See BUG #1641: Server crash at

Re: [BUGS] BUG #2600: dblink compile with SSL missing

2006-09-07 Thread Christopher Browne
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Bruce Momjian) wrote: > Where are we on this? Nothing submitted so far. If someone magically does something about it, that's super. I'm on vacation 'til Tuesday; if it's not dealt with, I'll see if I can find something. -- (format

[BUGS] Wishlist: Please ad a switch to dectivate the comments in the dump

2006-09-07 Thread Daniel Migowski
This would greatly reduce the effords for me do use a diff on two dumps to check for new stuff to insert. There has been a similar discussion some years ago, so i guess that I am not the only one who would benefit from this. Thanks in advance, Daniel Migowski -- |¯¯|¯¯|Ingenieurbüro

[BUGS] BUG #2608: dblink compile fails on AIX 5.3

2006-09-07 Thread Michael Hoffmann
The following bug has been logged online: Bug reference: 2608 Logged by: Michael Hoffmann Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.2 Operating system: AIX 5.3 Description:dblink compile fails on AIX 5.3 Details: >/usr/local/pgsql/src/postgresql-8.1.2

Re: [BUGS] BUG #2600: dblink compile with SSL missing libraries

2006-09-07 Thread Chris Browne
[EMAIL PROTECTED] (Peter Eisentraut) writes: > Am Mittwoch, 30. August 2006 22:57 schrieb Chris Browne: >> I also seem to recall, in past discussions about "library matters," >> that AIX is more sticky about requiring that libraries be named >> expressly. > > ecpglib has > > SHLIB_LINK = -L../pgtyp

Re: [BUGS] BUG #2600: dblink compile with SSL missing libraries

2006-09-07 Thread Chris Browne
The change Tom made to contrib/sshinfo/Makefile to support Darwin, adding in $(LIBS), fixed my problem with that contrib module on AIX. I still need the following, on AIX: === RCS file: /projects/cvsroot/pgsql/contrib/dblink/Makefile

Re: [BUGS] Hanging queries on Windows 2003 SP1

2006-09-07 Thread Wei Song
Hi Magnus,Sure, I could try that out. Is there a place to download a 8.2 image to bypass setting up the tool chain?-WeiOn 9/4/06, Magnus Hagander <[EMAIL PROTECTED]> wrote:> Hi, >> We are seeing hanging queries on Windows 2003 Server SP1 with dual> CPU, looks like one of the process is blocked. In

Re: [BUGS] BUG #2606: (libpq) incorrect function declaration

2006-09-07 Thread Bruce Momjian
Marc ROGLIANO wrote: > > The following bug has been logged online: > > Bug reference: 2606 > Logged by: Marc ROGLIANO > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1.4 > Operating system: Windows XP > Description:(libpq) incorrect function declaration in

Re: [BUGS] BUG #2609: server crash at 182 connections still alive.

2006-09-07 Thread Shelby Cain
Confirmed here. I configured Postgresql to handle 200 connections and used a perl test script to open multiple connections to the database. The postmaster crashes consistently when the 182nd connection is opened. select version(); "PostgreSQL 8.1.4 on i686-pc-mingw32, compiled by GCC gcc.exe (

Re: [BUGS] Wishlist: Please ad a switch to dectivate the comments in the dump

2006-09-07 Thread Tom Lane
Daniel Migowski <[EMAIL PROTECTED]> writes: > This would greatly reduce the effords for me do use a diff on two dumps > to check for new stuff to insert. Try a newer version of pg_dump. regards, tom lane ---(end of broadcast)--

Re: [BUGS] [HACKERS] Template0 age is increasing speedily.

2006-09-07 Thread Merlin Moncure
On 9/7/06, Nimesh Satam <[EMAIL PROTECTED]> wrote: We also noticed that the database slow downs heavily at a particular time..Can you suggest any tools which will help in diagnosing the root cause behiond the data load. possible checkpoint? poorly formulated query? it could be any number of t

Re: [BUGS] [PATCHES] BUG #2600: dblink compile with SSL missing libraries

2006-09-07 Thread Albe Laurenz
Chris Browne wrote: >>> I also seem to recall, in past discussions about "library matters," >>> that AIX is more sticky about requiring that libraries be named >>> expressly. >> >> ecpglib has >> >> SHLIB_LINK = -L../pgtypeslib -lpgtypes $(libpq) \ >> $(filter -lintl -lssl -lcrypto -lkrb5 -