Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id E5BE3632A30 for ; Tue, 24 Aug 2010 18:40:07 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 97614-02 for ; Tue, 24 Aug 2010 21:40:00 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outbound.afilias.info (outbound.afilias.info [69.46.124.26]) by mail.postgresql.org (Postfix) with ESMTP id 39BAF63244B for ; Tue, 24 Aug 2010 18:39:59 -0300 (ADT) Received: from ms6.yyz2.afilias-ops.info ([10.50.129.112] helo=smtp.afilias.info) by outbound.afilias.info with esmtp (Exim 4.69) (envelope-from ) id 1Oo1Dq-0002BF-43 for pgsql-hackers@postgresql.org; Tue, 24 Aug 2010 21:39:58 +0000 Received: from tor-gateway.afilias.info ([199.15.87.4] helo=[10.10.46.23]) by smtp.afilias.info with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.69) (envelope-from ) id 1Oo1Dq-000853-6r for pgsql-hackers@postgresql.org; Tue, 24 Aug 2010 21:39:58 +0000 Message-ID: <4C743C2D.1060209@ca.afilias.info> Date: Tue, 24 Aug 2010 17:39:57 -0400 From: Steve Singer User-Agent: Thunderbird 2.0.0.23 (X11/20090817) MIME-Version: 1.0 To: PostgreSQL-development Hackers Subject: HS/SR on AIX Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-4.21 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_MED=-2.3, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201008/1750 X-Sequence-Number: 168553 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