BUG #11603: replication, pg_basebackup and high load

From: mdglange(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #11603: replication, pg_basebackup and high load
Date: 2014-10-08 13:19:27
Message-ID: 20141008131927.2563.36952@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 11603
Logged by: Michiel
Email address: mdglange(at)gmail(dot)com
PostgreSQL version: 9.4beta2
Operating system: Linux
Description:

The test I did involved the following: a master database with two slaves. On
the master two replication slots have been configured as per the
documentation. One slave active before I put some "heavy" load (the
environment is scaled such, that inserting a few gigabytes of insert
statements is a heavy load. This is on purpose)

During this load I started a pg_basebackup from the master, immediately
followed (pg_basebackup && mv recovery.conf $PG_DATA/ && pg_ctl start) by
placing the prepared recovery.conf and starting this slave. The
pg_basebackup took a few hours (as expected) but starting this latter slave
would not work because the WALs were no longer available.

I'd expect to see that pg_basebackup restores up to the last WAL, so that
regardless of the load and changes done on the (master) database replication
picks up.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message eric.hill 2014-10-08 17:54:46 BUG #11608: ODBC driver crashes after wrong password entered
Previous Message Bricklen Anderson 2014-10-08 04:56:49 from: Bricklen Anderson