In pool_hba. Conf configuration in the MD5 password authentication way, is also configured in pool_passwd (username, password), pgpool. Conf configuration enable_pool_hba=on, but why use pgadmin login time don't need a password can also be successful login?

CodePudding user response:

Configuration of pgpool certification file:

[root @ ucloud35 pgpool - II] # tail pool_hba. Conf
# TYPE DATABASE USER CIDR - ADDRESS METHOD
# "local" is for Unix domain socket connections only
The local all all trust
# IPv4 local connections:
The host all all 127.0.0.1/32 trust
The host all all 0.0.0.0/0 md5


The entire network segment using md5 authentication,

Generated password file below:

[root @ ucloud35 pgpool - II] # pg_md5 -- md5auth -u postgres -p


Enter the same password (postgres) and database,

[root @ ucloud35 pgpool - II] # tail pool_passwd

Postgres: md574d9e50349a805a667ad9e325fb02ebd


Certification is ready right now, with 35 port 9999 can access database client connection,

Need to add here is that the database node and agent node must separate, because they are both doing md5 authentication, but the agent certification is based on the database, the database needs to be done between trust certification, if the agent node and one of the database node together, proxy node authentication will not work, so must be used separately, and the database node

CodePudding user response:

Should be the native access set is trust.

CodePudding user response:

The original poster hello,
Pgadmin and navicat about, I have used, except for the first time login need to enter a password to connect to, as the browser automatically save the password after login automatically

CodePudding user response:

http://www.henryxi.com/install-and-configure-postgresql-on-linux

CodePudding user response:

May be the super administrator, so don't need a password

CodePudding user response:

4th floor, the correct answer

CodePudding user response:

Should be install the database, the configuration file Settings segments within the trust, so network don't need a password to access