Postgresql User And Db Creation

Posted on December 9, 2024

sudo -u postgres psql  
postgres=# create database mydb;  
postgres=# create user myuser with encrypted password 'mypass';  
postgres=# grant all privileges on database mydb to myuser;

and as of postgres 15 there’s a change to the public schema due to security considerations:

have to still research this.

Hey! I'll happily receive your comments via email. Thanks for reading.

Andreas Wagner

freelance System Administrator and Ruby programmer in Tallinn, Estonia