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

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 по дате отправления:

Предыдущее
От: Keith Worthington
Дата:
Сообщение: Returning multiple values from a function
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Returning multiple values from a function