Re: pgadmin III - database backup / restore

paul(dot)n(dot)shortis(at)mainroads(dot)qld(dot)gov(dot)au wrote:
>
>
>
> I'm investigating the use of Postgres for a future project & have installed
> beta 8.0 using the windows installer which includes pgadmin III. Everything
> works great, I can create tables etc. Connect from external applications...
> but, no matter what I do the Backup and Restore options on the pgadmin
> Tools menu remain disabled (irrespective of selected node in the tree). I
> can't find any mention of this feature in the online help or on mailing
> lists etc.
>
> Can anyone enlighten me ??

Backup/restore gui is the newest feature in pgAdmin3; please use the
very latest snapshot (2004-08-15) from www.pgadmin.org. Doc has to be
written.

You have to select which object you'd like to backup. You can backup a
database, a schema or a table.

You have to select a database or table to restore. After selecting the
backup file, you can examine it for contents ("view"). If you launched
"restore database", you also can select a single object to restore from
the contents.

If backup/restore remains disabled when selecting a database, the tools
pg_dump/pg_restore are not accessible (path or directory where
pgadmin3.exe lives). pgadmin3.zip includes them.

Regards,
Andreas