Can't take base back up with Postgres 9.0 on Solaris 10
От | dan.m.harris |
---|---|
Тема | Can't take base back up with Postgres 9.0 on Solaris 10 |
Дата | |
Msg-id | 1288266136312-3240364.post@n5.nabble.com обсуждение исходный текст |
Ответы |
Re: Can't take base back up with Postgres 9.0 on Solaris 10
|
Список | 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@172.18.131.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.
В списке pgsql-general по дате отправления: