On Mon, Apr 12, 2010 at 1:48 AM, Fujii Masao <masao.fu...@gmail.com> wrote: > On Mon, Apr 12, 2010 at 3:29 PM, Jaime Casanova > <jcasa...@systemguards.com.ec> wrote: >> On Mon, Apr 12, 2010 at 1:21 AM, Fujii Masao <masao.fu...@gmail.com> wrote: >>> Didn't the standby >>> accept connections before executing pgbench? >>> >> >> nop, and last time i try it was in that state for an hour (without >> accepting connections)... after that i execute on the primary: CREATE >> TABLE tt2 AS SELECT generate_series(1, 100) as i >> After that, the standby start accepting connections > > OK. Your reproduction scenario is the following? > If not, could you show me the complete scenario? > > 1. start the primary > 2. pg_start_backup() > 3. copy $PGDATA from the primary to the standby > 4. pg_stop_backup(); > 5. create the recovery.conf and start the standby
execute some WAL-logged action (i've seen this happen even with no WAL-logged action if i wait for a while before shutdown servers) > 6. shutdown (smart mode) the standby shutdown (smart) the primary start the primary again > 7. start the standby again > --> cannot accept connnections until new WAL has been created > a manual CHECKPOINT on the primary does help -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
