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!
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?
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,
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.