| From: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
|---|---|
| To: | "Day, David" <david(dot)day(at)redcom(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pglogical extension. - 2 node master <-> master logical replication ? |
| Date: | 2019-07-07 18:44:14 |
| Message-ID: | 25c4085b-ed1f-583b-2abe-b9c248d18960@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 2019-07-02 19:54, Day, David wrote:
> On attempting the reverse subscription from host1 to host2
>
> select pglogical.create_subscription('alabama_sub',
> 'host=alabama port=5432 dbname=ace_db user=replicator',
> '{connections}', false, false, '{}' )
>
> could not connect to the postgresql server: FATAL: role "pgsql" does not exist
> DETAIL: dsn was: host=georgia port=5432 dbname=ace_db
>
> --
> Wrong dsn and role ?
> The postgres installed superuser role is not pgsql.
> I did not see this issue in the working subscription direction.
The problem might be in the dsn that you gave to create_node(). Hard to
tell without a fully reproducible script.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Mercha | 2019-07-07 23:22:21 | Measuring the Query Optimizer Effect: Turning off the QO? |
| Previous Message | Felipe de Jesús Molina Bravo | 2019-07-06 22:09:17 | Re: xpath differences between postgres 11.4 and 10.3 |