Re: How to restore backup database

On Mon, Sep 8, 2014 at 8:10 PM, Adrian Klaver wrote:

>
> You do not have to create a database in Postgres either. There are some
> system databases already created for you, template0(read only best left
> alone), template1 and postgres. You can connect to one of these(best
> practices, use postgres) and then have the restore script create the new
> database.<IMPORTANT> If you do this you need to check the Include CREATE
> DATABASE statement box (http://www.pgadmin.org/docs/1.18/restore.html)
> <IMPORTANT>
>
> To get a better idea of what is going on I would suggest reading the
> following sections of the docs:
>
> http://www.postgresql.org/docs/9.3/interactive/app-pgdump.html
>
> http://www.postgresql.org/docs/9.3/interactive/app-pgrestore.html
>
> This is what pgAdmin is using behind the scenes.
>

Nice.
Thanks for the tip and suggestions.

Cheers