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 • 638 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
 • 606 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, 2020 in Database by Okugbe
 • 280 points • 3,605 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,370 points • 645 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
 • 589 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
 • 436 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
 • 655 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
 • 572 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,240 points • 4,454 views
0 votes
2 answers

Install postgreSQL on Ubuntu

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

answered Nov 12, 2020 in Database by Prachi
 • 140 points • 938 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
 • 448 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.