Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
How much database space remains available? Question Question
Is it possible to set trusted sources for managed databases from the API or doctl? Question Question

Question

How to create account on PostgreSQL Database with fully permissions like "posgres" account?

Posted October 11, 2019 2.5k views
DigitalOcean Managed PostgreSQL Database

Hello,

I need create the User Privileges in PostgreSQL Databases like account “postgres” with fully user permissions (Superuser, Create role, Create DB, Replicate, Bypass RLS). Because, the system can’t accept create account “postgres”.
Please, help me how to do that.

Regards and thanks,

Tien

Add a comment
aichilang
By:
aichilang

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
How much database space remains available? Question Question
Is it possible to set trusted sources for managed databases from the API or doctl? Question Question

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
Submit an Answer
2 answers
ServerEnthusiast October 23, 2019

I don’t believe that you could create a user with the same privileges as in order to do that you need super privileges. Is there a particular reason why you don’t just use the default one?

Reply Report
aichilang October 23, 2019

I install the Fusionpbx with external PostgreSQL (in this case external db using Cloud SQL of DigitalOcean), please see in line numbers 81,82 in file below ( will adding options - h z.z.z.z when execute):

https://github.com/fusionpbx/fusionpbx-install.sh/blob/master/debian/resources/postgresql.sh

It require superuser role. I don’t have knowledge about PostgreSQL administration, do you have any ideas for resolve this problem?
Thanks,

Reply Report

Related

Looking for something else?

Ask a new question Search for more help