Comments on How to Install, Configure and Use latest PostgreSQL Version on Ubuntu
Postgres is an open-source relational database that has many advanced features like enterprise-class performance, triggers, Atomicity, Consistency, Isolation, and Durability. This tutorial shows how to install and configure the latest PostgreSQL version from the Official Postgres Ubuntu repository.
1 Comment(s)
Comments
Two mistakes:1. Package postgresql-contrib does not exists any more since PostgreSQL 10. Its content is since already included in postgresql package. Check the table in "Included in distribution" section at: https://www.postgresql.org/download/linux/ubuntu/2. Command systemctl status postgresql is not correct command to check if PostgreSQL is up. Do the test: a) start the server: sudo systemctl start postgresql b) corrupt postgresql.conf file (just change some setting to invalid one). c) restart server: sudo systemctl restart postgresqld) now check if service is up: systemctl status postgresql This command incorrectly states server is stared. Correct command to check if PostgreSQL is started on Ubuntu is: pg_lsclusters