Re: su-like behavior - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: su-like behavior
Date
Msg-id 20060204040405.GA20796@surnet.cl
Whole thread Raw
In response to Re: su-like behavior  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-admin
Bruno Wolff III wrote:
> On Fri, Feb 03, 2006 at 15:48:35 -0800,
>   David Lutterkort <dlutter@redhat.com> wrote:

> >         [start as root]
> >         su - postgres
> >         psql
> >         \connect DBNAME DBUSER
> >         \i script.sql

Instead of using \connect, use SET SESSION AUTHORIZATION (and connect to
the right database in the first place).

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-admin by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: su-like behavior
Next
From: Alp UYANIK
Date:
Subject: autovacuum