pg_restore and pgadmin3

From: "Jason Tan Boon Teck" <tanboonteck(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: pg_restore and pgadmin3
Date: 2007-09-08 10:59:52
Message-ID: dd8f6c970709080359v14226bcdg6a4c2917d943f854@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I normally use pgadmin3 for backups and restorations. But sometimes, I only
have terminal access to certain servers. When I try to restore a backup made
with pgadmin3,

pg_restore -dmydb --disable-triggers mydb.backup

i get

pg_restore: [archiver] could not open input file: Permission denied.

How do i restore the backup file correctly?

Thanks

--
Jason Tan Boon Teck

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andrej Ricnik-Bay 2007-09-09 04:24:29 Re: pg_restore and pgadmin3
Previous Message yanot panara 2007-09-08 01:05:56 Need help configuring PAM