Re: Strange permission problem regarding pg_settings - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Strange permission problem regarding pg_settings
Date
Msg-id 20031216220116.GD14503@dcc.uchile.cl
Whole thread Raw
In response to Re: Strange permission problem regarding pg_settings  ("Florian G. Pflug" <fgp@solution-x.com>)
Responses Re: Strange permission problem regarding pg_settings  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Fri, Dec 12, 2003 at 04:24:32AM +0100, Florian G. Pflug wrote:

> Am I right to assume that updating to 7.4 will have the same effekt as
> updating to 7.3.5? I ask because I plan to update to 7.4 sometime anyway,
> and util then it doesn't really hurt to connect as superuser, since this
> isn't a production system for the moment.

No, you're not.  You can update to 7.3.5 by just dropping the new
executables into place (after stopping the postmaster, of course).
Going to 7.4 will require you to dump all your data and reload.
(I'm assuming you are running 7.3.4 ...)

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"La experiencia nos dice que el hombre peló millones de veces las patatas,
pero era forzoso admitir la posibilidad de que en un caso entre millones,
las patatas pelarían al hombre" (Ijon Tichy)

pgsql-general by date:

Previous
From: "Gregory S. Williamson"
Date:
Subject: 7.4 pg_dump and restore (with postGIS/GEOS)
Next
From: Alvaro Herrera
Date:
Subject: Re: [ADMIN][HACKERS]data fragmentation