Create postgresql user Mac OS X

create_user_postgres.md

Installing postgresql on Mac OS X

$ brew install postgresql@16 $ brew services start postgresql@16

If you fail to ping postgreql, do these steps:

1. Stop PostgreSQL

brew services stop postgresql@16

2. Delete the postmaster.pid

rm -f /opt/homebrew/var/postgresql@16/postmaster.pid

3. Start the PostgreSQL again

brew services start postgresql@16

Create postgresql user Mac OS X with password

After installing the postgres app: http://postgresapp.com/

It will create a database user with the current username, to create another user for example 'postgres':

$ createuser postgres -s

Open psql with the created user using -U

$ psql postgres -U postgres

Change the password

$ ALTER USER postgres WITH PASSWORD 'postgres';

Create an empty database - most migrations need this step

$ su - postgres $ createdb testdb

Access shell

$ psql