From: | Craig Ringer <craig(at)2ndquadrant(dot)com> |
---|---|
To: | Steve Boyle <sboyle(at)connexity(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Setting up BDR 0.9.0 - error on bdr_group_create |
Date: | 2015-03-25 23:53:25 |
Message-ID: | CAMsr+YFmybXx9Fbh1daHsuYA4Up7DKvs2PZtE+WEVqggo-oZ+g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 26 March 2015 at 06:02, Steve Boyle <sboyle(at)connexity(dot)com> wrote:
> postgres=# SELECT bdr.bdr_group_create(
> postgres(# local_node_name := 'cxtlabdev014',
> postgres(# node_external_dsn := 'port=5432 dbname=prod'
> postgres(# );
> ERROR: getting remote node id failed
> DETAIL: SELECT sysid, timeline, dboid FROM bdr.bdr_get_local_nodeid()
> failed with: ERROR: schema "bdr" does not exist
>
It looks like you're running bdr_group_create from the 'postgres' database,
but you're specifying the dbname 'prod' as the database that you're
creating the bdr group for.
You should CREATE EXTENSION bdr; in the 'prod' database and run
bdr.bdr_group_create while connected to 'prod'.
The documentation should be more explicit about the fact that the
management commands affect the database they are run in.
Thanks for writing a clear and detailed report with errors, versions, and
command shown. It's much appreciated.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2015-03-26 00:24:00 | Re: BDR - triggers on receiving node? |
Previous Message | Steve Boyle | 2015-03-25 22:02:54 | Setting up BDR 0.9.0 - error on bdr_group_create |