- INSTALL AND CONFIGURE POSTGRESQL UBUNTU 20.04 HOW TO
- INSTALL AND CONFIGURE POSTGRESQL UBUNTU 20.04 INSTALL
- INSTALL AND CONFIGURE POSTGRESQL UBUNTU 20.04 PASSWORD
Template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres + Postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | Name | Owner | Encoding | Collate | Ctype | Access privileges You will get the following output: List of databases To grant all privileges to the dbname to dbuser, run: grant all privileges on database dbname to dbuser
INSTALL AND CONFIGURE POSTGRESQL UBUNTU 20.04 PASSWORD
To create a new user named dbuser, run: create user dbuser with encrypted password 'dbpassword'
To create a database named dbname, run: create database dbname Postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | You will get the following output: List of roles Run the following command to verify the superuser: \du Next, create a superuser named root with the following command: CREATE ROLE root WITH LOGIN SUPERUSER CREATEDB CREATEROLE PASSWORD 'securepassword' Step 3 – Create a Database and User in PostgreSQLįirst, you can connect to PostgreSQL with the following command: su - postgres You will get the following output: version You can also verify the PostgreSQL version using the command below: sudo -u postgres psql -c "SELECT version() " Nov 26 04:57:30 ubuntu2004 systemd: Finished PostgreSQL RDBMS. Nov 26 04:57:30 ubuntu2004 systemd: Starting PostgreSQL RDBMS. Main PID: 17268 (code=exited, status=0/SUCCESS) Loaded: loaded (/lib/systemd/system/rvice enabled vendor preset: enabled)Īctive: active (exited) since Fri 04:57:30 UTC 43s ago
INSTALL AND CONFIGURE POSTGRESQL UBUNTU 20.04 INSTALL
Next, update the repository cache and install PostgreSQL 14 using the following command: apt-get update -yĪfter installing PostgreSQL, check the status of the PostgreSQL with the following command: systemctl status postgresql Next, download and add the PostgreSQL GPG key using the following command: wget -quiet -O - | apt-key add. You can add it with the following command: sh -c 'echo "deb $(lsb_release -cs)-pgdg main" > /etc/apt//pgdg.list' The latest version of PostgreSQL is not included in the Ubuntu default repository, so you will need to add the PostgreSQL official repository to the APT. Install the following prerequisites: apt install gnupg gnupg2 gnupg1 -y Step 2 – Install PostgreSQL 14 Once you are logged in to your 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 20.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 server running Ubuntu 20.04 on the Atlantic.Net Cloud Platform.
INSTALL AND CONFIGURE POSTGRESQL UBUNTU 20.04 HOW TO
In this post, we will explain how to install and configure PostgreSQL 14 on Ubuntu 20.04. At the time of writing this tutorial, the latest available version is PostgreSQL 14. It has many advanced features that allow developers to build fault-tolerant and complex applications. It is very popular due to its reliability, robustness of its features, and performance. PostgreSQL is a popular open-source object-relational database system.
0 kommentar(er)
