Prev: [HACKERS] use of dblink_build_sql_insert() induces a server crash
Next: [HACKERS] proposed PQconnectdbParams macros (was Re: [BUGS] BUG #5304: psqlusing conninfo fails in connecting to the server)
From: "Erik Rijkers" on 3 Feb 2010 16:39
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(a)postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

 | 
Pages: 1
Prev: [HACKERS] use of dblink_build_sql_insert() induces a server crash
Next: [HACKERS] proposed PQconnectdbParams macros (was Re: [BUGS] BUG #5304: psqlusing conninfo fails in connecting to the server)