Hello, Testing 9.0devel HS/SR: I used cvs HEAD (today) with the new_smart_shutdown_20100201.patch of Fujii Masao.
Replication works well. The slave can be stopped and restarted. However, whenever (re-)starting the slave the I get messages like: cp: cannot stat `/var/data1/pg_stuff/dump/replication_archive/000000010000000000000002': No such file or directory At this point, /var/data1/pg_stuff/dump/replication_archive: -rw------- 1 xxxxxxxx xxxxxxxx 240 Feb 3 22:35 000000010000000000000001.00000020.backup -rw------- 1 xxxxxxxx xxxxxxxx 16777216 Feb 3 22:35 000000010000000000000001 -rw------- 1 xxxxxxxx xxxxxxxx 16777216 Feb 3 22:35 000000010000000000000000 Maybe the message is not really a bug: everything works fine otherwise. thanks, Erik Rijkers # primary ./data/postgresql.conf data_directory = '/var/data1/pg_stuff/pg_installations/pgsql.sr_primary/data' max_connections = 100 shared_buffers = 32MB checkpoint_segments = 50 archive_mode = 'on' archive_command= 'cp %p /var/data1/pg_stuff/dump/replication_archive/%f' max_wal_senders = 5 # standby ./data/postgresql.conf data_directory = '/var/data1/pg_stuff/pg_installations/pgsql.sr_slavery/data' port = 6566 max_connections = 100 shared_buffers = 32MB checkpoint_segments = 50 archive_mode = 'on' archive_command= 'cp %p /var/data1/pg_stuff/dump/replication_archive/%f' max_wal_senders = 5 # standby ./data/recovery.conf standby_mode = 'on' primary_conninfo = 'host=/tmp port=6565 user=aardvark' restore_command = 'cp -i /var/data1/pg_stuff/dump/replication_archive/%f %p </dev/null' Centos, Linux 2.6.18-164.el5 x86_64 ./configure \ --prefix=/var/data1/pg_stuff/pg_installations/pgsql.sr_primary \ --with-pgport=6565 --quiet --enable-cassert --enable-debug \ --enable-depend --with-openssl --with-perl --with-libxml \ --with-libxslt -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers