In this article, we have shown how to install PostgreSQL 14 on Ubuntu step by step.
How to install PostgreSQL 14 on Ubuntu
1. Go to official PostgreSQL website .
Continue reading How to install PostgreSQL 14 on Ubuntu
How to download and restore PostgreSQL sample database
In this article, we will see how to download and restore PostgreSQL sample database. We can restore sample database in PostgreSQL server using following methods.
1. Using psql tool on windows.
2. Using Terminal on Linux.
First we have to download PostgreSQL sample database. Go through Download PostgreSQL Sample database
Restore PostgreSQL sample database on windows by using psql utility
Continue reading How to download and restore PostgreSQL sample database
PostgreSQL sample database
In this article, we will see how to download and restore PostgreSQL sample database in PostgreSQL server. We can use PostgreSQL sample database for learning and practice PostgreSQL. We will use the DVD rental database for demonstrating the features of PostgreSQL.
The DVD rental database has many objects including tables, views, trigger, functions, sequences and domain.
Download the PostgreSQL Sample database
How to install PostgreSQL on Kali Linux
In this article, we will see how to install PostgreSQL on Kali Linux step by step. In this article, we will perform below steps:
1. Install PostgreSQL on Kali Linux.
2. PostgreSQL post installation steps(Enable, start the PostgreSQL service).
3. Connect to PostgreSQL server on Kali Linux.
Install PostgreSQL on Kali Linux
How to install PostgreSQL and pgAdmin on windows 11
In this article, we will see how to install PostgreSQL and pgAdmin on windows 11 step by step.
Steps to install PostgreSQL and pgAdmin on Windows 11
1. Go to PostgreSQL Download Page
Continue reading How to install PostgreSQL and pgAdmin on windows 11
How to create database in Azure PostgreSQL Server
In this article, we will see how to create database in Azure PostgreSQL Server.
Database is collection objects like tables, views, indexes, schemas, ….etc.
We are going to create a database in Azure PostgreSQL server by using following two methods.
1. Using CREATE DATABASE command.
2. Using GUI method using pgadmin tool.
Continue reading How to create database in Azure PostgreSQL Server
How to reset password for user in Azure PostgreSQL server
In this article, we will see how to reset password for user in Azure PostgreSQL server.
We can reset password for a user in Azure PostgreSQL same as do for standard PostgreSQL server. We have two methods:
1. GUI i.e. using pgadmin tool
2. By running alter user/role command.
Continue reading How to reset password for user in Azure PostgreSQL server
How to find list of users in Azure PostgreSQL
In this article, we will see how to find list of users in Azure PostgreSQL. We can get list of users by querying against pg_user view and by expanding Login/Role Groups in pgadmin tool.
Find list of users in Azure PostgreSQL: Continue reading How to find list of users in Azure PostgreSQL
How to create user in Azure PostgreSQL
In this article, we will see how to create user in Azure PostgreSQL server.
We are going to create user in Azure MySQL server by using two ways.
1. Using GUI methods.
2. Using Create user statement on psql tool or pgadmin tool.
1. Create User in Azure PostgreSQL Database using Create User command:
PostgreSQL pgadmin error Unable to connect to Server
PostgreSQL pgadmin error Unable to connect to Server:
FATAL: Invalid username specified. Please check the Username and retry connection.
The Username should be in
Continue reading PostgreSQL pgadmin error Unable to connect to Server