×

Install PostgreSQL on Debian 10 - Step by step process to do it ?

This article will guide you on how you can install PostgreSQL #DBMS on your Debian 10 system. Also, we also shared with you the method with which you can remove the PostgreSQL DBMS from your #Debian 10 system.

#PostgreSQL supports transaction s, subselects, trigger s, view s, foreign key referential integrity, and sophisticated locking.


pgAdmin is the de facto GUI tool for PostgreSQL, and the first tool anyone would use for PostgreSQL. It supports all PostgreSQL operations and features while being free and open-source. With pgAdmin you can Create, view and edit on all common PostgreSQL objects.

#PgAdmin is graphical user interface administration tool for PostgreSQL. It does not include a PostgreSQL database server.


To install PostgreSQL 9.5 on #Ubuntu:

1. sudo apt-get update.

2. sudo apt-get install postgresql postgresql-contrib.

3. sudo -u postgres psql.

4. # Replace xxxxxxx with your own password ALTER USER postgres WITH ENCRYPTED PASSWORD 'xxxxxxx';

5. # Feel free to replace nano with an editor of your choice sudo nano /etc/postgresql/9.5/main/pg_hba.conf.


ANALYZE in #Postgres collects statistics about the contents of tables in the database, and stores the results in the pg_statistic system catalog. Subsequently, the query planner uses these statistics to help determine the most efficient execution plans for queries.