11/18/2019 No Pg_hba.conf Entry For Host
Client authentication is controlled by a configuration file, which traditionally is named pghba.conf and is stored in the database cluster's data directory. Hello I am trying to run a website sent to me but after doing so this error appeared connect to PostgreSQL server: FATAL: no pghba.conf entry for host '4X.XXX.XX.XXX.
I'meters attempting to construct a Postgres HA Cluster with Postgres 11, patroni and etcd.I have got it fairly much operating additional than the error in the title.
The patroni config area for the pghba.conf looks like this,
No other entries appear to end up being needed as the ETCD group takes care of the settings and part of each node.I possess examined this with the node posts of the web servers in the pghba area but nevertheless get the exact same error.I built an instance of a patroni PG bunch on one machine operating 2 instances of Postgres 11 and it worked well fine. No problems when changing.
I have got 2 nodes therefore when I restart the grasp and it becomes the secondary, it punches this error
'my personal ip' becoming the IP of the node it can be tossing the mistake on.
Databases repeat across ok so the DB turning functions despite this error.
My inspections now believe its something to perform with the ETCD bunch which reviews back as healthful and the records for the nodes show up to become ok.
Has anyone come across this just before?
inkedinked
migratedfrom superuser.comDecember 20 '18 at 18:16
This question arrived from our web site for computer fanatics and energy users.
Browse other queries labeled linux or question your personal question.Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |