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
fileor 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