From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
---|---|
To: | David Lutterkort <dlutter(at)redhat(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: su-like behavior |
Date: | 2006-02-04 02:52:49 |
Message-ID: | 20060204025249.GA19279@wolff.to |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Fri, Feb 03, 2006 at 15:48:35 -0800,
David Lutterkort <dlutter(at)redhat(dot)com> wrote:
> Hi,
>
> I want to run some sql scripts through psql from a process that runs as
> root. Since I have no reason to trust the sql scripts, I want to run
> them in psql as a specific database user that doesn't have a
> corresponding login account, i.e. I want to do something like
>
> [start as root]
> su - postgres
> psql DBNAME DBUSER < script.sql
>
> or
> [start as root]
> su - postgres
> psql
> \connect DBNAME DBUSER
> \i script.sql
>
> The problem is that I haven't been able to do this without being
> prompted for a password. Is this possible, i.e. is there a way to go
> from a superuser (postgres) to a less privileged user without having to
> supply the password ?
You could use ident authentication and let the OS 'postgres' user connect
as any postgres user.
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2006-02-04 04:04:05 | Re: su-like behavior |
Previous Message | David Lutterkort | 2006-02-03 23:48:35 | su-like behavior |