Re: pg_restore and pgadmin3
| От | Jason Tan Boon Teck |
|---|---|
| Тема | Re: pg_restore and pgadmin3 |
| Дата | |
| Msg-id | dd8f6c970709102101qcf00ebcl21ecf9ce8b5b1c75@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: pg_restore and pgadmin3 ("Andrej Ricnik-Bay" <andrej.groups@gmail.com>) |
| Список | pgsql-novice |
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
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 по дате отправления: