| 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: | Whole Thread | Raw Message | 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 |