Upgrade PostgreSQL 14 to PostgreSQL 16 Step by Step Process in Ubuntu 22.04 LTS in Hindi

Опубликовано: 07 Сентябрь 2024
на канале: Chirags Tutorial (Chirags.in)

230

https://www.chirags.in/tutorial/index...

Step 1 — Installing PostgreSQL
**********
To install PostgreSQL, first refresh your server’s local package index:

$ sudo apt update

$ sudo apt install postgresql postgresql-contrib

Step 2 —

$ sudo -i -u postgres
Then you can access the Postgres prompt by running:

check version of postgresql
$ SELECT version();

postgres=# CREATE DATABASE mydatabase;

postgres=# \c mydatabase

mydatabase=# CREATE TABLE users (
id SERIAL PRIMARY KEY,
name VARCHAR(100),
age INT
);

mydatabase=# INSERT INTO users (name, age) VALUES ('Chirag', 30);
INSERT INTO users (name, age) VALUES ('Sanju', 25);

mydatabase=# SELECT * FROM users;
mydatabase=# \q

Step 3 - To change the PostgreSQL user's password, follow these steps:
log in into the psql console:

root@dept:~# sudo -u postgres psql

postgres=# \password postgres
Enter new password: new-password
postgres=# \q
Or using a query:

ALTER USER postgres PASSWORD 'admin@'123;
nano /etc/postgresql/14/main/pg_hba.conf

local all all md5 # like this
Then restart the server:

root@dept:~# sudo service postgresql restart

----Now Upgrade PostgreSQL 14 to PostgreSQL 16 Effortlessly with pg_upgrade------------

Step 1: Welcoming PostgreSQL 16
*******************************

Start by installing the shining star of our show, PostgreSQL 16. Let the magic unfold!

Create the file repository configuration: Add the PostgreSQL 16 repository
root@dept:~# sudo sh -c 'echo "deb https://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" /etc/apt/sources.list.d/pgdg.list'

Import the repository signing key:
root@dept:~# curl -fsSL https://www.postgresql.org/media/keys... | sudo gpg --dearmor -o /etc/apt/trusted.gpg.d/postgresql.gpg

Update the package lists:
root@dept:~# sudo apt-get update

Install the latest version of PostgreSQL.
If you want a specific version, use 'postgresql-16' or similar instead of 'postgresql':
root@dept:~# sudo apt-get -y install postgresql-16

Step 2: Checking Your Database Clusters
*****************************************

Verify that your server now proudly hosts both PostgreSQL 14 and PostgreSQL 16 using the pg_lsclusters command.

root@dept:~# sudo pg_lsclusters

Output:
Ver Cluster Port Status Owner Data directory Log file
14 main 5432 online postgres /var/lib/postgresql/14/main /var/log/postgresql/postgresql-14-main.log
16 main 5433 online postgres /var/lib/postgresql/16/main /var/log/postgresql/postgresql-16-main.log

Step 3: Preparing for the Upgrade
*********************************

Stop the PostgreSQL 16 cluster to prepare for the upgrade.

root@dept:~# sudo pg_dropcluster 16 main --stop

root@dept:~# sudo pg_lsclusters

Output:
Ver Cluster Port Status Owner Data directory Log file
14 main 5432 online postgres /var/lib/postgresql/14/main /var/log/postgresql/postgresql-14-main.log

Step 4: Initiating the Upgrade Process
***************************************

Start the upgrade process by executing the following command:

sudo pg_upgradecluster 14 main

Output:
...................
...................
Success. Please check that the upgraded cluster works. If it does,
you can remove the old cluster with
pg_dropcluster 14 main

Ver Cluster Port Status Owner Data directory Log file
14 main 5433 down postgres /var/lib/postgresql/14/main /var/log/postgresql/postgresql-14-main.log
Ver Cluster Port Status Owner Data directory Log file
16 main 5432 online postgres /var/lib/postgresql/16/main /var/log/postgresql/postgresql-16-main.log
root@dept:~#

Monitor the process, and upon success, confidently remove the older version.

root@dept:~# sudo pg_dropcluster 14 main

Step 5: Final Touch — Removing the Old Package
**********************************************

root@dept:~# sudo apt purge postgresql-14 postgresql-client-14

Step 6: Verification — Ensuring a Successful Upgrade
****************************************************

root@dept:~# sudo pg_lsclusters

Output:
Ver Cluster Port Status Owner Data directory Log file
16 main 5432 online postgres /var/lib/postgresql/16/main /var/log/postgresql/postgresql-16-main.log
$ sudo -u postgres psql

check version of postgresql
$ SELECT version();

Output:

postgres=# \c mydatabase

mydatabase=# SELECT * FROM users;

Output:
id | name | age
---+--------+----
1 | Chirag | 30
2 | Sanju | 25
(2 rows)

Note : Flow the Process shown in video.

😉Subscribe and like for more videos:
/ @chiragstutorial
💛Don't forget to, 💘Follow, 💝Like, Share 💙&, Comment

Tutorial Link :
https://www.chirags.in/tutorials/Post...

#postgres
#postgresql
#pointintimerecovery
#postgresqlTutorial
#pg_basebackup
#chiragstutorial
#chiragsdatabasetutorial
#database
#psql
#pgbouncer
#patroni

Смотрите видео Upgrade PostgreSQL 14 to PostgreSQL 16 Step by Step Process in Ubuntu 22.04 LTS in Hindi онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Chirags Tutorial (Chirags.in) 07 Сентябрь 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 230 раз и оно понравилось 5 людям.

42,620

673