| From: | Volkan Unsal <spocksplanet(at)gmail(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | Melvin Davidson <melvin6925(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: no pg_hba.conf entry for replication connection from host |
| Date: | 2015-04-10 22:47:10 |
| Message-ID: | CAMcqKmkHc7ZsM+R_TtvBZqcQ7y=-SGbHXyOFfR2JTkgZgp_Ojw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> Please, what does:
>
> select * from pg_stat_replication
>
> show on the primary?
>
It shows 0 rows.
Here is the pg_xlog folder from standby:
root(at)cba9f6ba3f6e:/# cat ${PGDATA}/pg_xlog/
> 00000001000000000000000C archive_status
And here it is from the primary:
>
> root(at)ad4a83bdcf9e:/# cat ${PGDATA}/pg_xlog/
> 000000010000000000000005
> 000000010000000000000006
> 000000010000000000000007
> 000000010000000000000008
> 000000010000000000000009
> 00000001000000000000000A
> 00000001000000000000000B
> 00000001000000000000000C
> 00000001000000000000000C.00000028.backup
> 00000001000000000000000D
> 00000001000000000000000E
> archive_status
--
*Volkan Unsal*
*web and mobile development*
volkanunsal.com <http://bit.ly/1h1ebjy>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2015-04-10 23:21:01 | Re: no pg_hba.conf entry for replication connection from host |
| Previous Message | Adrian Klaver | 2015-04-10 22:46:23 | Re: no pg_hba.conf entry for replication connection from host |