postgresql create database mac
sudo psql -U postgres
psql: FATAL: role "postgres" does not existpostgresql create database mac
sudo psql -U postgres
psql: FATAL: role "postgres" does not existpostgresql create database mac
postgres=# CREATE DATABASE DB_NAME;
CREATE DATABASE
postgres=# CREATE USER USER_NAME WITH password 's3cr3t';
CREATE ROLE
postgres=# GRANT ALL ON DATABASE DB_NAME TO USER_NAME;
GRANT
postgres=# \c DB_NAME
You are now connected to database "DB_NAME" as user "postgres".
DB_NAME=# REVOKE ALL ON SCHEMA public FROM public;
REVOKE
DB_NAME=# GRANT ALL ON SCHEMA public TO DB_NAME;
GRANT
DB_NAME=# \qpostgresql create database mac
postgres=# DROP USER USER_NAME;
DROP ROLEpostgresql create database mac
brew install postgresqlCopyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
