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.kla...@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.kla...@aklaver.com >