Question
How to create account on PostgreSQL Database with fully permissions like "posgres" account?
- Posted on October 11, 2019
- DigitalOcean Managed PostgreSQL Database
Asked by aichilang
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
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
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.
Want to learn more? Join the DigitalOcean Community!
Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.
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,
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?