3 homepage: https://www.postgresql.org/
5 PostgreSQL: The World's Most Advanced Open Source Relational Database.
8 To update or switch versions, run `webi postgres@stable` (or `@v10`, `@beta`,
13 > Postgres is the all-in-one database for beginners and experts alike. It
14 > handles SQL, 'NoSQL', JSON, HSTORE, Full-Text Search, Messages Queues and
15 > more. Best bang for buck.
17 ### Start the postgres server
19 Run just once (for development):
22 postgres -D $HOME/.local/share/postgres/var -p 5432
25 Run as a system service on Linux:
28 sudo env PATH="$PATH" \
29 serviceman add --system --username $(whoami) --name postgres -- \
30 postgres -D "$HOME/.local/share/postgres/var" -p 5432
33 ### Connect with the psql client
36 psql 'postgres://postgres:postgres@localhost:5432/postgres'
39 ### Initialize a database with a password
42 echo "postgres" > /tmp/pwfile
43 mkdir -p $HOME/.local/share/postgres/var/
45 initdb -D $HOME/.local/share/postgres/var/ \
46 --username postgres --pwfile "/tmp/pwfile" \
47 --auth-local=password --auth-host=password