User Tools

Site Tools


dev:postgres

This is an old revision of the document!


create user, and then database for that user.

  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;
dev/postgres.1676354858.txt.gz · Last modified: 2023/02/14 06:07 by 127.0.0.1