From: | Indrajit Roychoudhury <indrajit(dot)roychoudhury(at)gmail(dot)com> |
---|---|
To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
Cc: | pgsql-www(at)postgresql(dot)org |
Subject: | Fatal error after starting postgres : sys identifiers must be different |
Date: | 2013-07-18 16:48:22 |
Message-ID: | CAD0pnxVaM-g1Z0HQnTHhpLigf+qpKJu32pkE2ikocheaS5scWw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-novice pgsql-www |
Hi Alvaro,
Could you please let me know what does the error "system identifiers are
same" mean? Below is the snapshot from one of the masters.
I am setting up BDR as per the wiki
http://wiki.postgresql.org/wiki/BDR_User_Guide#Initial_setup
and source @
git://git.postgresql.org/git/users/andresfreund/postgres.git
irc1(at)ubuntuirc:~/bdr2/postgres-d6ed89e/postgres-bdr-bin/bin$ ./postgres -D
~/bdr2/postgres-d6ed89e/postgres-bdr-bin/bin/data2/
LOG: bgworkers, connection: dbname=testdb2
LOG: option: dbname, val: testdb2
LOG: registering background worker: bdr apply: ubuntuirc2
LOG: loaded library "bdr"
LOG: database system was shut down at 2013-03-17 10:56:52 PDT
LOG: doing logical startup from 0/17B6410
LOG: starting up replication identifier with ckpt at 0/17B6410
LOG: autovacuum launcher started
LOG: starting background worker process "bdr apply: ubuntuirc2"
LOG: database system is ready to accept connections
LOG: bdr apply: ubuntuirc2 initialized on testdb2, remote dbname=testdb2
replication=true fallback_application_name=bdr
FATAL: system identifiers must differ between the nodes
DETAIL: Both system identifiers are 5856368744762683487.
LOG: worker process: bdr apply: ubuntuirc2 (PID 16712) exited with exit
code 1
^CLOG: received fast shutdown request
LOG: aborting any active transactions
LOG: autovacuum launcher shutting down
LOG: shutting down
Thanks.
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Smith | 2013-07-18 17:14:48 | Re: Improvement of checkpoint IO scheduler for stable transaction responses |
Previous Message | Robert Haas | 2013-07-18 16:45:08 | Re: [ODBC] getting rid of SnapshotNow |
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2013-07-18 19:21:15 | Re: Fatal error after starting postgres : sys identifiers must be different |
Previous Message | Daniel Gomez Blanco | 2013-07-18 13:51:28 | Re: User with "almost" superuser privileges |
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2013-07-18 19:21:15 | Re: Fatal error after starting postgres : sys identifiers must be different |
Previous Message | Alvaro Herrera | 2013-07-17 16:21:04 | Re: 'Make' postgres9.3 takes lot of time |