From: | Ian Barwick <ian(dot)barwick(at)2ndquadrant(dot)com> |
---|---|
To: | Evan Walter <ewalter(at)decisionanalyst(dot)com>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Trouble setting up Streaming Replication with Barman |
Date: | 2019-11-22 01:58:35 |
Message-ID: | 0c2bc048-3487-35f3-6263-3b00efcc6745@2ndquadrant.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On 2019/11/22 7:07, Evan Walter wrote:
> Hello,
> I am trying to set up streaming replication with barman, going down the tutorial.
>
> When I run/ I get:
>
> $barman receive-wal --create-slot pg
>
> ERROR: Cannot connect to server 'pg'
>
> $cat /etc/barman.d/pg.conf
> [pg]
(...)
> streaming_conninfo = host=<my-pg-server-ipaddress-here> user=streaming_barman dbname=postgres
(...)
> $nano /etc/postgresql/12/main/pg_hba.conf
(...)
> host all streaming_barman <my-barman-ipaddress-here>/32 md5
The "streaming_barman" user should be a user with replication permissions
(if not already set, execute "ALTER USER streaming_barman REPLICATION")
and appropriate permission granted in "pg_hba.conf":
host replication streaming_barman <my-barman-ipaddress-here>/32 md5
> The Barman Server (logged in as barman): ###############################
> $psql -c 'SELECT version()' -U barman -h <my-ipaddress-here> postgres
Check the replication connection works with:
psql -c 'IDENTIFY_SYSTEM' 'host=<my-ipaddress-here> dbname=postgres user=streaming_barman replication=1'
Regards
Ian Barwick
--
Ian Barwick https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | swadesh mondal | 2019-11-23 23:21:01 | Re: Trouble setting up Streaming Replication with Barman |
Previous Message | Evan Walter | 2019-11-21 22:07:55 | Trouble setting up Streaming Replication with Barman |