Re: Users in pg_shadow

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Users in pg_shadow
Дата
Msg-id Pine.LNX.4.30.0103012006200.760-100000@peter.localdomain
обсуждение исходный текст
Ответ на Users in pg_shadow  (Scott Holmes <sholmes@pacificnet.net>)
Ответы Re: Users in pg_shadow
Re: Users in pg_shadow
Список pgsql-general
Scott Holmes writes:

> I have a cron script set up to run VACUUM ANALYZE on two databases that appear
> to work fine except for a couple of messages that show up in the log:
>
> FATAL 1:  SetUserId: user 'newsltr' is not in 'pg_shadow'
> FATAL 1:  SetUserId: user 'wcgc_pg' is not in 'pg_shadow'
>
> newsltr and wcgc_pg are the respective names of the databases, there are no
> users with these names.  This is on a postgresql-7.0.2 running on a Red Hat 6.2

You should make your cron script to connect as the proper user, probably
using the -U option of psql or vacuumdb.  Otherwise the user name defaults
to one of various things, which is probably not desired here.

> I've seen no problems resulting from this but I would like to understand why.

Only if the fact that the VACUUM ANALYZE probably didn't actually execute
is not a problem... ;-)

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Set Operators and Arrays Question
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Postgres eats up memory when using cursors