install postgresql on mac
brew install postgresqlhow to open postgresql in mac
brew services start postgresqlpsql postgrespostgresql 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=# \qinstall psql mac
make sure yu have homebrew installed and updated, then run
$ brew install libpq
$ brew link --force libpq ailCopyright © 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
