From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Volkan Unsal <spocksplanet(at)gmail(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 23:21:01 |
Message-ID: | 55285ADD.2070308@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 04/10/2015 03:47 PM, Volkan Unsal wrote:
>
> Please, what does:
>
> select * from pg_stat_replication
>
> show on the primary?
>
>
>
> It shows 0 rows.
>
Are sure there is only one instance of Postgres running on the primary
container?
What does ps ax | grep post show?
Is the primary database seeing any activity after being setup?
For the below, actual file listings would be nice, showing timestamps
and sizes.
>
> 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>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2015-04-11 04:43:11 | Re: Using array_agg in pgr_kdisjkstrpath() error |
Previous Message | Volkan Unsal | 2015-04-10 22:47:10 | Re: no pg_hba.conf entry for replication connection from host |