BUG #7803: Replication Problem(no master is there)

From: katsumata(dot)tomonari(at)po(dot)ntts(dot)co(dot)jp
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7803: Replication Problem(no master is there)
Date: 2013-01-11 04:09:19
Message-ID: E1TtVvj-0004B3-2Z@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: 7803
Logged by: Tomonari Katsumata
Email address: katsumata(dot)tomonari(at)po(dot)ntts(dot)co(dot)jp
PostgreSQL version: 9.2.2
Operating system: RHEL 5.3 x86_64
Description:

hi, I'm playing with Synchronous Replication on PostgreSQL 9.2.2.
And I saw a strange behavior.

=================================================================
[issues]
two standbys are connected on each other, but
no master is there.

[reproduce]
1. create a master on port 22922

--- postgresql.conf ---
wal_level = hot_standby
archive_mode = on
archive_command = 'cp %p ${PGARC}/%f'
max_wal_senders = 3
listen_addresses = '*'
hot_standby = on
------------------------

2. start the master

mst$ pg_ctl start

3. create a standby(taking a base backup from master)

pg_basebackup -p 22922 -D ${PGDATA}

-- recovery.conf --
restore_command = 'cp ${PGARC}/%f %p'
standby_mode = on
primary_conninfo = 'port=22922 application_name=sby'
recovery_target_timeline = 'newest'
-------------------

4. stop the master

mst$ pg_ctl stop

5. make recovery.conf for the master

-- recovery.conf --
restore_command = 'cp ${PGARC}/%f %p'
standby_mode = on
primary_conninfo = 'port=23922 application_name=sby'
recovery_target_timeline = 'newest'
-------------------

6. start the master as standby

mst$ pg_ctl start

7. start the standby as standby on port 23922

sby$ pg_ctl start
=================================================================

I did not see the situation like above on PostgreSQL 9.1.7.

Is this intended change?

regards,
-----------------
NTT Software Corporation
Tomonari Katsumata

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Heikki Linnakangas 2013-01-11 08:40:21 Re: BUG #7803: Replication Problem(no master is there)
Previous Message Tom Lane 2013-01-10 17:44:35 Re: BUG #7802: Cannot drop table because of dependant sequence, but there is link to sequence