How to upgrade a PostgreSQL database using the pg_upgrade utility

Описание: LinkedIn -   / ruslan-potomka  

In today's video we'll talk about how to upgrade a PostgresSQL database cluster using the pg_upgrade utility.

Sooner or later you will encounter the problem of updating your PostgresSQL database to the latest version. Updating a database is a very important and sought-after task in the life of a database administrator, since the developers of the PostgresSQL DBMS with each new version eliminate various performance and security problems, and also add new functions.

0:00 Start
0:47 We deploy version 14 next to version 13 of the database
6:48 Run the database compatibility check command
10:28 Update launches
11:04 Launching version 14 of the database
11:57 The end

#postgresql #dbms #postgres #pg_upgrade #db #database