Re: pg_dump no longer honors --no-reconnect

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_dump no longer honors --no-reconnect
Date: 2003-09-29 19:22:53
Message-ID: 27665.1064863373@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> 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.)

Yes, because "SET SESSION AUTHORIZATION yourself" is allowed even if
you're not superuser. So for dumps containing only your own objects,
there's really no issue.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-09-29 19:25:59 Re: pg_dump permissions problem
Previous Message Bruce Momjian 2003-09-29 18:57:58 7.4 status