Postgres Pro
Downloads
Home   >   mailing lists

Re: no pg_hba.conf entry for replication connection from host - Mailing list pgsql-general

From Volkan Unsal
Subject Re: no pg_hba.conf entry for replication connection from host
Date
Msg-id CAMcqKmkHc7ZsM+R_TtvBZqcQ7y=-SGbHXyOFfR2JTkgZgp_Ojw@mail.gmail.com
Whole thread Raw
In response to Re: no pg_hba.conf entry for replication connection from host  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: no pg_hba.conf entry for replication connection from host  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view

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@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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: no pg_hba.conf entry for replication connection from host
Next
From: Adrian Klaver
Date:
Subject: Re: no pg_hba.conf entry for replication connection from host