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 [EMAIL PROTECTED]
