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

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(at)yahoo(dot)com>
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(at)gmail(dot)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(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>
>

--
*Volkan Unsal*
*web and mobile development*
volkanunsal.com <http://bit.ly/1h1ebjy>