[root@~]#su-postgres
Lastlogin:WedApr110:28:10CST2015onpts/2
-bash-4.2$psql-Upostgres
psql(9.4.0)
Type"help"forhelp.

postgres=#createuserrootwithpassword'password';
CREATEROLE
postgres=#GRANTALLPRIVILEGESONDATABASEmydatabasetoroot;
GRANT
postgres=#ALTERROLErootWITHSUPERUSER;

postgres=#\q

For personal testing only

Similar Posts:

• [Solved] zabbix Monitor postgres Error: “sh：psql command not found”
• [Solved] PSQL: fatal: the database system is starting up
• [How to Solve] psql: FATAL: role “postgres” does not exist
• error: permission denied to create database [How to Solve]
• [Solved] Psql reports “invalid command \N” error when restoring data
• [Solved] createdb: could not connect to database postgres: FATAL: Peer authentication failed for user “postgres”
• [Solved] Postgres Error: template1 is being accessed by other users
• Postgres invalid command data recovery processing
• PostgreSQL Connect Error: FATAL: no pg_hba.conf entry for host