Page 1 of 1
DBeaver or PgAdmin
Published: June 17, 2019 - 3:34 PM
by La Salle
Hello,
congratulations on the work you do.
I have WAPT server 1.6.2.7 on a CentOS VM.
I would like to connect to the database to run queries.
Is this possible with DBeaver or PgAdmin?
Thanks,
Fred
Re: DBeaver or PgAdmin
Published: June 21, 2019 - 12:44 PM
by dcardon
Hello Fred,
La Salle wrote: ↑June 17, 2019 - 3:34 PM
Great job!
I have WAPT server 1.6.2.7 on a CentOS VM.
I'd like to connect to the database to run queries.
Is this possible with DBeaver or PgAdmin?
For security reasons, the PostgreSQL database only listens on localhost and via Unix sockets. The procedure is the same as for any PostgreSQL database: you need to modify the postgresql.conf file to listen on the different interfaces, and the pb_hba.conf file to list the IP addresses that are authorized to connect [1]. WAPT's unique feature is that it uses identity-based authentication via Unix sockets. Therefore, there is no default password; you will need to add one.
Sincerely,
Denis
[1]
https://blog.bigbinary.com/2016/01/23/c...ction.html