Re: pg_dump no longer honors --no-reconnect - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: pg_dump no longer honors --no-reconnect
Date
Msg-id Pine.LNX.4.44.0309291004200.22870-100000@peter.localdomain
Whole thread Raw
In response to pg_dump no longer honors --no-reconnect  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: pg_dump no longer honors --no-reconnect  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: pg_dump no longer honors --no-reconnect  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Bruce Momjian writes:

> Seems we can silently ignore a --use-set-session-authorization flag
> because that is now the default, but I don't see how we can ignore a
> --no-reconnect flag --- we should throw an error.

Why?  The new bevavior of pg_dump is to never reconnect -- exactly the
point of this change.

> Also, the 7.3 manual mentions that only the super-user can restore using
> --use-set-session-authorization.  This is now the only way to create
> dumps.  Seems this is a new limitation to pg_dump that we didn't
> discuss.

It had been dicussed on and off for quite some time.  This limitation
should only apply if you create dumps that contain objects owned by more
than one user.  (Does it?  I didn't check.)

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: more i18n/l10n issues
Next
From: Andreas Pflug
Date:
Subject: Re: ADD FOREIGN KEY (was Re: [GENERAL] 7.4Beta)