Jump to content

Recommended Posts

Posted

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.

Posted
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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...