My Public Notepad

Here are some my notes on PostgreSQL on Ubuntu. To check the PostgreSQL version running: $ postgres -V Command 'postgres' not found,...

pgAdmin is a browser-based DB client. It is possible to run it from a Docker container  - an image is available at DockerHub: dpage/pgadmi...

If you just use the new Postgres version, it is very likely you'll get a message like this: FATAL:  database files are incompatible w...

Installation & Running  To start the server: $ initdb /usr/local/pgsql/data To start that instance: $ postgres -D /usr/loca...