Re: Not sure how to restore using pgadmin 1.16.1?

The psql command is \i /backup_directory/backup_filename

On Feb 28, 2013, at 1:50, Bastiaan Olij <bastiaan(at)basenlily(dot)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(at)basenlily(dot)me
> web: http://www.basenlily.me
> Skype: Mux213
> http://www.linkedin.com/in/bastiaanolij
>
>
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support