Re: [Health] pgadmin4

[Luis Falcon]

Dear Tajwali

On Tue, 3 Aug 2021 22:04:22 +0500
Tajwali Khan <tajwali@gmail.com> wrote:

> Hi.
> 
> I have gnuhealth installed thru yast on opensuse 15.2.
> 
> The postgres database server was installed thru gnuhealth
> installation.
> 
> Im trying to use pgadmin4 to manage the database. The gnuhealth is
> not a production system.
> 
> The pgadmin does not connect to the localhost. Does not give anyerror
> when i give server details
> 
> Any idea what may be causing the connection problem?

Have you check the access permissions on pg_hba.conf and that you don't
have the firewall enabled blocking the port from external connections?

In addition to that, be *very* careful to use postgres directly on GNU
Health. GNU Health HMIS uses a relational DB model which is intended to
be managed from the trytond server. Failing to do so, the chances of
ending with a corrupted database is very high.

I use postgres tools mainly to make backups and restore.

All the best
Luis


-- 
Dr. Luis Falcon, MD, MSc
President, GNU Solidario
Advancing Social Medicine
www.gnuhealth.org