Re: running vacuum in scripts

From: John DeSoi <desoi(at)pgedit(dot)com>
To: Belinda M(dot)Giardine <giardine(at)bio(dot)cse(dot)psu(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: running vacuum in scripts
Date: 2005-09-20 13:46:18
Message-ID: 32EE3367-A6EF-466E-A70B-982A3D16B08E@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Sep 19, 2005, at 2:27 PM, Belinda M. Giardine wrote:

> As far as I can tell vacuum must be run by the table or database
> owner.
> It wouldn't be as bad to have the password in the script if it was a
> limited permissions user. Any suggestions on the best methods?

Setup a .pgpass file so you don't need to embed the password in the
script:

http://www.postgresql.org/docs/8.0/interactive/libpq-pgpass.html

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vivek Khera 2005-09-20 14:00:53 Re: Backup and Restore mechanism in Postgres
Previous Message Hartel, Dirk 2005-09-20 13:28:37 Re: Errror in beltane