[GENERAL] Failed archive_command copy - number of attempts configurable?

Hi all, I'm doing some testing of Postgres 9.0 archiving and streaming replication between a couple of Solaris 10 servers. Recently I was trying to test how well the standby server catches up after an outage, and a question arose. It seems that if the standby is uncontactable by the primary when

Re: [GENERAL] Can't take base back up with Postgres 9.0 on Solaris 10

I was just being a bit dull, I'm afraid - I've had a read of the psql help, and by default it connects to port 5432, which is the port that's listening for the PG 8.1.4 install on my server. I ran 'bin/psql -p ' instead, to point at my PG 9.0 instance, and the pg_start_backup worked fine. Tha

Re: [GENERAL] Can't take base back up with Postgres 9.0 on Solaris 10

Hi Thom, thanks for your reply. Here's my psql output: bash-3.00$ bin/psql psql (9.0.1, server 8.1.4) WARNING: psql version 9.0, server version 8.1. Some psql features might not work. Type "help" for help. postgres=# SHOW wal_level; ERROR: unrecognized configuration parameter "wal_leve

[GENERAL] Can't take base back up with Postgres 9.0 on Solaris 10

Hi everyone, I'm trying to take a base backup of my primary DB ready for copying to my standby. I've followed the instructions to configure my postgresql.conf at hxxp://www.postgresql.org/docs/9.0/static/continuous-archiving.html, but I get one of two errors depending on how I try to run the back

[GENERAL] Problem with Postgresql 9.0 streaming replication on Solaris 10 (x86)

Hi all, I'm having a problem getting streaming replication to work between two servers running Solaris 10 (both x86 platforms). Both servers have PG 9.0 installed at /postgres/postgres/9.0_pgdg/, with a database initialised at /postgres/postgres/9.0_pgdg/data/. I have followed the instructions