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

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

In response to

Browse pgsql-general by date

  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