PostgreSQL

Notes are for Manjaro Linux unless states otherwise.

Initializing Database

If using ZFS create new ZFS file system, configure its parameters for the database and mount it to ‘/var/lib/postgres/data’. See ZFS page for detiled instructions.

On Manjaro PostgreSQL needs to be initialized. Command as root:

sudo su - postgres -c "initdb --locale en_US.UTF-8 -D '/var/lib/postgres/data'"

Start Database

systemctl start postgresql

References

Date, Time and TimeZone

  1. Date and Time PostgreSQL documentation
  2. DATE and TIME Functions
  3. PostgreSQL Data Types: Date, Timestamp, and Time Zones
  4. How to Query Date and Time in PostgreSQL

Other

  1. GO Lang Driver