Re: Backup & Restore a database in PostgreSQL

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: Backup & Restore a database in PostgreSQL
Дата
Msg-id D960CB61B694CF459DCFB4B0128514C206B93E53@exadv11.host.magwien.gv.at
обсуждение исходный текст
Ответ на Re: Backup & Restore a database in PostgreSQL  (Siva Palanisamy <siva_p@hcl.com>)
Список pgsql-general
Siva Palanisamy wrote:
> However, I get the same list of errors as below. The weird thing is,
it appears to be working fine. I
> could not able to comprehend the error list! I don't have any clue
about it!
>
> For your information, I don't think am running using the superuser
account! But just seem like a
> normal user account.. Could this lead to few issues on privileges?

The messages you get are to be expected if you try to restore a database
without the necessary permissions.

It worked for the objects that the user owns.

If you want to backup just a few tables or a certain schema in the
database,
use the -t or -n flags.
If you want to backup the whole database, make sure you have appropriate
permissions when you restore.

Yours,
Laurenz Albe

В списке pgsql-general по дате отправления:

Предыдущее
От: "David Johnston"
Дата:
Сообщение: Re: Query with rightmost function does not use index
Следующее
От: Martin Gainty
Дата:
Сообщение: Re: Russian Language Spam