Thread: Not sure how to restore using pgadmin 1.16.1?

Not sure how to restore using pgadmin 1.16.1?

From
novnovice
Date:
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.



Re: Not sure how to restore using pgadmin 1.16.1?

From
Guillaume Lelarge
Date:
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




Re: Not sure how to restore using pgadmin 1.16.1?

From
Bastiaan Olij
Date:
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




Re: Not sure how to restore using pgadmin 1.16.1?

From
Chris
Date:
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



Re: Not sure how to restore using pgadmin 1.16.1?

From
novnovice
Date:
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.



Re: Not sure how to restore using pgadmin 1.16.1?

From
novnovice
Date:
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.