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 119 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
49 views
0 votes
1 answer

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

To count the number of records in ...READ MORE

answered Sep 26, 2018 in Database by Sahiti
• 6,290 points
118 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,290 points
113 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
82 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
46 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
54 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
63 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,130 points
604 views
0 votes
1 answer

Install postgreSQL on Ubuntu

Installing PostgreSQL on Ubuntu is very simple, ...READ MORE

answered Mar 22, 2019 in Database by Nitesh
78 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
42 views