There is a good article on this subject,
http://www.rootninja.com/how-to-restore-postgres-database-from-dumpall-backup/
On 18 August 2011 00:29, Robert Frantz <rfrantz(at)cognitronix(dot)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