Skip site navigation (1) Skip section navigation (2)


From: Alanoly Andrews <alanolya(at)invera(dot)com>
To: 'Steve Singer' <ssinger(at)ca(dot)afilias(dot)info>
Cc: 'Fujii Masao' <masao(dot)fujii(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>,"pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: [HACKERS] HS/SR on AIX
Date: 2010-08-27 19:57:40
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-adminpgsql-hackers

I have tried all the LIBPATH's that you suggested. Besides, I don't think the problem is that postgres cannot find the "libpqwalreceiver" library. It does find it, but crashes on loading it. See below a repeat of the copy and paste from my first post, showing the sequence just before the crash:

(dbx) where
_alloc_initial_pthread(??) at 0x90000000049567c
__pth_init(??) at 0x900000000493ba4
uload(??, ??, ??, ??, ??, ??, ??, ??) at 0x9fffffff0001954
load_64.load(??, ??, ??) at 0x90000000004686c
loadAndInit() at 0x90000000047bd7c
dlopen(??, ??) at 0x90000000011cc4c
internal_load_library(libname = "/apps/pg_9.0_b4/lib/postgresql/"), line 234 in "dfmgr.c"
load_file(filename = "libpqwalreceiver", restricted = '\0'), line 156 in "dfmgr.c"
WalReceiverMain(), line 248 in "walreceiver.c"
AuxiliaryProcessMain(argc = 2, argv = 0x0fffffffffffa8b8), line 428 in "bootstrap.c"
StartChildProcess(type = WalReceiverProcess), line 4405 in "postmaster.c"
sigusr1_handler(postgres_signal_arg = 30), line 4227 in "postmaster.c"
__fd_select(??, ??, ??, ??, ??) at 0x90000000011805c = 5, __readlist = 0x0fffffffffffd0a8, __writelist = (nil), __exceptlist = (nil), __timeout = 0x0ffffffffffff0c0), line 229 in "time.h"
unnamed block in ServerLoop(), line 1391 in "postmaster.c"
unnamed block in ServerLoop(), line 1391 in "postmaster.c"
ServerLoop(), line 1391 in "postmaster.c"
PostmasterMain(argc = 1, argv = 0x00000001102aa4b0), line 1092 in "postmaster.c"
main(argc = 1, argv = 0x00000001102aa4b0), line 188 in "main.c"


-----Original Message-----
From: Steve Singer [mailto:ssinger(at)ca(dot)afilias(dot)info] 
Sent: Friday, August 27, 2010 3:45 PM
To: Alanoly Andrews
Cc: 'Fujii Masao'; Tom Lane; PostgreSQL-development Hackers; pgsql-admin(at)postgresql(dot)org
Subject: Re: [HACKERS] HS/SR on AIX

Alanoly Andrews wrote:
> Fujii,
> All my tests so far were done on "clean" installs. Every version I tested on, beta2 through beta4, was compiled and installed in different and unique directories.
> Regards.


If you do an
export LIBPATH=/apps/pg_9.0_b4/lib
before starting postgres on the replica does it make a difference?

How about with a LIBPATH=/apps/pg_9.0_b4/lib/postgresql

(I'm not exactly sure where libpq.a is on your install)

> Alanoly.

Steve Singer
Afilias Canada
Data Services Developer
This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, 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 protg. L'expditeur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) dsign(s) est interdite. Si vous recevez ce courriel par erreur, veuillez m'en aviser immdiatement, par retour de courriel ou par un autre moyen.

In response to


pgsql-hackers by date

Next:From: Tom LaneDate: 2010-08-27 20:02:52
Subject: Re: Git conversion progress report and call for testing assistance
Previous:From: Steve SingerDate: 2010-08-27 19:45:26
Subject: Re: [HACKERS] HS/SR on AIX

pgsql-admin by date

Next:From: Tom LaneDate: 2010-08-27 20:21:08
Subject: Re: [HACKERS] HS/SR on AIX
Previous:From: Steve SingerDate: 2010-08-27 19:45:26
Subject: Re: [HACKERS] HS/SR on AIX

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group