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