Postgres 15.x development databases setup with Prisma

postgres_15_prisma.sh

# Things have changed in postgres 15.x+

$ createdb -O <your shell uid> foo_dev
$ createuser foo

$ psql
psql> grant all privileges on database foo_dev to foo;
psql> alter user foo with encrypted password 'random-password';

# enter the database that you just created
psql> create schema foo authorization foo;

# check your work so far
foo_dev=> \dn
  List of schemas
  Name  |  Owner
--------+---------
  foo   | foo
  ....
  
# foo should be listed.  Another check you can do is `show search_path`;

foo_dev=> show search_path;
   search_path
-----------------
 "$user", public


# if you have a test database (you should), you will need to repeat these steps for `foo_test`
# (except for creating the foo user, you already did that).
psql> exit


$ createdb -O <your shell uid> foo_test
$ psql
psql> grant all privileges on database foo_test to foo;

# for prisma 5, you need createdb
psql> alter user foo createdb;
# revoke with `alter user foo with nocreatedb;`

psql> exit

$ psql foo_test foo
psql> create schema foo authorization foo;