database system identifier differs between the primary and standby

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello List,

We are getting the following log while configuring hot standby,

2011-04-20 17:34:40 ETC/GMT FATAL:  the database system is starting up
2011-04-20 17:34:41 ETC/GMT FATAL:  database system identifier differs
between the primary and standby
2011-04-20 17:34:41 ETC/GMT DETAIL:  The primary's identifier is
5592072752411433371, the standby's identifier is 5597615802844953578.

PostgreSQL Version: 9.0.2

Prymary configuration:
wal_level = 'hot_standby'  - postgresql.conf
host    replication     all       x.x.x.x/24          trust â pg_hba.conf

Secondary configuration:
Hot_standby=off â postgresql.conf
standby_mode = 'on' â recovery.conf
primary_conninfo = 'host=10.20.9.181 port=5432' â recovery.conf

Please suggest on the above log O/P.

Regards,
Rajib


Rajib Deka
SIEMENS Ltd. 
Robert V Chandran Tower, First Floor, West Wing, 
#149, Velechery Tambaram Main Road, Pallikaranai, Chennai-100, INDIA.
www.siemens.com
 
Mob: +91-9176780669 | E-Mail: rajib.deka@xxxxxxxxxxx



--
View this message in context: http://postgresql.1045698.n5.nabble.com/database-system-identifier-differs-between-the-primary-and-standby-tp4315819p4315819.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux