Re: How to restore backup database - Mailing list pgsql-general

From klo uo
Subject Re: How to restore backup database
Date
Msg-id CAA-8Ld-yjDDuDHM8jKgfV3u2xmxBu60LjCDPF=MwG-ArUhVyrw@mail.gmail.com
Whole thread Raw
In response to Re: How to restore backup database  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Abelard Hoffman
Date:
Subject: Re: psql and tab-delimited output
Next
From: Jeff Janes
Date:
Subject: Last active time for a database