Skip to content

Instantly share code, notes, and snippets.

@bhubr

bhubr/psql-quickstart-macos.md

Last active March 26, 2024 20:54
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save bhubr/da99154446b20c828118c82bff6e9e5a to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save bhubr/da99154446b20c828118c82bff6e9e5a to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. bhubr renamed this gist Mar 26, 2024. 1 changed file with 0 additions and 0 deletions.
    0 gistfile1.txt → psql-quickstart-macos.md
    View file
    File renamed without changes.
  2. bhubr created this gist Mar 26, 2024.
    14 changes: 14 additions & 0 deletions gistfile1.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,14 @@
    # PostgreSQL quickstart macOS/homebrew

    <https://stackoverflow.com/questions/15301826/psql-fatal-role-postgres-does-not-exist>

    1. install: `brew install postgres`
    2. `initdb /usr/local/var/postgres`
    3. `/usr/local/Cellar/postgresql@11/11.22_1/bin/createuser -s postgres`

    Run `psql -U postgres`

    ## init db

    1. `CREATE ROLE app_ecommerce_nodejs WITH LOGIN PASSWORD 'passwd';`
    2. `CREATE DATABASE app_ecommerce_nodejs OWNER app_ecommerce_nodejs;`