Create local postgreSQL database with back up from database in Server

Question

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?

Sure, a local database is in no way different from a remote one. Do you encounter any problems? If, yes, please describe them in your question. — Laurenz Albe
– Laurenz Albe, Commented Oct 30, 2020 at 3:31
@Spikie This is a new application that I am supporting and I would like to create a local database using the backup of the database in the server, specifically Development. So that I could debug it locally. — Sreekar Swarnapuri
– Sreekar Swarnapuri, Commented Oct 30, 2020 at 15:13
@LaurenzAlbe There is no specific problem, I just wanted to know if I can use the backup file from the database in the server and create it in my local machine. — Sreekar Swarnapuri
– Sreekar Swarnapuri, Commented Oct 30, 2020 at 15:16

Laurenz Albe · Accepted Answer · 2020-10-30 15:19:52Z

1

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).

answered Oct 30, 2020 at 15:19

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create local postgreSQL database with back up from database in Server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related