Can't conect to my nuxeo DB in PostgreSQL

[Ecoged_]

Hello,

I installed my instance of Nuxeo with PostgreSQL by default. But I can't connect to the Nuxeo database through the PGAdmin with data from the tab Admin Center.

What should I do to connect to the Nuxeo database and run an sql dump?

Thks.

[Benjamin_Jalon1]

I'm not really sure of your question, but I think you want to create a dump of information exposed into Admin Center > Activity > Events tab.

If I'm right, this is really simple.

Table used are :

• nxp_logs. This is the main table you have common information of events audited (id, kind of event, Event Name, docID -if this an document kind event - , initiator of the event, ...)
• nxp_logs_extinfo. This table contains extended informations
• nxp_logs_mapextinfos. For the mapping between the 2 previous tables described.

So dumping this information is just dumping Events tab, you just have to dumping this 3 tables:

pg_dump -t nxp_logs -t nxp_logs_extinfo -t nxp_logs_mapextinfos dbname > audit_export

And if you want to restore

psql -c "DROP TABLE nxp_logs CASCADE" yourdatabase
psql -c "DROP TABLE nxp_logs_extinfo CASCADE" yourdatabase
psql -c "DROP TABLE nxp_logs_mapextinfos CASCADE" yourdatabase
psql -f audit_export your database

[Julien_Carsique · Accepted solution]

Hello,

If PostgreSQL is the default, I guess you are using a Debian package or a VM?
Also, is it Nuxeo 5.5 or 5.4.2?
By default, PostgreSQL is only listening at localhost, that's why you can't connect to it from outside the server. See pg_hba.conf documentation.

[Ecoged_]

I'm using a deb package. My nuxeo 5.4.2 instance is installed on a Ubuntu in dedicated server.

[Florent_Guillau]

This is really an Ubuntu and PostgreSQL question, there is nothing Nuxeo-specific about it.