Forums PostgreSQL.fr

johnnyb

Membre

upgrade Postgres 8.4.21 to 8.4.22 impossible

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

gleu

Administrateur

Re : upgrade Postgres 8.4.21 to 8.4.22 impossible

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.

johnnyb

Membre

Re : upgrade Postgres 8.4.21 to 8.4.22 impossible

Bonjour,

J'applique les upgrades depuis les commandes de gestion de packages avec un simple yum update

merci

ruizsebastien

Membre

Re : upgrade Postgres 8.4.21 to 8.4.22 impossible

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.

johnnyb

Membre

Re : upgrade Postgres 8.4.21 to 8.4.22 impossible

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

ruizsebastien

Membre

Re : upgrade Postgres 8.4.21 to 8.4.22 impossible

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.

rjuju

Administrateur

Re : upgrade Postgres 8.4.21 to 8.4.22 impossible

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/

johnnyb

Membre

Re : upgrade Postgres 8.4.21 to 8.4.22 impossible

Effectivement je penche sur ce problème j'ai ces repos je ne devrais pas avoir le i386

yum repolist

pgdg84     
pgdg84-i386

johnnyb

Membre

Re : upgrade Postgres 8.4.21 to 8.4.22 impossible

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)