Scripts Importing and Authentication

[Enio Schutt Junior]

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.

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ***@postgresql.org

[Tom Lane]

Post by Enio Schutt Junior
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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly