From: Steve Singer <ssinger@ca.afilias.info>
To: PostgreSQL-development Hackers <pgsql-hackers@postgresql.org>
Subject: HS/SR on AIX
Date: Tue, 24 Aug 2010 17:39:57 -0400
Message-ID: <4C743C2D.1060209@ca.afilias.info> (raw)
I think I've been able to reproduce the issue floating around with
streaming replication on AIX.
LOG: could not bind IPv6 socket: The socket name is already in use.
HINT: Is another postmaster already running on port 5433? If not, wait
a few seconds and retry.
LOG: database system was shut down in recovery at 2010-08-24 21:08:37 UTC
LOG: entering standby mode
cp: cannot stat `/opt/rg/data_tb3/steve/wals/000000010000000000000001':
A file or directory in the path name does not exist.
LOG: redo starts at 0/1000020
LOG: record with zero length at 0/1012280
cp: cannot stat `/opt/rg/data_tb3/steve/wals/000000010000000000000001':
A file or directory in the path name does not exist.
FATAL: could not load library
"/opt/dbs/pgsql9-beta2/lib/libpqwalreceiver.so": 0509-022 Cannot
load module /opt/dbs/pgsql9-beta2/lib/libpqwalreceiver.so.
0509-150 Dependent module libpq.a(libpq.so.5) could
not be loaded.
0509-022 Cannot load module libpq.a(libpq.so.5).
0509-026 System error: A file or directory in the path
name does not exist.
0509-022 Cannot load module
/opt/dbs/pgsql9-beta2/lib/libpqwalreceiver.so.
0509-150 Dependent module
/opt/dbs/pgsql9-beta2/lib/libpqwalreceiver.so could not be loaded.
This worked fine with beta2 but now seems to be an issue on beta4.
If I do
export LIBPATH=/opt/dbs/pgsql9-beta2/lib/
before starting the standby postmaster then it seems to work.
I haven't yet tried running truss to try to look at where it is looking
for libpq from. liblibpqwalreceiver is being linked with this
gcc -maix64 -O2 -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing
-fwrapv -g -o libpqwalreceiver.so liblibpqwalreceiver.a
-Wl,-bE:liblibpqwalreceiver.exp -L../../../../src/port
-Wl,-bmaxdata:0x80000000,-bbigtoc -L/opt/freeware/lib
-Wl,-blibpath:/opt/dbs/pgsql9-beta2/lib:/opt/freeware/lib:/usr/lib:/lib
-Wl,-bnoentry -Wl,-H512 -Wl,-bM:SRE -L../../../../src/interfaces/libpq
-lpq -Wl,-bI:../../../../src/backend/postgres.imp
I'll try to look into this a bit more tomorrow or thursday.
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ssinger@ca.afilias.info, pgsql-hackers@postgresql.org
Subject: Re: HS/SR on AIX
In-Reply-To: <4C743C2D.1060209@ca.afilias.info>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox