postgresql import backup into a new db

Question

I am trying to restore my .sql backup of postgresql. I read its documents but I want to have clear simple command for importing my whole db (schema and data) into a new postgresql db.

What you have tried? Just show that.

Sarfaraz Makandar
– Sarfaraz Makandar

2014-07-24 10:35:47 +00:00
Commented Jul 24, 2014 at 10:35 — Sarfaraz Makandar
– Sarfaraz Makandar, Commented Jul 24, 2014 at 10:35

Sarfaraz Makandar · Accepted Answer · 2014-07-24 10:44:17Z

3

First of all you need to create a database with template name template0 and use:

Example:

c:\program files\postgresql\9.3\bin> psql -h localhost -p 5432 
                                    -U postgres newDBname < D:\backup.sql

Note: Be sure with template name as template0 and enter a new database name in place of newDBname.

answered Jul 24, 2014 at 10:44

Sarfaraz Makandar

6,85319 gold badges67 silver badges86 bronze badges

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

Collectives™ on Stack Overflow

postgresql import backup into a new db

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