• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

Trouble creating databases adn users with Plesk 12 and Postgresql 9.3.5

Veltys

New Pleskian
Hello everyone,

I have a VPS with Ubuntu 14.04.1 LTS, Parallels Plesk 12.0.18 Update #18 (with Power Pack) and PostgreSQL 9.3.5.

When I setted up my VPS, I manually installed Parallels Plesk 12 and PostgreSQL 9.3.5.

Today I need to create an user and its corresponding database from Plesk Panel. When I connect with its subscription and try to create them, like this: Captura de pantalla (80).png

panel always give me this error: "Error: Connection to the database server failed: ERROR: role <whatever> already exists": Captura de pantalla (81).png

As you can see, database (and role) is created, but user not: Captura de pantalla (82).png

If I use different user name and database name is ok, but PostgreSQL server create two roles, two users and two databases.

Maybe I have some file configuration misconfigured? Is it possible to indicate PostgreSQL server that don't autocreate a database when a role is created? Maybe I'm more lost than Marco Rossi (from 3000 Leagues in Search of Mother) in mother's day?

With MySQL there is no problem with users and databases. Why PostgreSQL give this problem?

Thanks in advance,
 
Back
Top