Week 4: Connectivity of PostgreSQL server with Ubuntu (WSL) - Githubissues

CubeStatistica / Professional-Training-for-Data-Science-C1

Online-Professional-Training-for-Data-Science-Using-R (OPTDSUR) Professional-Training-for-Data-Science-C1

0 stars 1 forks source link

Week 4: Connectivity of PostgreSQL server with Ubuntu (WSL) #50

Open Zobia12 opened 2 years ago

Zobia12 commented 2 years ago

STEPS: 1. Install PostgreSQL, if not installed by running the following commands.

sudo apt update
apt install postgresql postgresql-contrib
After the installation you may double-check that postgresql daemon is active. service postgresql status

Start Using PostgreSQL Command Line Tool

-sudo -u postgres psql

After first launching psql, you may check the details of your connection by typing \conninfo .
If you want to see a list of all the databases that are available on a server, use \l command.
And to see a list of all the users with their privileges use \du command.
Since the default “postgres” user does not have a password, you should set it yourself.

\password postgres