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

Responses

• Re: testing cvs HEAD - HS/SR - cannot stat at 2010-02-04 07:51:41 from Fujii Masao

pgsql-hackers by date

Next:	From: Dimitri Fontaine	Date: 2010-02-03 21:48:57
	Subject: Re: PG 9.0 and standard_conforming_strings
Previous:	From: Dimitri Fontaine	Date: 2010-02-03 21:35:43
	Subject: Re: PG 9.0 and standard_conforming_strings