Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Starting the BDR-enabled PostgreSQL nodes/instances

Start your nodes/instances from the command line of your operating system:
    pg_ctl -l $HOME/2ndquadrant_bdr/bdr5598.log -D $HOME/2ndquadrant_bdr/bdr5598 -o "-p 5598" -w start
    pg_ctl -l $HOME/2ndquadrant_bdr/bdr5599.log -D $HOME/2ndquadrant_bdr/bdr5599 -o "-p 5599" -w start
Each node/instance will start up and then will run in the background. You'll see the following:
     waiting for server to start.... done
     server started
If you see an issue with starting your nodes/instances:
     waiting for server to start........ stopped waiting
     pg_ctl: could not start server
... then take a look at the log files (bdr5598.log or bdr5599.log depending on which one failed to start.) Most likely you already have a PostgreSQL instance running on the target port. It is also possible that your $PATH is not set to point to BDR, so you're trying to use binaries from a different PostgreSQL release that won't have the bdr extension or understand some of the configuration parameters.

Comments

Popular posts from this blog

Oracle DBMS SCHEDULER Examples

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

7 Steps to configure BDR replication in postgresql

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

How to Enable/Disable autovacuum on PostgreSQL