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

2010-10-28 Thread Adrian Klaver
On Thursday 28 October 2010 5:07:06 am dan.m.harris wrote: > 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. > > postgre

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

2010-10-28 Thread dan.m.harris
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

2010-10-28 Thread Adrian Klaver
On Thursday 28 October 2010 5:07:06 am dan.m.harris wrote: > 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. > > postgre

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

2010-10-28 Thread Thom Brown
On 28 October 2010 13:07, dan.m.harris wrote: > > 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 wa

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

2010-10-28 Thread dan.m.harris
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

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

2010-10-28 Thread Thom Brown
On 28 October 2010 12:42, dan.m.harris wrote: > > 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 > g