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

From: "dan(dot)m(dot)harris" <daniel(dot)harris(at)metaswitch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Can't take base back up with Postgres 9.0 on Solaris 10
Date: 2010-10-28 11:42:16
Message-ID: 1288266136312-3240364.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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 backup:

bash-3.00$ bin/psql -c "SELECT pg_start_backup('basebackup', true)"
ERROR: function pg_start_backup("unknown", boolean) does not exist
HINT: No function matches the given name and argument types. You may need to
add explicit type casts.
bash-3.00$ bin/psql -c "SELECT pg_start_backup('basebackup')"
ERROR: WAL archiving is not active
HINT: archive_command must be defined before online backups can be made
safely.

Here are the lines I've changed in postgresql.conf:
listen_addresses = '*' # what IP address(es) to listen on;
port = 5555 # (change requires restart)
wal_level = archive # minimal, archive, or hot_standby
archive_mode = on # allows archiving to be done
archive_command = 'scp %p
postgres(at)172(dot)18(dot)131(dot)211:/postgres/postgres/9.0-pgdg/primary_archive' #
command to use to archive a logfile segment
max_wal_senders = 1 # max number of walsender processes
wal_keep_segments = 32 # in logfile segments, 16MB each; 0 disables

Could anyone tell me what the problem might be?

Thanks,
Dan
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Can-t-take-base-back-up-with-Postgres-9-0-on-Solaris-10-tp3240364p3240364.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2010-10-28 11:59:59 Re: Can't take base back up with Postgres 9.0 on Solaris 10
Previous Message Hfe80 2010-10-28 08:13:04 Re: DB become enormous with continuos insert and update