PostgreSQL
La base de donnťes la plus sophistiquťe au monde.

Ouverture de session

Contactez-nous

Administration du site :
"equipe chez postgresqlfr point org"

Contact presse :
"fr chez postgresql point org"

Contact association :
"bureau chez postgresqlfr point org"

Questions PostgreSQL :
 IRC :
  serveur irc.freenode.net
  canal #postgresqlfr

Recherche

Accéder aux archives

« Octobre 2008  
Lun Mar Mer Jeu Ven Sam Dim
  2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31  

Syndication

Flux XML

Sondage

Quelle est la version de PostgreSQL la plus répandue sur vos serveurs ?
8.3
10%
8.2
42%
8.1
40%
8.0
2%
7.4
6%
7.3 ou antérieure
0%
Nombre de votes: 48

Impossible de démarrer le service PostgreSQL

Technique - windows | Impossible de démarrer le service PostgreSQL

Par Kleberscow le 24/09/2007 - 12:07

J'ai vu qu'il existe plein de sujet à ce niveau-là mais j'avoue que je ne retrouve pas l'explication pour mon cas.

Voici la log de PostgreSQL pour ce cas :

2007-09-21 09:06:57 LOG: database system was shut down at 2007-09-21 09:03:32 Paris, Madrid (heure d'été)
2007-09-21 09:06:57 LOG: checkpoint record is at 8/A6598430
2007-09-21 09:06:57 LOG: redo record is at 8/A6598430; undo record is at 0/0; shutdown TRUE
2007-09-21 09:06:57 LOG: next transaction ID: 0/3967237; next OID: 21279
2007-09-21 09:06:57 LOG: next MultiXactId: 1; next MultiXactOffset: 0
2007-09-21 09:06:57 FATAL: the database system is starting up
2007-09-21 09:06:57 LOG: database system is ready
2007-09-21 15:43:09 LOG: could not rename temporary statistics file "global/pgstat.tmp" to "global/pgstat.stat": Unknown winsock error 10004
2007-09-21 15:43:11 LOG: could not rename temporary statistics file "global/pgstat.tmp" to "global/pgstat.stat": Unknown winsock error 10004
2007-09-21 15:43:11 LOG: could not rename temporary statistics file "global/pgstat.tmp" to "global/pgstat.stat": Unknown winsock error 10004
2007-09-21 15:44:00 LOG: could not rename temporary statistics file "global/pgstat.tmp" to "global/pgstat.stat": Unknown winsock error 10004
2007-09-21 15:44:00 LOG: could not rename temporary statistics file "global/pgstat.tmp" to "global/pgstat.stat": Unknown winsock error 10004
2007-09-21 15:44:09 LOG: could not rename temporary statistics file "global/pgstat.tmp" to "global/pgstat.stat": Unknown winsock error 10004
2007-09-21 15:44:36 LOG: could not rename temporary statistics file "global/pgstat.tmp" to "global/pgstat.stat": Unknown winsock error 10004
2007-09-21 15:44:37 LOG: could not rename temporary statistics file "global/pgstat.tmp" to "global/pgstat.stat": Unknown winsock error 10004
2007-09-21 15:54:33 LOG: could not rename temporary statistics file "global/pgstat.tmp" to "global/pgstat.stat": Unknown winsock error 10004
2007-09-21 15:54:33 LOG: could not rename temporary statistics file "global/pgstat.tmp" to "global/pgstat.stat": Unknown winsock error 10004
2007-09-21 15:55:02 LOG: could not rename temporary statistics file "global/pgstat.tmp" to "global/pgstat.stat": Unknown winsock error 10004
2007-09-21 15:55:05 LOG: could not rename temporary statistics file "global/pgstat.tmp" to "global/pgstat.stat": Unknown winsock error 10004
2007-09-21 15:55:05 LOG: could not rename temporary statistics file "global/pgstat.tmp" to "global/pgstat.stat": Unknown winsock error 10004
2007-09-21 15:55:05 LOG: could not rename temporary statistics file "global/pgstat.tmp" to "global/pgstat.stat": Unknown winsock error 10004
2007-09-21 15:55:07 LOG: could not rename temporary statistics file "global/pgstat.tmp" to "global/pgstat.stat": Unknown winsock error 10004
2007-09-21 15:55:07 LOG: could not rename temporary statistics file "global/pgstat.tmp" to "global/pgstat.stat": Unknown winsock error 10004
2007-09-21 15:55:09 LOG: could not rename temporary statistics file "global/pgstat.tmp" to "global/pgstat.stat": Unknown winsock error 10004
2007-09-21 15:55:19 LOG: could not rename temporary statistics file "global/pgstat.tmp" to "global/pgstat.stat": Unknown winsock error 10004
2007-09-21 15:55:19 LOG: could not rename temporary statistics file "global/pgstat.tmp" to "global/pgstat.stat": Unknown winsock error 10004
2007-09-21 15:55:20 LOG: could not rename temporary statistics file "global/pgstat.tmp" to "global/pgstat.stat": Unknown winsock error 10004
2007-09-21 15:55:20 LOG: could not rename temporary statistics file "global/pgstat.tmp" to "global/pgstat.stat": Unknown winsock error 10004
2007-09-21 15:56:09 LOG: could not rename temporary statistics file "global/pgstat.tmp" to "global/pgstat.stat": Unknown winsock error 10004
2007-09-21 15:56:11 LOG: could not rename temporary statistics file "global/pgstat.tmp" to "global/pgstat.stat": Unknown winsock error 10004
2007-09-21 15:56:15 LOG: could not rename temporary statistics file "global/pgstat.tmp" to "global/pgstat.stat": Unknown winsock error 10004
2007-09-21 15:56:15 LOG: could not rename temporary statistics file "global/pgstat.tmp" to "global/pgstat.stat": Unknown winsock error 10004
2007-09-21 15:56:15 LOG: could not rename temporary statistics file "global/pgstat.tmp" to "global/pgstat.stat": Unknown winsock error 10004
2007-09-21 15:56:32 LOG: could not rename temporary statistics file "global/pgstat.tmp" to "global/pgstat.stat": Unknown winsock error 10004
2007-09-21 15:56:32 LOG: could not rename temporary statistics file "global/pgstat.tmp" to "global/pgstat.stat": Unknown winsock error 10004
2007-09-21 15:56:32 LOG: could not rename temporary statistics file "global/pgstat.tmp" to "global/pgstat.stat": Unknown winsock error 10004
2007-09-21 15:57:09 LOG: could not rename temporary statistics file "global/pgstat.tmp" to "global/pgstat.stat": Unknown winsock error 10004

Et celle des évènements windows :

Type de l'événement : Erreur
Source de l'événement : PostgreSQL
Catégorie de l'événement : Aucun
ID de l'événement : 0
Date : 22/09/2007
Heure : 05:00:00
Utilisateur : N/A
Ordinateur : DOCUBASE
Description :
could not open process token: error code 5

Plutot que trop perdre de temps, la solution a été de desinstaller, réinstaller et restaurer Postgres et cela refonctionne.

Bref, y avait-il une solution plus simple ?

Options d'affichage des commentaires

Sélectionnez la méthode d'affichage des commentaires que vous préférez, puis cliquez sur "Sauvegarder les paramètres" pour activer vos changements.

Quelle version, quel OS ?

SAS/ = 25 Septembre, 2007 - 17:58

Pour l'OS, OK, j'ai deviné...
Mais pour la version ?

Librement,
Stéphane Schildknecht
dalibo
PostgreSQLFr


La version PostgreSQL est 8.2

Kleberscow/ = 25 Septembre, 2007 - 19:23

La version PostgreSQL est 8.2.3
La version Windows est 2003

Kleberscow, newbie en PostgreSQL


Vous avez réinstallé la mê

Guillaume Lelarge/ = 26 Septembre, 2007 - 08:01

Vous avez réinstallé la même version de PostgreSQL ? de plus, savez-vous qu'il existe une version 8.2.5 ? elle corrige un certain nombre de bugs.

--
Guillaume Lelarge.
Administrateur de bases de données
http://dalibo.com - http://dalibo.org


Juste pour dire que la migrat

Kleberscow/ = 18 Décembre, 2007 - 19:09

Juste pour dire que la migration en 8.2.5 a résolu mon souci.
Je remercie les personnes ayant répondu à mon sujet.

Kleberscow, newbie en PostgreSQL


© PostgreSQLFr, tous droits r√©serv√©s.
Site déclaré à la CNIL sous le numéro 1074678, conformément à la Loi en vigueur.