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.
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 |