Re: pain of postgres upgrade with extensions

Hello everybody,
First off all I am new in postgres but allready got some questions. It's
possible to wirte in a file from postgres?
Kevin Martins
--------------------------------------------------
From: "Dave Potts" <dave(dot)potts(at)pinan(dot)co(dot)uk>
Sent: Wednesday, March 12, 2008 8:46 PM
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: [GENERAL] pain of postgres upgrade with extensions

> Greg Sabino Mullane wrote:
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: RIPEMD160
>>
>>
>>
>>> - dump version N database
>>> - create empty version N+1 database
>>> - install N+1's version of each needed contrib module into new database
>>> - restore dump, ignoring "object already exists" errors
>>>
>>> There is a TODO to figure out some cleaner way of handling this sort
>>> of thing ...
>>>
>>
>> I think I smell a GSOC project....
>>
>
> I think there is a slight misunderstanding here, I was refering to
> extensions items such as postgis, plr, pgperl, etc. These have a slight
> different foot print to the projects in the contrib directory.
>
> Dave
>> - --
>> Greg Sabino Mullane greg(at)turnstep(dot)com
>> End Point Corporation
>> PGP Key: 0x14964AC8 200803121533
>> http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
>> -----BEGIN PGP SIGNATURE-----
>>
>> iEYEAREDAAYFAkfYMBMACgkQvJuQZxSWSsjmmwCg1JvB0G2py5jSbJdSZpWR8YyV
>> D4YAoLg2ZinEEGoNEU7S2mcL3bqhmNIh
>> =7pvA
>> -----END PGP SIGNATURE-----
>>
>>
>>
>>
>
>

>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>