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 3FB3ED1CCA6 for ; Thu, 5 Feb 2004 18:57:53 +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 33076-02 for ; Thu, 5 Feb 2004 14:57:47 -0400 (AST) Received: from mail.passofundo.rs.gov.br (unknown [200.182.187.131]) by svr1.postgresql.org (Postfix) with ESMTP id E624DD1B55C for ; Thu, 5 Feb 2004 14:57:45 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by mail.passofundo.rs.gov.br (Postfix) with ESMTP id 133D246E37 for ; Thu, 5 Feb 2004 16:47:42 -0300 (BRT) Received: from pmpf.rs.gov.br (localhost.localdomain [127.0.0.1]) by mail.passofundo.rs.gov.br (Postfix) with SMTP id 196D746E09 for ; Thu, 5 Feb 2004 16:47:40 -0300 (BRT) Date: Thu, 5 Feb 2004 19:47:40 -0000 To: Subject: Scripts Importing and Authentication From: "Enio Schutt Junior" X-Mailer: TWIG 2.6.1 Reply-To: enio@pmpf.rs.gov.br Message-Id: <20040205194740.196D746E09@mail.passofundo.rs.gov.br> X-Virus-Scanned: by AMaViS perl-11 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/90 X-Sequence-Number: 12264 The Postgresql I use is configured to authenticate users via md5 (trust option in pg_hba.conf file) These days, after pg_dump'ing a database, and then reimporting it, Postgresql asks for the password of every user which is described by the \connect command in the script. I have used the environment variables PGUSER and PGPASSWORD, but they work for only one user, and the script has about 4 users in it and I don't know which one of them Postgres wants to know, because it only shows the prompt saying 'password:' and nothing more. 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? (I haven't done that, I have disabled the authentication) Is there a way of making it without disabling the authentication? Thanks.