Re: How to restore backup database

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(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
>