Thread: pg_restore and pgadmin3

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

On 9/8/07, Jason Tan Boon Teck <tanboonteck@gmail.com> wrote:
> Hi,
Hi

> 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?
By correcting the file permissions.
Is that on a Linux/Unix box?  If so, what does
ls -l mydb.backup
say?


> Thanks
Cheers,
Andrej
--
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

Hi Andrej,


Thanks for the advice. I was using the backup files owned as postgres group. Now that i've changed ownership to postgres as well, i can now restore.

Thanks again.

jason




--
Jason Tan Boon Teck