Postgres Pro
Downloads
Home   >   mailing lists

Users in pg_shadow - Mailing list pgsql-general

From Scott Holmes
Subject Users in pg_shadow
Date
Msg-id 200103011830.KAA15829@scotts.mynetwork.net
Whole thread Raw
Responses Re: Users in pg_shadow  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Tree view 
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

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

--
---------------------------------------------------------------------
Scott Holmes                       http://www.pacificnet.net/~sholmes
                                   sholmes@pacificnet.net

  Independent Programmer/Analyst                  Passport 4GL
  PHP HTML Composer                PostgreSQL     Informix 4GL, SQL
---------------------------------------------------------------------
      There are more things in heaven and earth, Horatio,
             than are dreamt of in your philosophy
---------------------------------------------------------------------

pgsql-general by date:

Previous
From: "Anthony Metzidis"
Date:
Subject: PG_PWD and PG_PASSWORD Security
Next
From: Tom Lane
Date:
Subject: Re: Postgres eats up memory when using cursors