Re: [HACKERS] postgres 9.0 crash when bringing up hot standby
От | Alanoly Andrews |
---|---|
Тема | Re: [HACKERS] postgres 9.0 crash when bringing up hot standby |
Дата | |
Msg-id | 09B23E7BF70425478C1330D893A722C602FEC019C6@MailSVR.invera.com обсуждение исходный текст |
Ответ на | Re: [HACKERS] postgres 9.0 crash when bringing up hot standby (Robert Haas <robertmhaas@gmail.com>) |
Список | pgsql-admin |
Ok..in response to the questions from Heikki, 1. Yes, "contrib/dblink" does work. Here's the output from the command used to "make" dblink: postgres:thimar> /usr/bin/gmake -C contrib/dblink install gmake: Entering directory `/dinabkp/faouzis/postgresql-9.0beta1/contrib/dblink' /bin/sh ../../config/install-sh -c -d '/dinabkp/faouzis/local2/pgsql/lib' /bin/sh ../../config/install-sh -c -d '/dinabkp/faouzis/local2/pgsql/share/contrib' /bin/sh ../../config/install-sh -c -m 755 dblink.so '/dinabkp/faouzis/local2/pgsql/lib/dblink.so' /bin/sh ../../config/install-sh -c -m 644 ./uninstall_dblink.sql '/dinabkp/faouzis/local2/pgsql/share/contrib' /bin/sh ../../config/install-sh -c -m 644 dblink.sql '/dinabkp/faouzis/local2/pgsql/share/contrib' gmake: Leaving directory `/dinabkp/faouzis/postgresql-9.0beta1/contrib/dblink' 2. I don't have records of the build logs for the regular postgres executables (which contains the libpqwalreceiver) butcan do a new compile/make if that is required. But they were compiled and installed using the regular make files suppliedalong with the postgres source code. The following flags were added during the compilation: --without-readline --without-zlib --enable-debug --enable-cassert --enable-thread-safety Thanks. Alanoly. -----Original Message----- From: Robert Haas [mailto:robertmhaas@gmail.com] Sent: Wednesday, August 11, 2010 10:13 AM To: Heikki Linnakangas Cc: Alanoly Andrews; pgsql-admin@postgresql.org; PostgreSQL-development Subject: Re: [HACKERS] [ADMIN] postgres 9.0 crash when bringing up hot standby On Fri, Aug 6, 2010 at 3:53 PM, Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> wrote: > So, loading libpqwalreceiver library crashes. It looks like it might be > pthread-related. Perhaps something wrong with our makefiles, causing > libpqwalreceiver to be built with wrong flags? Does contrib/dblink work? If > you look at the build log, what is the command line used to compile > libpqwalreceiver, and what is the command line used to build other > libraries, like contrib/dblink? I haven't seen any response to this from the OP, but it seems worrisome. Has anyone else tested a Hot Standby configuraration - successfully or otherwise - on AIX? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company **************************************************** This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Anydistribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized.If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately. Ce courriel est confidentiel et prot�g�. L'exp�diteur ne renonce pas aux droits et obligations qui s'y rapportent. Toutediffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les)destinataire(s) d�sign�(s) est interdite. Si vous recevez ce courriel par erreur, veuillez m'en aviser imm�diatement,par retour de courriel ou par un autre moyen. ****************************************************
В списке pgsql-admin по дате отправления:
Предыдущее
От: Robert HaasДата:
Сообщение: Re: [HACKERS] postgres 9.0 crash when bringing up hot standby