2 # homepage: https://www.postgresql.org/
3 # tagline: PostgreSQL: The World's Most Advanced Open Source Relational Database
5 # Postgres is the all-in-one database for beginners and experts alike. It handles SQL, 'NoSQL', JSON, HSTORE, Full-Text Search, Messages Queues and more. Best bang for buck.
8 # Initialize a database with a password
11 # echo "postgres" > /tmp/pwfile
12 # mkdir -p $HOME/.local/share/postgres/var/
14 # initdb -D $HOME/.local/share/postgres/var/ \
15 # --username postgres --pwfile "/tmp/pwfile" \
16 # --auth-local=password --auth-host=password
21 # Start the postgres server
24 # postgres -D $HOME/.local/share/var/postgres -p 5432
27 # Connect with the psql client
30 # psql 'postgres://postgres:postgres@localhost:5432/postgres'