Re: [ADMIN] PANIC while doing failover (streaming replication)

2011-07-01 Thread Simon Riggs
On Fri, Jul 1, 2011 at 6:54 AM, Fujii Masao masao.fu...@gmail.com wrote: http://archives.postgresql.org/pgsql-hackers/2008-12/msg01335.php According to the above thread, this issue seems to exist for a few years, and be unsolved yet. Could you provide a self-contained test case? I'll add some

Re: [ADMIN] Import image into postgresql database

2011-07-01 Thread Gabriele Bartolini
Ciao Francesco, On Fri, 1 Jul 2011 12:13:33 +0200 (CEST), francescobocca...@libero.it francescobocca...@libero.it wrote: I tried to insert in both ways. With oid type i able to insert images, but with bytea i don't understand how store it . I would definitely suggest to use 'bytea' column

Re: [ADMIN] PANIC while doing failover (streaming replication)

2011-07-01 Thread Mikko Partio
http://archives.postgresql.org/pgsql-hackers/2008-12/msg01335.php According to the above thread, this issue seems to exist for a few years, and be unsolved yet. Could you provide a self-contained test case? I can try ... In related to this, after the failover we got several other worrying

R: Re: [ADMIN] Import image into postgresql database

2011-07-01 Thread francescobocca...@libero.it
Thanks, Francesco Messaggio originale Da: gabriele.bartol...@2ndquadrant.it Data: 01/07/2011 12.27 A: francescobocca...@libero.it Cc: pgsql-admin@postgresql.org Ogg: Re: [ADMIN] Import image into postgresql database Ciao Francesco, On Fri, 1 Jul 2011 12:13:33 +0200 (CEST),

[ADMIN] Help compiling --with-ldap on Solaris 11 Express?

2011-07-01 Thread Dave Pooser
TL; DR version: I'm trying to compile 9.0.4 on Solaris 11 Express and having problems with LDAP support; I finally got it to compile and install but when I try to authenticate via LDAP I get Assertion failed: LBER_VALID( ber ), file sasl.c, line 103, function ldap_sasl_bind and it kills the

Re: [ADMIN] Help compiling --with-ldap on Solaris 11 Express?

2011-07-01 Thread Achilleas Mantzios
Looking in openldap-2.4.10/libraries/liblber/lber-int.h:94 i see : #define LBER_VALID(ber) ((ber)-ber_valid==LBER_VALID_BERELEMENT) the assertion fails for some reason. Could you make a proper reinstallation of the openldap related packages (openldap-client and possibly -devel), remove the

Re: [ADMIN] Parallel pg_dump on a single database

2011-07-01 Thread Tom Lane
Bob Lunney bob_lun...@yahoo.com writes: Is it possible (or smart!) to run multiple pg_dumps simulataneously on a single database, dumping different parts of the database to different files by using table and schema exclusion? I'm attempting this and sometimes it works and sometimes when I

Re: [ADMIN] Parallel pg_dump on a single database

2011-07-01 Thread Bob Lunney
Tom, Thanks for the response, but I figured out the error is mine, not pg_dump's.   In short (to minimize my embarrassment!) don't write to the same file from three different pg_dumps.  The good news is running multiple pg_dumps simultaneously on a single database with exclusive coverage of