Vous n'êtes pas identifié(e).
Pages : 1
Bonjour,
J'ai une bdd Postgres tournant sur une Centos5 qui pose porblème sur la mise a jour en version mineur 8.4.22
Lorsque que tente l'upgrade j'ai des erreurs de conflits que je n'avais pas dans les upgrades précédents. Avez vous une idée ?
merci beaucoup
file /usr/share/man/man7/drop_table.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/drop_tablespace.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/drop_text_search_configuration.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/drop_text_search_dictionary.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/drop_text_search_parser.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/drop_text_search_template.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/drop_trigger.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/drop_type.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/drop_user.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/drop_user_mapping.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/drop_view.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/end.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/execute.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/explain.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/fetch.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/grant.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/insert.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/listen.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/load.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/lock.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/move.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/notify.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/prepare.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/prepare_transaction.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/reassign_owned.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/reindex.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/release_savepoint.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/reset.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/revoke.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/rollback.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/rollback_prepared.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/rollback_to_savepoint.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/savepoint.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/select.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/select_into.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/set.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/set_constraints.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/set_role.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/set_session_authorization.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/set_transaction.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/show.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/start_transaction.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/truncate.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/unlisten.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/update.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/vacuum.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/man/man7/values.7.gz from install of postgresql-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-8.4.21-1PGDG.rhel5.i386
file /usr/share/locale/de/LC_MESSAGES/libpq5-8.4.mo from install of postgresql-libs-8.4.22-1PGDG.rhel5.x86_64 conflicts with file from package postgresql-libs-8.4.21-1PGDG.rhel5.i386
Hors ligne
Je parie que vous avez utilisé l'option -i au lieu de -U pour les RPM. Quelle commande de mise à jour avez-vous lancé ?
Guillaume.
Hors ligne
Bonjour,
J'applique les upgrades depuis les commandes de gestion de packages avec un simple yum update
merci
Hors ligne
Bonjour,
Pour vous simplifier la vie, vous pourriez faire comme ça :
Arrêt de tous vos clusters sur ce serveur.
yum remove du postgresql 8.4.21
yum clean all
yum install du postgresql 8.4.22
Cordialement,
Cordialement,
Sébastien.
Hors ligne
Bonjour,
Merci pour l'info. J'hésite avec le remove c'est très expéditif sur une base en prod et le man ne me rassure pas.
remove or erase
Are used to remove the specified packages from the system as well as removing any packages which depend on the package being removed. remove operates on groups, files, pro-
vides and filelists just like the "install" command.
Vous avez deja procédé a cette action sur une base en prod ?
merci
bien cordialement
Hors ligne
oui j'ai déjà fait ça.
C'est radical mais ça à le mérite de fonctionner.
Si vous n'êtes pas sur il faut évidemment multiplier les sauvegardes.
Cordialement,
Sébastien.
Hors ligne
Au passage il semblerait que les paquets 8.4.21 soient en i386 et les paquets 8.4.22 en x86_64. Êtes-vous sur que la configuration du dépôt pgdg n'a pas été changée ?
Julien.
https://rjuju.github.io/
Hors ligne
Effectivement je penche sur ce problème j'ai ces repos je ne devrais pas avoir le i386
yum repolist
pgdg84
pgdg84-i386
Hors ligne
Salut,
Pour information finalement il n'y a pas de problèmes de repo.
C'est une installation sous Centos5 qui date de 6 ans.
Le serveur PostGreSQL est en 64bits, les clients en 32 bits. Je n'arrive toujours pas à fixer le problème. Ma base fait 1 To donc le backup/restore est trop long pour une activité en prod
Je continue de chercher
Dernière modification par johnnyb (23/09/2014 14:57:04)
Hors ligne
Pages : 1
