Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_restore and pgadmin3 - Mailing list pgsql-novice

From Jason Tan Boon Teck
Subject Re: pg_restore and pgadmin3
Date
Msg-id dd8f6c970709102101qcf00ebcl21ecf9ce8b5b1c75@mail.gmail.com
Whole thread Raw
In response to Re: pg_restore and pgadmin3  ("Andrej Ricnik-Bay" <andrej.groups@gmail.com>)
List pgsql-novice
Tree view
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.groups@gmail.com> wrote:
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



--
Jason Tan Boon Teck

pgsql-novice by date:

Previous
From: Keith Worthington
Date:
Subject: Returning multiple values from a function
Next
From: Tom Lane
Date:
Subject: Re: Returning multiple values from a function