[Solved] postgresql, plesk and remote access

[gaubry]

Dear all,

Since my account was transferred to plesk, I can't access my postgresql database anymore. Should I ask again for activating the remote access ?

username: gaubry

database: gaubry(underscore)bibliography

username: gaubry(underscore)gaubry

There is one problem: plesk tells me that the bibliography DB has no user (as I could not connect to the DB, I indeed removed the gaubry(underscore)gaubry user)

Quote

Host: 127.0.0.1:5432 (PostgreSQL)No database users [Create]Tables: 3Size: 8.54 MB

There are no users according to plesk in the database user management section, but if I try to create the gaubry(underscore)gaubry user, it tells me that

Quote

A database username with the name gaubry(underscore)gaubry already exists.

Even though I removed the user, it seems that it still survives somewhere.

Bonus question: is phppgadmin (or something similar) installed? I did not find a tool to browse my database.

Thanks

G.

[Krydos]

3 hours ago, gaubry said:

Should I ask again for activating the remote access ?

Yes, remote  database access is not transferred.

3 hours ago, gaubry said:

Even though I removed the user, it seems that it still survives somewhere.

Yes, the user gaubry_gaubry did still exist. I dropped the role and confirmed that it is gone now. Try recreating it now.

3 hours ago, gaubry said:

Bonus question: is phppgadmin (or something similar) installed?

Plesk does not come with that by default. You can install it yourself though from https://github.com/phppgadmin/phppgadmin/releases

[gaubry]

Thanks a lot, I could successfully create the user. Could you activate the remote access to this DB?

Best,

G.

[Krydos]

19 hours ago, gaubry said:

Could you activate the remote access to this DB?

Can you connect now?

[gaubry]

Thanks. I can connect now, but I have the feeling that the database is empty. Did I do something wrong?

[Krydos]

Can you see the data now? Another user had this same issue where the ownership wasn't set right on their PostgreSQL database.

[gaubry]

Yes, I can see my data now. Thanks a lot.