Get:10 groovy-pgdg/main amd64 postgresql-common all 226.pgdg20.10+1 Get:9 groovy/main amd64 sysstat amd64 12.4.0-1 Get:7 groovy/main amd64 libjson-xs-perl amd64 4.020-1build1 Get:6 groovy/main amd64 libtypes-serialiser-perl all 1.0-1 Get:5 groovy-pgdg/main amd64 postgresql-client-common all 226.pgdg20.10+1 Get:4 groovy-pgdg/main amd64 pgdg-keyring all 2018.2 Get:3 groovy/main amd64 libjson-perl all 4.02000-2 Get:2 groovy/main amd64 libcommon-sense-perl amd64 3.75-1build2 Postgresql-client-common postgresql-common sysstatĠ upgraded, 11 newly installed, 0 to remove and 212 not upgraded.Īfter this operation, 59.4 MB of additional disk space will be used. Libtypes-serialiser-perl pgdg-keyring postgresql-12 postgresql-client-12 The following NEW packages will be installed: Libtypes-serialiser-perl pgdg-keyring postgresql-client-common Libcommon-sense-perl libjson-perl libjson-xs-perl libpq5 The following additional packages will be installed: Sample Output: sudo apt -y install postgresql-12 postgresql-client-12 ![]() The following package was automatically installed and is no longer required:Ġ upgraded, 0 newly installed, 0 to remove and 212 not 3: Add PostgreSQL 12 repository wget -quiet -O - | sudo apt-key add - echo "deb `lsb_release -cs`-pgdg main" |sudo tee /etc/apt//pgdg.list Step 4: Install PostgreSQL 12 on Ubuntu sudo apt update sudo apt -y install postgresql-12 postgresql-client-12 Wget is already the newest version (1.20.3-1ubuntu1). Vim is already the newest version (2:-3ubuntu2). Sample Output: sudo apt -y install vim bash-completion wgetīash-completion is already the newest version (1:2.11-2ubuntu1). If the package is already installed then you will get the below output, you can ignore it. sudo apt update Step 2: Install the required package sudo apt -y install vim bash-completion wget It is always recommended to update the system before installing PostgreSQL. We have now logged as postgres user into the postgres database.See also: Step 1: Update the Ubuntu system To login to postgresql shell as postgres user, Run the below commands. The Role postgres , Will have admin privileges such as Creating Roles, databases, configuring replication, managing users and permissions etc. ![]() Creating Users, Databases And Granting Permissionsīy default, PostgreSQL creates a Role ‘ postgres‘, and the database named postgres PostgreSQL 12 is the latest version available and we have installed it on the ubuntu system. sudo /usr/lib/postgresql/12/bin/psql -version We can also verify it checking the version of postgresql installed on the system. We can check the status of the postgresql service by running the below command. Once the PostgreSQL package is installed on the ubuntu system, Install the latest version of PostgreSQL using the below command. Update the apt packages list sudo apt-get update Import the repository signing key to the system. sudo sh -c 'echo "deb $(lsb_release -cs)-pgdg main" > /etc/apt//pgdg.list' Lets add the repository configuration to the ubuntu system. The PostgreSQL packages will be available in the default Ubuntu repository.īut to install the latest release of PostgreSQL, We need to add the latest repository to the system from the official PostgreSQL website. PostgreSQL runs on all major operating systems, has been ACID-compliant since 2001, and has powerful add-ons such as the popular PostGIS geospatial database extender. PostgreSQL has earned a strong reputation for its proven architecture, reliability, data integrity, robust feature set, extensibility, and the dedication of the open source community behind the software to consistently deliver performant and innovative solutions. ![]() PostgreSQL is an open source and powerful object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads. In this blog post, we will explain how to install PostgreSQL database on Ubuntu 18.04 What Is PostgreSQL?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |