X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 17D81D1DAA6 for ; Sat, 7 Feb 2004 06:21:06 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 61070-02 for ; Sat, 7 Feb 2004 02:21:04 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id AD524D1D5C7 for ; Sat, 7 Feb 2004 02:21:01 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i176KwMC017121; Sat, 7 Feb 2004 01:20:58 -0500 (EST) To: enio@pmpf.rs.gov.br Cc: pgsql-admin@postgresql.org Subject: Re: Scripts Importing and Authentication In-reply-to: <20040205194740.196D746E09@mail.passofundo.rs.gov.br> References: <20040205194740.196D746E09@mail.passofundo.rs.gov.br> Comments: In-reply-to "Enio Schutt Junior" message dated "Thu, 05 Feb 2004 19:47:40 +0000" Date: Sat, 07 Feb 2004 01:20:58 -0500 Message-ID: <17120.1076134858@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/108 X-Sequence-Number: 12282 "Enio Schutt Junior" writes: > So, is there a way of making the import of a script without > having to supply passwords of all different users contained > in that script? You want the script to use SET SESSION AUTHORIZATION instead of \connect. As of PG 7.4 this is the default; for a release or two beforehand, there's some arcane option you can specify to pg_dump. regards, tom lane