pg_dumpall: permission denied for relation pg_shadow

Поиск
Список
Период
Сортировка
От CSN
Тема pg_dumpall: permission denied for relation pg_shadow
Дата
Msg-id 20060316215732.99465.qmail@web52913.mail.yahoo.com
обсуждение исходный текст
Ответы Re: pg_dumpall: permission denied for relation pg_shadow
Список pgsql-general
I tried using pg_dumpall and got this error:

pg_dumpall: query failed: ERROR:  permission denied
for relation pg_shadow
pg_dumpall: query was: SELECT usename, usesysid,
passwd, usecreatedb, usesuper, valuntil, (usesysid =
(SELECT datdba FROM pg_database WHERE datname =
'template0')) AS clusterowner FROM pg_shadow

I haven't messed around with template0. This is a
recent installation of postgres (8.0.x), done via yum.

Any idea what the problem is and how to fix it?

thanks,
CSN

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

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

Предыдущее
От: "Tomi NA"
Дата:
Сообщение: Re: picking the correct locale when doing initdb
Следующее
От: "Tomi NA"
Дата:
Сообщение: Re: Disability the trigger