When creating a database using a common user
PG:: error: error: permission denied to create database
Solution:
log in with Postgres
sudo – u Postgres PSQL
postgres=# ALTER ROLE xxxx CREATEROLE CREATEDB;
XXXX: common user name
Give super permission
alter role XXXX creator ole superuser
Similar Posts:
- [Solved] createdb: could not connect to database postgres: FATAL: Peer authentication failed for user “postgres”
- [How to Solve] psql: FATAL: role “postgres” does not exist
- 029.PGSQL-pgsql Create New User Login Error: psql: FATAL: role “pguser” is not permitted to log in
- How to Solve Error: FATAL: role “root” does not exist
- [Solved] Postgres Error: template1 is being accessed by other users
- [Solved] PSQL: fatal: the database system is starting up
- [Solved] zabbix Monitor postgres Error: “sh：psql command not found”
- Postgres invalid command data recovery processing
- Solutions to MySQL error 1142: Error:ALTERcommanddeniedtouser’xxxx’@’localhost’fortable’uc_notelist’