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
