PostgreSQL
PostgreSQL is a relational database. It was designed as the successor to Ingress.
Contents
Installation
Most Linux and BSD distributions offer a postgresql package that contains the core server components.
Docker container images are also available for all supported versions. The image is available from DockerHub as docker.io/library/postgres (or simply postgres when using docker(1) specifically).
Setup
Before using postgres(1), the database cluster needs to be instantiated.
initdb
For most usecases, this is sufficient. See here for details and more advanced usage.
Configuration
Configurations are primarily made with the configuration file. The file should consist of lines like parameter = value. The = is optional. Anything following a # is a comment.
Configurations can also be made with command line options (such as postgres -c log_connections=on). Parameters use the same names as the configuration file.
In either case, configurations are set at startup. To make a change, either restart the cluster or use pg_ctl reload.
Some parameters can be changed at run time with the SET SQL command.
See here for details on configuration.
Usage
The psql(1) utility is a convenient terminal client. See here for details on how to use it.
The connection string is structured as postgresql://postgres@localhost:5432/dbname?sslmode=disable. Naturally, if the connection should be encrypted, do not include the sslmode=disable component.