![]() ![]() Selecting previously unselected package postgresql-client-common. Selecting previously unselected package pgdg-keyring. ![]() Selecting previously unselected package libpq5:amd64. Unpacking libjson-xs-perl (4.020-1build1). Selecting previously unselected package libjson-xs-perl. Unpacking libtypes-serialiser-perl (1.0-1). Selecting previously unselected package libtypes-serialiser-perl. Selecting previously unselected package libjson-perl. Unpacking libcommon-sense-perl (3.75-1build2). 192977 files and directories currently installed.) Selecting previously unselected package libcommon-sense-perl. 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 We can now proceed to install PostgreSQL 12 using the following command: sudo apt update 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 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. Open a terminal and type the following command: sudo apt update Step 2: Install the required package sudo apt -y install vim bash-completion wget To start the installation process, let’s ensure that the package list is up to date. It is always recommended to update the system before installing PostgreSQL. Superuser (root) access or a user with sudo privileges.createdb database_nameįor this, we will create a new Linux system user by using adduser.įor simplicity purpose, we will be using the same name as which we created the postgres role with, adam.Before we begin the installation, make sure you have the following: Run the below command as a postgres user account. Shall the new role be a superuser? (y/n) yĬreating a database is as simple as it gets. Now let us see how we can create additional users that can interact with the Databases.įor this, you have to be a postgres user and then run the command as shown below, createuser -interactive To exit the postgres shell, use the below command, \q You can access a PostgreSQL prompt using the psql utility psql We'll switch to the Postgres user account for the next steps, to switch to the Postgres account, use the following command, sudo -i -u postgres Postgresql-client-14 postgresql-client-common postgresql-common sysstat PostgreSQL Roles and Databases Libsensors-config libsensors5 libtypes-serialiser-perl postgresql-14 Libcommon-sense-perl libjson-perl libjson-xs-perl libllvm14 libpq5 Libmariadb3 libmysqlclient21 libndctl6 libpmem1 libsnappy1v5 liburing2 Galera-4 libconfig-inifiles-perl libdaxctl1 libdbd-mysql-perl libdbi-perl The following packages were automatically installed and are no longer required: Output: apt install postgresql postgresql-contrib Install PostgreSQL on Ubuntu by using the following command apt updateĪpt install postgresql postgresql-contrib PostgreSQL is a powerful, open-source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance. How to Install PostgreSQL on Ubuntu 22.10 ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |