Re: no pg_hba.conf entry for replication connection from host

Can you share your postgresql.conf settings?

do you have the following set:

hot_standby = on

This is what i get for streaming in the log file:

00000:2015-04-09 15:32:05 EDT::@:[8792]:[2-1] LOG:  entering standby mode

scp: x8= snipped =8x /pg_xlog_archive/00000001000000180000004A: No such file or directory

scp failed

00000:2015-04-09 15:32:05 EDT::@:[8792]:[3-1] LOG:  redo starts at 18/4AEA6740

00000:2015-04-09 15:32:05 EDT::@:[8792]:[4-1] LOG:  consistent recovery state reached at 18/4AF0F7A8

00000:2015-04-09 15:32:05 EDT::@:[8792]:[5-1] LOG:  invalid record length at 18/4AF0F7A8

00000:2015-04-09 15:32:05 EDT::@:[8786]:[4-1] LOG:  database system is ready to accept read only connections

00000:2015-04-09 15:32:05 EDT::@:[8804]:[1-1] LOG:  started streaming WAL from primary at 18/4A000000 on timeline 1

 

Regards,
Amit Varde

On Thursday, April 9, 2015 3:20 PM, Melvin Davidson <melvin6925@gmail.com> wrote:

So did you make the following entry in pg_hba,conf?

host    replication    rep        104.131.66.183/32            md5

Is rep a valid postgres user in the cluster?

Did you remember to do:
SELECT pg_reload_conf();

After making the changes to pg_hba.conf?


On 4/9/15, Volkan Unsal <spocksplanet@gmail.com> wrote:
> HI Adrian,
>
>
>
>> Can you connect remotely from the standby using psql?
>
>
>
> Yes, I can connect directly from the standby using psql and DB_USER and
> DB_PASS.
>
>
>
>
> --
> *Volkan Unsal*
> *web and mobile development*
> volkanunsal.com <http://bit.ly/1h1ebjy>
>


--
*Melvin Davidson*
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general