From: | Josh berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | Алексей Митропольский <mitr2503(at)mail(dot)ru>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: no pg_hba.conf entry for replication connection |
Date: | 2016-02-09 11:17:58 |
Message-ID: | 56B9CAE6.5070903@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 02/09/2016 11:44 AM, Алексей Митропольский wrote:
> Hello,
>
> I have tried to set up streaming replication (Postgres 9.4.5.3 Linux).
>
> pg_hba.conf on the master server have entry:
>
> host replication postgres 192.168.50.36 trust
I don't recommend using "trust" for this. Use a .pgpass file instead to
save the password.
>
> When I start the standby server (192.168.50.36) I get errors in the logs:
>
> LOG: entering standby mode
> LOG: restored log file "0000...10" from archive
> LOG: redo starts at 0/10000788
> LOG: consistent recovery state reached at 0/11000000
> LOG: database system is ready to accept read only connections
> LOG: scp: /opt/PostgreSQL/9.4/data/arch_dest/0000..11: No such file or
> directory
> LOG: invalid magic number 0000 in ljg segment 0000..11, offset 0
> FATAL: could not connect to the primary server: FATAL: no pg_hba.conf
> entry for replication connection from host "192.168.50.36",
> user "postgres", SSL off
Did you reload the master?
--
--
Josh Berkus
Red Hat OSAS
(any opinions are my own)
From | Date | Subject | |
---|---|---|---|
Next Message | Geoff Winkless | 2016-02-09 11:42:44 | Re: COALESCE requires NULL from scalar subquery has a type |
Previous Message | Алексей Митропольский | 2016-02-09 10:44:41 | no pg_hba.conf entry for replication connection |