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-postgres...@yahoo.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 < > melvin6...@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 <spockspla...@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 > > > -- *Volkan Unsal* *web and mobile development* volkanunsal.com <http://bit.ly/1h1ebjy>
