X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 11BAF9DC804 for ; Sat, 4 Feb 2006 00:04:10 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 34026-09 for ; Sat, 4 Feb 2006 00:04:07 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from alvh.no-ip.org (200-126-99-146.bk7-dsl.surnet.cl [200.126.99.146]) by postgresql.org (Postfix) with ESMTP id 60CCD9DC812 for ; Sat, 4 Feb 2006 00:04:06 -0400 (AST) Received: by alvh.no-ip.org (Postfix, from userid 1000) id 6A064C2DC59; Sat, 4 Feb 2006 01:04:05 -0300 (CLST) Date: Sat, 4 Feb 2006 01:04:05 -0300 From: Alvaro Herrera To: Bruno Wolff III , David Lutterkort , pgsql-admin@postgresql.org Subject: Re: su-like behavior Message-ID: <20060204040405.GA20796@surnet.cl> Mail-Followup-To: Bruno Wolff III , David Lutterkort , pgsql-admin@postgresql.org References: <1139010516.27326.211.camel@currant.watzmann.net> <20060204025249.GA19279@wolff.to> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20060204025249.GA19279@wolff.to> User-Agent: Mutt/1.5.11 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=3.02 required=5 tests=[AWL=-0.887, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_POST=1.44, RCVD_IN_SORBS_DUL=1.988] X-Spam-Score: 3.02 X-Spam-Level: *** X-Archive-Number: 200602/34 X-Sequence-Number: 20455 Bruno Wolff III wrote: > On Fri, Feb 03, 2006 at 15:48:35 -0800, > David Lutterkort 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.