HS/SR on AIX

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