The first error suggests you're connecting to an older version of the server,
since it doesn't recognize the boolean parameter to complete checkpointing
quickly (new in version 9).
The second error suggests Point in Time Recovery has not been enabled, but the
postgresql.conf suggests it is enabled.
I notice your postgresql.conf has a non-default port of 5555 (default is 5432),
but you're not specifying the -p or --port to psql. Are you connecting to the
correct database?
Daniel Harris wrote:
Bjorn,
I've got the new tarball, and the library dependencies all look good. Thanks!
Which leads me to my next problem...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
[email protected]:/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 you (or anyone!) shed some light on what the problem might be?
Thanks,
Dan
_______________________________________________
databases-discuss mailing list
[email protected]
http://mail.opensolaris.org/mailman/listinfo/databases-discuss
