Skip site navigation (1) Skip section navigation (2)

Re: scripting vacuum

From: Andrew Kelly <akelly(at)transparency(dot)org>
To: postgres <pgsql-novice(at)postgresql(dot)org>
Subject: Re: scripting vacuum
Date: 2004-05-05 13:48:50
Message-ID: 1083764930.4131.145.camel@hermes.at.home (view raw or flat)
Thread:
Lists: pgsql-novice
On Wed, 2004-05-05 at 14:26, Tom Lane wrote:
> Andrew Kelly <akelly(at)transparency(dot)org> writes:
> > is my only hope of success to use 'expect', or is there a way
> > pass the pw as an arg to vacuumdb?
> 
> Put the password in the Postgres user's ~/.pgpass file.

That had me excited for a minute, until I found that it's only
available post 7.3.  Unfortunately I'm running 7.2.4 and can't upgrade.

> > You know, something like
> > 	local:username		all	trust
> 
> If you can't do that then you should consider updating to a more recent
> version of Postgres.  

Oh? I wasn't aware that that was even possible. 
Wait, lemme guess, it is, but not in my version, right?


> But I'd advise against writing it quite that way,
> since the above would let anyone on the local machine into your
> database --- they just have to claim to be the postgres user via -U.
> You might be able to use "ident" authentication safely, though, if your
> platform supports it on local connections.

Now there's an idea, thanks, Tom.

Andy


In response to

pgsql-novice by date

Next:From: Christopher.BeckerDate: 2004-05-05 15:21:56
Subject: CPU Utilization 100%...
Previous:From: Ed&Debbie van HekDate: 2004-05-05 13:23:02
Subject: using nextval in plpgsql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group