Re: Users in pg_shadow - Mailing list pgsql-general

From Scott Holmes
Subject Re: Users in pg_shadow
Date
Msg-id 200103011957.LAA16259@scotts.mynetwork.net
Whole thread Raw
In response to Re: Users in pg_shadow  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Well, I did have the -U argument using $PGUSER.  However, I made the all too
common mistake of forgetting that cron may or maynot have particular
environmental variables set.

Thanks...

>
> 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.
>
> --
> Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/



pgsql-general by date:

Previous
From: Lamar Owen
Date:
Subject: Re:
Next
From: "Richard Huxton"
Date:
Subject: Re: something more about my question about performance