using pgadmin4 to connect to the db

[porrivmi]

Hi i am trying to connect to the db using the PBX´s IP , using database fusionpbx and user fusionpbx with password ( config.php) , but always fails i have open the firewall to enable the connection to port tcp 5432 , could someone help me pls?

 

[ad5ou]

the default postgresql install only allows connections on 127.0.0.1

 

[porrivmi]

ok but if change the php? is it possible? thanks.

 

[porrivmi]

ok i could connect using omnidb in the own server using a desktop , is it possible to get the database schema? we need to know in which table are storage the metadates for the recordings calls , thanks your time.

 

[DigitalDaz]

Get a bit of cli foo down you

su - postgres
psql fusionpbx
\d v_xml_cdr;
\q
exit