How Do You Start the Postgres Service on an Ubuntu Linux Server?

Problem scenario
You have Postgres installed on an Ubuntu Linux server.  You want to start the Postgres service. How do you do this?

Solution
Run this command:  service postgresql start

If you want to list the databases on the server, run these three commands:

sudo -i -u postgres
psql
\l

# To exit the psql command prompt, issue this command and press "Enter":
\q

Leave a comment

Your email address will not be published.