Re: Strange permission problem regarding pg_settings

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: "Florian G(dot) Pflug" <fgp(at)solution-x(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Strange permission problem regarding pg_settings
Date: 2003-12-16 22:01:16
Message-ID: 20031216220116.GD14503@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2003-12-16 22:03:14 Re: [GENERAL][HACKERS]data fragmentation
Previous Message Gregory S. Williamson 2003-12-16 21:57:28 7.4 pg_dump and restore (with postGIS/GEOS)