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
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 |