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

[Volkan Unsal <spocksplanet@xxxxxxxxx>]

Hi Amit,

My postgresql.conf file in the standby server looks like this:

wal_level = hot_standby
hot_standby = on
max_standby_streaming_delay = 15min

In the master server, it looks like this:

listen_addresses = '*'
wal_level = hot_standby
max_wal_senders = 10
max_connections=100
checkpoint_segments = 8
wal_keep_segments = 8
archive_mode = on
archive_command = 'cp %p /var/lib/postgresql/archive/%f'

In my logs, I see this line just before the server enters the standby mode:

LOG:  database system was interrupted; last known up at 2015-04-09 19:22:50 GMT
LOG:  entering standby mode

 

On Thu, Apr 9, 2015 at 3:41 PM, pgorg_aav <kahitarich-postgresorg@xxxxxxxxx> wrote:

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@xxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--

Volkan Unsal

web and mobile development

volkanunsal.com