Re: 7.4 -> 7.4.1 upgrade with customization on freebsd - Mailing list pgsql-general

From Fernando Schapachnik
Subject Re: 7.4 -> 7.4.1 upgrade with customization on freebsd
Date
Msg-id 20040119175701.GR308@bal740r0.mecon.gov.ar
Whole thread Raw
In response to Re: 7.4 -> 7.4.1 upgrade with customization on freebsd  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
En un mensaje anterior, scott.marlowe escribió:
> On Sat, 17 Jan 2004, Joshua D. Drake wrote:
>
> > Hello,
> >
> >   Well... 7.4 to 7.4.1 is a direct upgrade. You do not have to do a
> > reinitdb which means you do
>
> You may have missed where bill said he wanted to change a default limit
> for plpgsql function args from 16 to something else.  that will require a
> reinitdb...

I missed that too. Instead of backing up the data directory, pg_dump and backup
the *.conf files. After the port upgrade, initdb, the replace the *.conf files
with the backuped up versions and pg_restore your DB.

Regards.

Fernando.

pgsql-general by date:

Previous
From: Fernando Schapachnik
Date:
Subject: Re: 7.4 -> 7.4.1 upgrade with customization on freebsd
Next
From: Tom Lane
Date:
Subject: Re: importing data