Re: pg_restore and pgadmin3

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

On 9/9/07, Andrej Ricnik-Bay <andrej(dot)groups(at)gmail(dot)com> wrote:
>
> On 9/8/07, Jason Tan Boon Teck <tanboonteck(at)gmail(dot)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
>

--
Jason Tan Boon Teck