From: | Lan Barnes <lan(at)falleagle(dot)net> |
---|---|
To: | Q Beukes <pgsql-novice(at)list(dot)za(dot)net> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: pg_dump password |
Date: | 2006-09-13 16:28:59 |
Message-ID: | 20060913162859.GA31067@falleagle.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Do you mean your scripts automating the pg_dump broke? Because otherwise
entering the password is trivial.
If it is a scripting problem, expect will fix it up for you. If you're
wandering in the swamps of Microsoft, I believe there is a M$ port of
expect now.
On Wed, Sep 13, 2006 at 12:59:25PM +0200, Q Beukes wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
--
Lan Barnes
Linux Guy, SCM Specialist
Tcl/Tk Enthusiast
The problem with OO code is really that you have to make a lot of it
before you can test it.
- Donal K. Fellows
From | Date | Subject | |
---|---|---|---|
Next Message | Don Parris | 2006-09-13 16:49:34 | Re: [NOVICE] Question About Aggregate Functions |
Previous Message | Tom Lane | 2006-09-13 15:10:08 | Re: pg_dump password |