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


Reply via email to