Rohit Geddam
By Rohit Geddam

How to install Postgres on Linux (Debian)

How to install Postgres on Linux (Debian)

How to Install Postgres On Linux (Debian)


Step-1

Install using apt.

1
2
3
4
5
$ sudo apt update

$ sudo apt install postgresql postgresql-contrib

Step-2

Test your Installation

1
2
3
sudo -u posgtres psql

You will see: postgres=#

To quit type \q

Step-3

Create Postgres User

1
2
3
$ sudo -u postgres createuser --interactive

You will see:

1
2
3
4
5
Enter name of role to add: test

Shall the new role be a superuser? (y/n) y

Step-4

Create a Database

1
2
3
$ sudo -u postgres createdb test

Now create the same linux user as postgres user

1
2
3
$ sudo adduser test

Now login to your postgres database

1
2
3
$ sudo -u test psql

Step-5

Assign Password to postgres user

1
2
3
4
5
6
7
$ sudo -u postgres psql



postgres=# ALTER USER test with PASSWORD 'your-new-password';

The connection string for the above database will be postgres://test:your-new-password@localhost:5432/test