Postgres Pro
Downloads
Home   >   mailing lists

Re: How to restore an entire server from a .sql file created with PGAdmin Backup Server? - Mailing list pgsql-novice

From Pushpendra Singh Thakur
Subject Re: How to restore an entire server from a .sql file created with PGAdmin Backup Server?
Date
Msg-id CAH55RCFKxbE=q5r8yOjB5L5yagQu2UJ6xS+0GTvAMHwSnAFxcg@mail.gmail.com
Whole thread Raw
In response to How to restore an entire server from a .sql file created with PGAdmin Backup Server?  (Robert Frantz <rfrantz@cognitronix.com>)
List pgsql-novice
Tree view
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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Invalid input syntax for integer
Next
From: J
Date:
Subject: Re: PostgreSQL on Amazon EC2/EBS