| From: | Pushpendra Singh Thakur <thakur(at)corexprts(dot)com> |
|---|---|
| To: | Robert Frantz <rfrantz(at)cognitronix(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: How to restore an entire server from a .sql file created with PGAdmin Backup Server? |
| Date: | 2011-08-20 09:33:38 |
| Message-ID: | CAH55RCFKxbE=q5r8yOjB5L5yagQu2UJ6xS+0GTvAMHwSnAFxcg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | J | 2011-08-20 17:15:09 | Re: PostgreSQL on Amazon EC2/EBS |
| Previous Message | Tom Lane | 2011-08-18 15:55:01 | Re: Invalid input syntax for integer |