Re: Scripts Importing and Authentication

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: enio(at)pmpf(dot)rs(dot)gov(dot)br
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Scripts Importing and Authentication
Date: 2004-02-07 06:20:58
Message-ID: 17120.1076134858@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Enio Schutt Junior" <enio(at)pmpf(dot)rs(dot)gov(dot)br> 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Galbavy 2004-02-07 10:54:55 Re: hung postmaster when client machine dies?
Previous Message Tom Lane 2004-02-07 06:17:01 Re: Running postmaster with TCP/IP (ipv4)