Re: no pg_hba.conf entry for replication connection from host - Mailing list 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@cba9f6ba3f6e:/#  cat ${PGDATA}/pg_xlog/
>     00000001000000000000000C  archive_status
>
>
>
> And here it is from the primary:
>
>
>     root@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.klaver@aklaver.com