How to put in PostgreSQL on Ubuntu 18.04

How to put in PostgreSQL on Ubuntu 18.04

Probabilities are, you have a amount of community purposes or website products and services that count upon a databases or two. If that is the case, you are possibly employing Linux and are wanting at getting to put in both MySQL or PostgreSQL. The set up and usage of MySQL is quite uncomplicated. PostgreSQL, on the other hand, can vacation some men and women up. Simply because of this, I needed to wander you by way of the set up and first usage of PostgreSQL. And because Ubuntu 18.04 is the most recent LTS release, I have opted to exhibit on Canonical’s most latest system.

What you’ll will need

The only issues you’ll will need are a Ubuntu 18.04 server up and managing and accessibility to an account with sudo privileges. With those two at the ready, let’s put in PostgreSQL.

SEE: Procedure monitoring coverage (Tech Professional Investigation)

Set up

The set up of the databases is not all that hard. The very first matter we will do is update and up grade. Bear in mind, if the kernel will get upgraded, you’ll want to reboot the server. To that end, you could maintain off on this till a time when you can reboot the server.

To update/up grade, open up a terminal window and issue the subsequent instructions:

sudo apt-get update
sudo apt-get up grade

At the time the up grade completes, it is really time to put in. From the identical terminal window, issue the subsequent command:

sudo apt-get put in postgresql postgresql-contrib

The set up will entire without having inquiring you to established an admin password. What gives? PostgreSQL employs a principle named “roles” for authentication and does not distinguish involving users and groups. PostgreSQL roles are matched with a Linux system account. If a PostgreSQL job exists, a user account with the identical name will will need to exist. In other phrases, if there is a job named postgres, there’ll will need to be a user account named postgres. It is by way of such an account that we get accessibility to PostgreSQL.

Accessing the databases

From the terminal window, issue the command:

sudo -i -u postgres

This will change you to the postgres user. If you then sort psql you will find by yourself in the PostgreSQL prompt (Figure A).

Figure A

Figure A

The PostgreSQL prompt ready for motion.

Develop a new job

Out of the box, there is just one role—postgres. You may possibly want to generate a new job to use (which will also generate a Linux user account). This is how this is done. The very first matter you will have to do is log into the postgres account with the command:

sudo -i -u postgres

Upcoming, issue the command:

createuser --interactive

You will be requested:

  • To enter a name for the job.
  • Shall the new job be a superuser?

Let us say we have additional the job olivia. Just before that user can use PostgreSQL, you will have to also generate a user account like so:

sudo adduser olivia

At the time you’ve concluded this procedure, you can accessibility the PostgreSQL prompt like so:

sudo -i -u olivia

Due to the fact the user olivia will not have its have databases, to get accessibility to the databases prompt, we will have to instruct the company which databases to use like so:

psql -d postgres

The user olivia now has accessibility to the postgres databases.

SEE: twenty rapid ideas to make Linux networking easier (no cost TechRepublic PDF)

Producing a databases

Let us generate a databases named olivia. To do that, we will have to very first exit from the databases prompt with the command q and then exit from the olivia job with the command exit. Achieve accessibility to the postgres job with the command:

sudo -i -u postgres

Now we can generate the new databases with the command:

createdb olivia

With this new databases produced, our new job olivia will be ready to accessibility it without having getting to go the -d swap. So log back again into the olivia job with the command:

sudo -i -u olivia

Now issue the command:


The PostgreSQL prompt ought to look (Figure B).

Figure B

Figure B

Our new job now has accessibility to its have databases.

Producing a databases

Now that we have accessibility to the olivia databases, let’s generate a desk. Say you will need a desk named servers with the subsequent columns:

From the PostgreSQL prompt, you’d very first issue the command:

Develop Desk servers (

At the time you enter the previously mentioned command, you’ll detect the prompt modifications to involve the ( character.

Now we will sort the rest of the desk creation command (hitting Enter following each individual line):

IP varchar (twenty),
Objective varchar (twenty),
DeployDate varchar (twenty)

It is vital to notice that following the DeployDate line, there is no comma. At the time you strike Enter following the ) line, you will be returned to the prompt with an indication that the desk has been produced (Figure C).

Figure C

Figure C

Difficulty the command d and you can see all your tables (Figure D).

Figure D

Figure D

All of olivia’s tables at the ready.

Including knowledge

Say we want to increase an entry to our servers desk. This can be done with a command like so:

INSERT INTO servers (IP, Objective, DeployDate) VALUES ('', 'web', 'July 12, 2018')

You can then perspective the new knowledge with the command:

Select * FROM servers

The output will checklist any entries for the desk (Figure E).

Figure E

Figure E

Our desk now has some knowledge.

Content databases-ing

And that is quite substantially all there is to setting up and employing PostgreSQL. It truly is not also terribly hard at the time you fully grasp the dissimilarities involving it and, say, MySQL. You ought to now be ready to commence producing major headway with PostgreSQL. Content databases-ing!

Also read…

Your get

Have you worked with PostgreSQL? Share your ideas and lessons figured out with fellow TechRepublic users.

Server Set up

Proxy Server

Server Set up

Leave a Reply

Your email address will not be published.