Postgres Pro
Downloads
Home   >   mailing lists

Thread: How to restore an entire server from a .sql file created with PGAdmin Backup Server?

How to restore an entire server from a .sql file created with PGAdmin Backup Server?

From
Robert Frantz
Date:

I backed up my server using PGAdmin to plain text from one 9.0 server and now I want to restore it to another 9.0 server.

 

But when I highlight the server in the tree, under the tools menu, restore is grayed out.

 

The only references I've found discuss restoring individual databases with psql.

 

How do I restore an entire server from a .sql file (using PGAdmin?)

Re: How to restore an entire server from a .sql file created with PGAdmin Backup Server?

From
Pushpendra Singh Thakur
Date:
There is a good article on this subject, 

On 18 August 2011 00:29, Robert Frantz <rfrantz@cognitronix.com> wrote:

I backed up my server using PGAdmin to plain text from one 9.0 server and now I want to restore it to another 9.0 server.

 

But when I highlight the server in the tree, under the tools menu, restore is grayed out.

 

The only references I've found discuss restoring individual databases with psql.

 

How do I restore an entire server from a .sql file (using PGAdmin?)




--
Pushpendra Singh Thakur

COREEXPERTS Technologies Private Limited
Business Process Automation & IT Support Services
http://www.corexprts.com
Phone - 91-761-4070036
Fax - 91-761-4010530
SMS - 97-555-21174