2 # homepage: https://www.postgresql.org/
4 # PostgreSQL: The World's Most Advanced Open Source Relational Database.
6 # 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.
9 # Initialize a database with a password
12 # echo "postgres" > /tmp/pwfile
13 # mkdir -p $HOME/.local/share/postgres/var/
15 # initdb -D $HOME/.local/share/postgres/var/ \
16 # --username postgres --pwfile "/tmp/pwfile" \
17 # --auth-local=password --auth-host=password
22 # Start the postgres server
25 # postgres -D $HOME/.local/share/var/postgres -p 5432
28 # Connect with the psql client
31 # psql 'postgres://postgres:postgres@localhost:5432/postgres'