Re: Users in pg_shadow

From: Scott Holmes <sholmes(at)pacificnet(dot)net>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Scott Holmes <sholmes(at)pacificnet(dot)net>, PG-General <pgsql-general(at)postgresql(dot)org>, scott(at)scotts(dot)mynetwork(dot)net
Subject: Re: Users in pg_shadow
Date: 2001-03-01 19:57:31
Message-ID: 200103011957.LAA16259@scotts.mynetwork.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmx(dot)net http://yi.org/peter-e/

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2001-03-01 20:01:53 Re: something more about my question about performance
Previous Message Lamar Owen 2001-03-01 19:49:41 Re: