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

pg_dump password

From: Q Beukes <pgsql-novice(at)list(dot)za(dot)net>
To: Postgresql Novice <pgsql-novice(at)postgresql(dot)org>
Subject: pg_dump password
Date: 2006-09-13 10:59:25
Message-ID: 4507E48D.8030608@list.za.net (view raw or flat)
Thread:
Lists: pgsql-novice
Hey,

We want to close up the db so people can't alter the database, so we
thought of using
a password. The problem now is that we can't have pg_dump run because it
prompts
for a password.

Are there any alternatives for closing up the database? Having host/user
based trust
isn't really an option because it's a web application, and if the web
user can simply
access the database, it would be all to easy to install a web pg admin
package.

If not, is there a way to pass on a password to the pg_dump(all) utility?

regards,
Q Beukes

Responses

pgsql-novice by date

Next:From: Oscar Rodriguez FonsecaDate: 2006-09-13 11:16:42
Subject: Re: Question About Aggregate Functions
Previous:From: Matthieu GuamisDate: 2006-09-13 10:15:13
Subject: Re: INSERT does not finish except if it is carried out a

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