Thread: Not sure how to restore using pgadmin 1.16.1?
I have created some *.backup files using pgadmin 1.14 for pg 9.1 databases. When I select the file in the pgadmin 1.16.1 for pg 9.2, the Restore button never becomes enabled. Can anyone explain how to reform this task? -- View this message in context: http://postgresql.1045698.n5.nabble.com/Not-sure-how-to-restore-using-pgadmin-1-16-1-tp5746819.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.
On Wed, 2013-02-27 at 09:36 -0800, novnovice wrote: > I have created some *.backup files using pgadmin 1.14 for pg 9.1 databases. > When I select the file in the pgadmin 1.16.1 for pg 9.2, the Restore button > never becomes enabled. Can anyone explain how to reform this task? > Did you do a plain backup? if so, you cannot restore it with the restore tool of pgAdmin. You need to use psql. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
On 28/02/13 9:00 AM, Guillaume Lelarge wrote: > On Wed, 2013-02-27 at 09:36 -0800, novnovice wrote: >> I have created some *.backup files using pgadmin 1.14 for pg 9.1 databases. >> When I select the file in the pgadmin 1.16.1 for pg 9.2, the Restore button >> never becomes enabled. Can anyone explain how to reform this task? >> > Did you do a plain backup? if so, you cannot restore it with the restore > tool of pgAdmin. You need to use psql. > > One of the things I noticed in the latest versions of pgAdmin is that when you do a backup it is no longer selecting a format by default. You have to specifically select custom or tar to be able to restore. An easy user error to forget to select the format and create a backup you can't restore with pg_restore... -- Kindest Regards, Bastiaan Olij e-mail: bastiaan@basenlily.me web: http://www.basenlily.me Skype: Mux213 http://www.linkedin.com/in/bastiaanolij
The psql command is \i /backup_directory/backup_filename On Feb 28, 2013, at 1:50, Bastiaan Olij <bastiaan@basenlily.me> wrote: > On 28/02/13 9:00 AM, Guillaume Lelarge wrote: >> On Wed, 2013-02-27 at 09:36 -0800, novnovice wrote: >>> I have created some *.backup files using pgadmin 1.14 for pg 9.1 databases. >>> When I select the file in the pgadmin 1.16.1 for pg 9.2, the Restore button >>> never becomes enabled. Can anyone explain how to reform this task? >> Did you do a plain backup? if so, you cannot restore it with the restore >> tool of pgAdmin. You need to use psql. >> > One of the things I noticed in the latest versions of pgAdmin is that > when you do a backup it is no longer selecting a format by default. You > have to specifically select custom or tar to be able to restore. An easy > user error to forget to select the format and create a backup you can't > restore with pg_restore... > > -- > Kindest Regards, > > Bastiaan Olij > e-mail: bastiaan@basenlily.me > web: http://www.basenlily.me > Skype: Mux213 > http://www.linkedin.com/in/bastiaanolij > > > > -- > Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgadmin-support
I left the default settings intact which means compressed. I would expect a backup invoked via pgadmin with default settings to be able to be restored with pgadmin. Apparently it's supposed to work, but for some reason the restore button never becomes enabled? -- View this message in context: http://postgresql.1045698.n5.nabble.com/Not-sure-how-to-restore-using-pgadmin-1-16-1-tp5746819p5746862.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.
Thanks Bastiaan, you were right. Once I selected tar for the backup, restore was easy. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Not-sure-how-to-restore-using-pgadmin-1-16-1-tp5746819p5746870.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.