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

Поиск
Список
Период
Сортировка
От Volkan Unsal
Тема Re: no pg_hba.conf entry for replication connection from host
Дата
Msg-id CAMcqKmkY55zm6nU5Us2npedirm5DG4ig0+rOzsuxiGthFrkNDg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: no pg_hba.conf entry for replication connection from host  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: no pg_hba.conf entry for replication connection from host  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: no pg_hba.conf entry for replication connection from host  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Hi Adrian,

I spent the last hour checking the config files are indeed being used –– and they are. :P I'm getting silly after days of this configuration nightmare. Thanks for replying to all my posts and making helpful suggestions. After reading a bit more about log outputs, I enabled the maximum logging, and I think I am seeing something interesting in the logs:




On Fri, Apr 10, 2015 at 4:28 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 04/10/2015 01:06 PM, Volkan Unsal wrote:
Hi Adrian,

    I see nowhere in your  init-master.sh where Postgres is restarted.



Yes, you're right. The base image takes care of that –– the base image
of mdillon/postgis is postgres:9.3. See here, for instance:

https://github.com/docker-library/postgres/blob/master/9.3/docker-entrypoint.sh#L70

When the startup command –– CMD in Docker lingo –– is "postgres" it does
a bunch of initialization operations, and then runs the user procided
scripts in the /docker-entrypoint-initdb.d directory.

Then finally it starts up the postgres process with /gosu postgres "$@".
/ The gosu is a wrapper that passes user commands to the end process,
i.e. postgres, and I'm not sure what $@ is but I think it's to give the
user a shell.

I do not have time to go through all the scripts, but wanna make a bet that it is starting Postgres with a different set up conf files then you think or a different instance of Postgres:)?

On your primary I would confirm what is actually run when all the scripting is done. Also when the primary is running take a look at

http://www.postgresql.org/docs/9.3/static/monitoring-stats.html#PG-STAT-REPLICATION-VIEW

I am almost positive that somewhere in the switch from --single mode to regular mode information is being lost.






--
*Volkan Unsal*
/web and mobile development/
volkanunsal.com <http://bit.ly/1h1ebjy>


--
Adrian Klaver
adrian.klaver@aklaver.com



--
Volkan Unsal
web and mobile development

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: no pg_hba.conf entry for replication connection from host
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: no pg_hba.conf entry for replication connection from host