What are the prerequisites to install PostgreSQL on Ubuntu?

0 votes
What are the prerequisites to install PostgreSQL on Ubuntu?
Mar 22, 2019 in Database by Bob

edited Mar 22, 2019 223 views

1 answer to this question.

0 votes

Before you start installing postgreSQL, make sure you have the following:

Log in a root user

Create a new user

adduser ​bob

Grant the administrative privileges

usermod -aG sudo bob

Set up firewall

ufw app list
ufw allow OpenSSH
ufw enable
answered Mar 22, 2019 by Manoj

Related Questions In Database

0 votes
1 answer

What are the hardware requirements to install DB2 on Linux?

Hey @Kiran, DB2 Server is available for ...READ MORE

answered Mar 20, 2019 in Database by Kevin
139 views
0 votes
2 answers

What are the ways to get the count of records in a table

With the help of the SQL count ...READ MORE

answered Aug 20 in Database by Okugbe
• 280 points
545 views
0 votes
1 answer

What are the steps performed by Migration Wizard while migrating a database to MySQL?

The following are the steps  performed by ...READ MORE

answered Dec 10, 2018 in Database by Sahiti
• 6,320 points
175 views
0 votes
0 answers

How to install Oracle DB on ubuntu?

Can anyone help me with the step ...READ MORE

Feb 28, 2019 in Database by Sukanya Rajput
172 views
0 votes
1 answer

Switch to postgresql acoount

Switch over to the postgres account on your server ...READ MORE

answered Mar 22, 2019 in Database by Kyraa
82 views
0 votes
1 answer

Access progrs prompt without switching accounts

Use the following to get the postgres prompt ...READ MORE

answered Mar 22, 2019 in Database by Mahi
127 views
0 votes
1 answer

Create new role - postgresql on ubuntu

If you are logged in as the postgres account, ...READ MORE

answered Mar 22, 2019 in Database by Danny
104 views
0 votes
1 answer

Reset a sequence in Oracle

You can try out something like this create ...READ MORE

answered Sep 24, 2018 in Database by DataKing99
• 8,210 points
2,344 views
0 votes
2 answers

Install postgreSQL on Ubuntu

Follow the below commands to install PostgreSQL (PSQL) ...READ MORE

answered Nov 11 in Database by Prachi
• 140 points
191 views
0 votes
1 answer

Install MS SQL on Ubuntu

Hey @Kavita, follow these steps to install ...READ MORE

answered Mar 1, 2019 in Database by Kali
80 views