Re: [GENERAL] How to restore backup database

2014-09-08 Thread klo uo
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 postgre

Re: [GENERAL] How to restore backup database

2014-09-08 Thread Adrian Klaver
On 09/08/2014 10:49 AM, klo uo wrote: 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 with

Re: [GENERAL] How to restore backup database

2014-09-08 Thread klo uo
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

Re: [GENERAL] How to restore backup database

2014-09-08 Thread Adrian Klaver
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

[GENERAL] How to restore backup database

2014-09-08 Thread klo uo
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. 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/