To access created database on localhost, you can use the following command syntax: psql -h localhost -d DB-name -U DB-User Once the installation is completed, you can use the command-line tool of the client to establish a connection with the remote server: Those who don’t want the PostgreSQL Database server and just looking for the client to connect to some remote Database server can go for the given command: sudo apt install postgresql-client To enable again: sudo systemctl enable postgresql To disable at startup: sudo systemctl disable postgresql To restart: sudo systemctl restart postgresql Just for knowledge: To manage its service, you can use: systemctl status postgresqlīy default, the Database listens to 5432 for incoming connections. Once the installation is completed, let’s check whether the service of PostgreSQL is running without any error but on which port. The above command will install the latest stable version of PostgreSQL, if you want to install some old version of it then you have to mention the same in the command.įor example, to install PostgreSQL version 12, the command will be: sudo apt install postgresql-12 Hence, to install it just use the APT command given below: sudo apt install postgresql Well, the latest version of PostgreSQL is available to install using the Ubuntu 22.04 LTS Jammy JellyFish default repository. Install PostgreSQL Server on Ubuntu 22.04 Hence to update the APT package manager package index, run the system update command, once. In this tutorial, we will use the system’s default repository. The steps given here can be used for other Ubuntu or Debian-based systems such as Elementary OS, Linux Mint, MX Linux, POP_OS, and more… 1. Uninstall or remove PostgreSQL – Ubuntu 22.04 Steps to install PostgreSQL Database on Ubuntu 22.04 LTS Linux
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |