Postgres Pro
Downloads
Home   >   mailing lists

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__Svpc8ZV03eqY4d_03GcDoMTq175i138C5NRt139=gA@mail.gmail.com
Whole thread Raw
In response to Re: How to restore backup database  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: How to restore backup database  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
Hi Adrian,

I used pgAdmin backup command.
However in the meantime I figured how to restore.
I first have to create database, and then use restore option which becomes available if I right-click on a database.
On MSSQL for example, I can restore database without creating database first, and I guess I was expecting similar behavior.


Cheers



On Mon, Sep 8, 2014 at 6:47 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 09/08/2014 09:04 AM, klo uo wrote:
Hi,

I use PostrgrSQL 9.3 for couple of months now, on Windows.
I installed new Window OS, and before installing, I made tar backups of
my PostgreSQL databases.

 What was the command you used?

Now I want to restore these on my new OS, but I can't find such option
in pgAdmin.


In documentation (http://www.postgresql.org/docs/9.3/static/backup.html)
I see only suggestions how to restore sql dumps with command line tools,
but none how to restore single file tar backups.

Please suggest the right way to restore my backup databases.

 Well that depends on the answer to the previous question.



Thanks


--
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: How to restore backup database
Next
From: Dmitriy Igrishin
Date:
Subject: Async IO HTTP server frontend for PostgreSQL