Re: Fatal error after starting postgres : sys identifiers must be different

Поиск
Список
Период
Сортировка
От Indrajit Roychoudhury
Тема Re: Fatal error after starting postgres : sys identifiers must be different
Дата
Msg-id CAD0pnxXkz0UR0GQw0bCVkjzs+_E=awKoa+e5J7jAW6aRhab0AQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Fatal error after starting postgres : sys identifiers must be different
Re: [HACKERS] Fatal error after starting postgres : sys identifiers must be different
Список pgsql-novice
Дерево обсуждения
Hi,
 
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
and source @
 
irc1@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
 
pgcontrol_data outputs different database system ids for the two nodes. So don't understand why it says identifiers are same.
postgresql.conf content in one of the masters is like this-
 
/////////////////
shared_preload_libraries = 'bdr'
bdr.connections = 'ubuntuirc2'
bdr.ubuntuirc2.dsn = 'dbname=testdb2'
/////////////////
 
Two nodes are ubuntuirc and ubuntuirc2. Above is the output of the postgresql.conf from ubuntuirc.
 
Any help on this will be appreciated.
 
Thanks.


On Thu, Jul 18, 2013 at 9:48 AM, Indrajit Roychoudhury <indrajit.roychoudhury@gmail.com> wrote:
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
and source @
 
irc1@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.

В списке pgsql-novice по дате отправления:

Предыдущее
От: Daniel Gomez Blanco
Дата:
Сообщение: Re: User with "almost" superuser privileges
Следующее
От: amulsul
Дата:
Сообщение: Re: Fatal error after starting postgres : sys identifiers must be different