{"id":22694,"date":"2023-10-27T17:58:32","date_gmt":"2023-10-27T17:58:32","guid":{"rendered":"https:\/\/linuxways.net\/?p=22694"},"modified":"2023-10-27T17:59:59","modified_gmt":"2023-10-27T17:59:59","slug":"how-to-install-postgresql-in-ubuntu-22-04","status":"publish","type":"post","link":"https:\/\/linuxways.net\/de\/ubuntu\/how-to-install-postgresql-in-ubuntu-22-04\/","title":{"rendered":"How to install PostgreSQL in Ubuntu 22.04?"},"content":{"rendered":"

PostgreSQL <\/strong>is a Relational Database Management System used as a data warehouse for various Software Applications. PostgreSQL is faster at processing read-write queries, especially in Larger Datasets where complex queries are required. Postgres is a cross-platform database that can be installed on Ubuntu to perform different database operations.<\/p>\n

This article discusses how you can install PostgreSQL in Ubuntu 22.04.<\/p>\n

How to Install PostgreSQL in Ubuntu 22.04?<\/strong><\/h2>\n

Ubuntu <\/strong>is a Linux-based operating system that allows us to install and use different software applications securely and efficiently. PostgreSQL can be installed on Ubuntu by executing the \u201capt\u201d command. Once installed, you can access the Postgres Account. You will also be able to access the Databases. Follow the steps below to install PostgreSQL in Ubuntu 22.04.<\/p>\n

Step 1: Update Packages<\/strong><\/h3>\n

Before installing a new package in Ubuntu, update the existing Ubuntu packages repository:<\/p>\n

sudo<\/span> apt update<\/div><\/div>\n

<\/p>\n

Once the packages are updated, upgrade the packages that require upgradation using the below-provided command:<\/p>\n

sudo<\/span> apt upgrade -y<\/span><\/div><\/div>\n

The \u201c-y\u201d option confirms the upgradation of packages:<\/p>\n

<\/p>\n

Step 2: Install PostgreSQL<\/strong><\/h3>\n

After updating the existing Ubuntu Packages, Install PostgreSQL from the PostgreSQL repository. To Install PostgreSQL, use the \u201capt install\u201d command with sudo privileges:<\/p>\n

sudo<\/span> apt install<\/span> postgresql postgresql-contrib<\/div><\/div>\n

The Terminal will ask for additional disk space. Enter \u201cY\u201d to continue with the installation process:<\/p>\n

<\/p>\n

Step 3: Using PostgreSQL<\/strong><\/h3>\n

Once the PostgreSQL packages are installed, you must switch to the PostgreSQL Account to use it.<\/p>\n

Switch to Postgres Account<\/strong><\/h3>\n

To switch to the PostgreSQL account in the Terminal, use the \u201cpostgres\u201d command with the \u201c-iu\u201d option:<\/p>\n

sudo<\/span> -i<\/span> -u<\/span> postgres<\/div><\/div>\n

The \u201c-i\u201d option will ensure the start of the shell with root privileges. The Terminal command line will change to the \u201cpostgres\u201d command line ensuring that you are now using PostgreSQL:<\/p>\n

<\/p>\n

Access Postgres Prompt<\/strong><\/h3>\n

Now to access the PostgreSQL prompt, use the \u201cpsql\u201d command which will allow you to run SQL queries in the Terminal:<\/p>\n

psql<\/div><\/div>\n

Once you run the \u201cpsql\u201d command, the command line will change to the \u201cpostgres=#\u201d meaning you can now use the SQL queries inside the Terminal from the Postgres Account:<\/p>\n

<\/p>\n

Logout of Postgres Account:<\/strong><\/h3>\n

You can simply log out of the Postgres Account with the symbol \u201c\\\u201d followed by the alphabet \u201cq\u201d. Run the command below to log out from the Postgres Account:<\/p>\n

\\q<\/div><\/div>\n

This will switch back to PostgreSQL meaning you can now run queries directly from the terminal without having to access the Postgres Prompt:<\/p>\n

<\/p>\n

You can also log out or exit from PostgreSQL with the \u201cexit\u201d command:<\/p>\n

exit<\/span><\/div><\/div>\n

The command line changes to your username meaning you are no longer using the PostgreSQL Account:<\/p>\n

<\/p>\n

Directly access the Postgres Prompt<\/strong><\/h3>\n

Instead of logging in to PostgreSQL and then accessing the Postgres Prompt to run queries, you can directly access the Postgres Prompt as well. To access the Postgres Prompt directly, use the \u201cpostgres\u201d and \u201cpsql\u201d command:<\/p>\n

sudo<\/span> -u<\/span> postgres psql<\/div><\/div>\n

The command line directly changes to the Postgres Prompt:<\/p>\n

<\/p>\n

Creating a New Role<\/strong><\/h3>\n

A New Role in PostgreSQL is important for performing different operations in the database. Also, with the New Role, privileges for each role can be changed. A new role can be added to the Postgres Account. To create a New Role, log in to your PostgreSQL with the below-stated command:<\/p>\n

sudo<\/span> -i<\/span> -u<\/span> postgres<\/div><\/div>\n

The PostgreSQL command line will appear in the Terminal:<\/p>\n

<\/p>\n

To create a new role, the \u201ccreateuser\u201d command is used. The \u201c–interactive\u201d option will ask for the new role permissions:<\/p>\n

createuser --interactive<\/span><\/div><\/div>\n

The \u201c–interactive\u201d command will ensure that the command line asks for the new user or new role name and superuser permission. Enter the name, and permission and then hit \u201cEnter\u201d:<\/p>\n

<\/p>\n

You can also use the command below without having to log in to PostgreSQL to create a new role:<\/p>\n

sudo<\/span> -u<\/span> postgres createuser -interactive<\/span><\/div><\/div>\n

This will directly ask for the new role details in the Terminal:<\/p>\n

<\/p>\n

Creating a New Database<\/strong><\/h3>\n

The PostgreSQL Database is used as a data warehouse for numerous applications. To create a new database in PostgreSQL, log in to your Postgres Account and execute the following \u201ccreatedb\u201d Command:<\/p>\n

createdb darren<\/div><\/div>\n

The command line in the Terminal moves to the next line indicating that the database was created successfully:<\/p>\n

<\/p>\n

Connecting to a Database<\/strong><\/h3>\n

From the PostgreSQL Prompt, the Postgres account database can also be accessed. Once the database is accessed, the Postgres User can perform different queries in the Database. To connect to the Database, the \u201cpsql\u201d command is used along with the Database Name:<\/p>\n

psql -d<\/span> <<\/span>databaseName><\/span><\/div><\/div>\n

In our case, the Database Name is \u201cdarren\u201d. Thus to access the \u201cdarren\u201d database, ensure that you have accessed the PostgreSQL Prompt. To access the \u201cdarren\u201d database, the \u201cpsql\u201d command will be:<\/p>\n

psql -d<\/span> darren<\/div><\/div>\n

The option \u201c-d\u201d ensures access to the Database of the Postgres User \u201cdarren\u201d. Once accessed, the command line changes from \u201c=#<\/strong>\u201d to \u201c-#<\/strong>\u201d for Database:<\/p>\n

<\/p>\n

After you\u2019ve accessed the Postgres Account Database, you can check the information of the Database as well. To list the Database Details, the \u201cconninfo\u201d command is used:<\/p>\n

\\conninfo<\/div><\/div>\n

In our case, we listed the \u201cdarren\u201d database details:<\/p>\n

<\/p>\n

List all Databases in PostgreSQL<\/strong><\/h3>\n

All the Databases created inside the PostgreSQL can also be listed in the Ubuntu Terminal. To list the databases in PostgreSQL ensure that you have accessed the Postgres Prompt and then use \u201c\\list\u201d to list all databases:<\/p>\n

\\list<\/div><\/div>\n

In our case, we have Six PostgreSQL Databases in total:<\/p>\n

<\/p>\n

List all Postgres Users in PostgreSQL<\/strong><\/h3>\n

Similar to listing all the Databases in PostgreSQL, all the Postgres Users can also be listed. To list all the Postgres User Accounts, the \u201c\\du\u201d command is used. Before listing the User Accounts, ensure that you are logged in to the Postgres Prompt. Once logged in, use the command:<\/p>\n

\\du<\/span><\/div><\/div>\n

In our case, we have Three Postgres User Roles:<\/p>\n

<\/p>\n

Uninstalling PostgreSQL<\/strong><\/h2>\n

After you are done with using PostgreSQL and you do not require Postgres anymore, you can uninstall it to free up some space on your Ubuntu System. To uninstall PostgreSQL, use the \u201cremove\u201d command:<\/p>\n

sudo<\/span> apt remove postgresql postgresql-contrib<\/div><\/div>\n

Enter \u201cY\u201d during uninstalling to continue with the removal process:<\/p>\n

<\/p>\n

That\u2019s all about installing, using, and uninstalling PostgreSQL on Ubuntu 22.04.<\/p>\n

Conclusion<\/strong><\/h2>\n

PostgreSQL can be installed on Ubuntu 22.04 using the \u201capt install postgresql<\/strong>\u201d command. Once installed, you can create new roles, create new databases, and access databases from your Ubuntu System to perform queries. This article discusses the installation and usage of PostgreSQL in Ubuntu 22.04.<\/p>\n

 <\/p>","protected":false},"excerpt":{"rendered":"

PostgreSQL is installed using the \u201capt install postgresql\u201d command. With PostgreSQL, you can create new roles, databases, and access Postgres Prompt as well.<\/p>","protected":false},"author":110,"featured_media":22703,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-22694","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ubuntu"],"_links":{"self":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts\/22694","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/users\/110"}],"replies":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/comments?post=22694"}],"version-history":[{"count":0,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts\/22694\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/media\/22703"}],"wp:attachment":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/media?parent=22694"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/categories?post=22694"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/tags?post=22694"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}