Next, exit from the Postgres Shell with the following command: exit Provide your desired password as shown below: Next set the Postgres user password with the following command: \password postgres
To set it, log in to the Postgres user with the following command: su - postgres
Once the installation is completed, verify the status of the PostgreSQL server with the following command: systemctl status postgresqlīy default, the password of the PostgreSQL user is not set. Next, update the repository and install the PostgreSQL server with the following command: apt-get update -yĪpt-get install postgresql postgresql-contrib -y Next, add the PostgreSQL repository with the following command: echo "deb `lsb_release -cs`-pgdg main" | tee /etc/apt//pgdg.list You will need to add the PostgreSQL repository in your system.įirst, download and add the Postgres key with the following command: wget -quiet -O - | apt-key add. apt-get update -y Step 2 – Install PostgreSQL Serverīy default, the latest version of the PostgreSQL is not available in the Ubuntu 18.04 default repository. Once you are logged into your Ubuntu 18.04 server, run the following command to update your base system with the latest available packages. Connect to your Cloud Server via SSH and log in using the credentials highlighted at the top of the page. Create a new server, choosing Ubuntu 18.04 as the operating system with at least 2GB RAM. Step 1 – Create Atlantic.Net Cloud Serverįirst, log in to your Atlantic.Net Cloud Server. A root password configured on your server.A fresh Ubuntu 18.04 VPS on the Cloud Platform.
Install pgadmin ubuntu how to#
In this tutorial, we will show you how to install and configure pgAdmin on Ubuntu 18.04. Powerful query tool and syntax highlighting editor.User-friendly, with powerful graphical interfaces.
Multi-platform compatible with multiple deployment models.pgAdmin comes with a rich set of features, a few of which are listed below: It is written in Python and Jquery and runs on most popular operating systems, including Windows, Linux, and Mac OS. PgAdmin is a free, open-source, and web-based tool for managing a PostgreSQL database server.
0 kommentar(er)
