The following bug has been logged online:
Bug reference: 4667
Logged by: Andrew Shved
Email address: ashved@symcor.com
PostgreSQL version: 8.3.5
Operating system: Sun Sloaris 10 SPARC 64 bit ( SunOS 5.10)
Description: pg_standby error on Solaris 10 SPARC 64 bin
Details:
I rely heavily on pg_standby for my BCP site and seems to have a bug on my
platform.
I installed PostgreSQL 8.3.5 from binaries using from
http://www.postgresql.org/ftp/binary/v8.3.5/solaris/solaris10/sparc/
and I get the following error in my standby log when trying to restore -
ld.so.1: pg_standby: fatal: libpq.so.5: open failed: No such file or
directory
Looks like C error. My restrore_command is
restore_command = '/postgres/postgres/8.3-community/bin/64/pg_standby -d -s
5 -t /pgdata/HA1/pgsql.trigger.5442 /pg_xlog/HA1/restorelog %f %p %r
2>>/pgdata/HA1/standby.log'
just to make sure i am not going insane I did restore using this -
restore_command='cp /pg_xlog/HA1/restorelog/%f %p >>
/pgdata/HA1/standby.log'
and it worked perfectly so my set up is ok.
Can I get your help on fixing this as it worked so well for linux on version
8.2.4 but seems to fail on solaris 10 sparc.