*I am not the best specialist about logical replication, but as it looks to be a requirement to have 2 nodes with different system identifiers, you shouldn't link 1 node to another node whose data folder has been created from the base backup of the former (for example create the 2nd node based on a base backup of the 1st node). The error returned here would mean so.* ** *- *I didn't create the /data folders from any backup for both the nodes; they were created fresh by initdb individually. Is there anything specific that I need to do apart from initdb?
*pgcontrol_data outputs different database system ids for the two nodes. So > don't understand why it says identifiers are same. Are you sure? Please re-ckeck.* ** *- *I re-verified and they are different. Pasting the snapshots below- irc1@ubuntuirc:~/bdr2/postgres-d6ed89e/postgres-bdr-bin/bin$ ./pg_controldata ./data2/ pg_control version number: 937 Catalog version number: 201305061 Database system identifier: *5856368744762683487* Database cluster state: in production .... irc2@ubuntuirc2:~/bdr/postgres-bin/bin$ ./pg_controldata ./data/ pg_control version number: 937 Catalog version number: 201305061 Database system identifier: *5901663435516996514* Database cluster state: in production Also, am pasting the below snapshot to let you know that postgres doesn't seem to be the su; in case this problem is due to that. irc1@ubuntuirc:~/bdr2/postgres-d6ed89e/postgres-bdr-bin/bin$ ./psql testdb2 psql (9.3beta1) Type "help" for help. testdb2=# \du List of roles Role name | Attributes | Member of -----------+------------------------------------------------+----------- irc1 | Superuser, Create role, Create DB, Replication | {} irc2@ubuntuirc2:~/bdr/postgres-bin/bin$ ./psql testdb2 psql (9.3beta1) Type "help" for help. testdb2=# \du List of roles Role name | Attributes | Member of -----------+------------------------------------------------+----------- irc2 | Superuser, Create role, Create DB, Replication | {} Please let me know which mailing list will be more appropriate to raise my concern regarding this postgres dev flavor. I am yet to receive any response from Andres. Thanks. On Thu, Jul 18, 2013 at 3:31 PM, Michael Paquier <michael.paqu...@gmail.com>wrote: > On Fri, Jul 19, 2013 at 5:02 AM, Indrajit Roychoudhury > <indrajit.roychoudh...@gmail.com> wrote: > > 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@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. > I am not the best specialist about logical replication, but as it > looks to be a requirement to have 2 nodes with different system > identifiers, you shouldn't link 1 node to another node whose data > folder has been created from the base backup of the former (for > example create the 2nd node based on a base backup of the 1st node). > The error returned here would mean so. > > > 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. > Are you sure? Please re-ckeck. > > > 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. > If this behavior is confirmed, I think that this bug should be > reported directly to Andres and not this mailing list, just because > logical replication is not integrated into Postgres core as of now. > -- > Michael >