I want to move schemas and data of my current Postgres 11 database to a new Postgres 13 database.

I do pg_dump for that purpose to firstly dump to files schemas, data etc. I am not sure about whether should i also take pg_catalog schema. Can someone advice?

CodePudding user response：

pg_catalog contains the database metadata. When you export a database, you do not directly export data from these tables. They get exported implicitly in the shape of the CREATE and ALTER statements that pg_dump generates.

pg_dump will export all data from a database (but it excludes the definition of users and tablespaces and permissions on the database).