CODEWITHSUNDEEP
databasepostgresql
Sreekar Swarnapuri
Sreekar Swarnapuri

Reputation: 175

Create local postgreSQL database with back up from database in Server

In a project that I support, we already have PostgreSQL database in different environments - Development, Integration and. production. I know we can take a back up of Integration database with PG_Dump and restore it to Development in order to sync those databases.

However, I want to understand if I can use the back up file from PG_dump to create the database locally in my system?

Upvotes: 0

Views: 366

Answers (1)

Laurenz Albe
Laurenz Albe

Reputation: 246298

A "local database" is not substantially different from a "remote database", so yes, that should work.

As always, note that restoring a dump on a lower PostgreSQL version than the one where it was taken is not supported (and will often fail).

Upvotes: 1

Related Questions