Hi Martin Pitt, *, Martin Pitt wrote:
> Hi Martin! > > Martin Theiss [2005-05-04 21:52 +0200]: > > Package: postgresql > > Version: 7.4.7-5 > > Severity: important > > > > > > If the automated dump/restore process fails during an upgrade, the user > > should be able to start a seperate postmaster process with the old > > version, dump the data manually and restore it to the new version. this > > is, what i understood while reading the documentation. > > Right, and in fact that's what usually happens automatically. > > > This is somehow impossible if one used plugins (e.g. chkpass) and there > > is no old version available. > > Right, but why /var/lib/postgresql/lib? All Debian packages I know use > /usr/lib/postgresql/lib, and the chkpass plugin from > postgresql-contrib does not put any additional libraries anywhere, > too. Does postgresql recognize libraries in that path? (I never tried > that). It's not additional libraries it's the chkpass library, that causes the problems. It's linked against a specific postgresql version. If the old process now tries to use the chkpass plugin the new version of chkpass is used, which is linked against the new version of libpq3, which is incompatible with the old postgres binary. That causes a conflict and in a result it is impossible to dump the data from the old database. Martin -- Martin Theiss <[EMAIL PROTECTED]> Primary key fingerprint: EC80 53A2 F0A2 6E6C 74D2 CB6E 002A F6D3 E78B 7F45 The box said 'Requires Windows 95 or better', so I installed Linux - TKK 5
signature.asc
Description: Digital signature
