Re: Scripts Importing and Authentication - Mailing list pgsql-admin

From Tom Lane
Subject Re: Scripts Importing and Authentication
Date
Msg-id 17120.1076134858@sss.pgh.pa.us
Whole thread Raw
In response to Scripts Importing and Authentication  ("Enio Schutt Junior" <enio@pmpf.rs.gov.br>)
List pgsql-admin
"Enio Schutt Junior" <enio@pmpf.rs.gov.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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Running postmaster with TCP/IP (ipv4)
Next
From: "Peter Galbavy"
Date:
Subject: Re: hung postmaster when client machine dies?