Bonjour,
Je travaille sur PostgreSQL 8.4.2 sous Cent-OS 5.2.
Ci-dessous les logs de mon serveur lors d'un arrête/démarrage :
J'utilise "$POSTGRES_HOME/bin/pg_ctl stop -D $POSTGRES_DATA -s -m fast" pour arrêter et "$POSTGRES_HOME/bin/postmaster -D $POSTGRES_DATA" pour démarrer.
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20 18568 2010-03-12 08:34:16 CET 10 LOG: received fast shutdown request 18568 2010-03-12 08:34:16 CET 11 LOG: aborting any active transactions 127.0.0.1 30598 2010-03-12 08:34:16 CET idle 15 FATAL: terminating connection due to administrator command 127.0.0.1 30068 2010-03-12 08:34:16 CET idle 32 FATAL: terminating connection due to administrator command 127.0.0.1 19345 2010-03-12 08:34:16 CET idle 574 FATAL: terminating connection due to administrator command 127.0.0.1 30337 2010-03-12 08:34:16 CET idle 13 FATAL: terminating connection due to administrator command 127.0.0.1 29996 2010-03-12 08:34:16 CET idle 31 FATAL: terminating connection due to administrator command 127.0.0.1 29997 2010-03-12 08:34:16 CET idle 44 FATAL: terminating connection due to administrator command 127.0.0.1 30259 2010-03-12 08:34:16 CET idle 26 FATAL: terminating connection due to administrator command 19326 2010-03-12 08:34:16 CET 2 LOG: autovacuum launcher shutting down 127.0.0.1 29994 2010-03-12 08:34:16 CET idle 42 FATAL: terminating connection due to administrator command 127.0.0.1 29983 2010-03-12 08:34:16 CET idle 11 FATAL: terminating connection due to administrator command 19324 2010-03-12 08:34:16 CET 1 LOG: shutting down 19324 2010-03-12 08:34:16 CET 2 LOG: database system is shut down 7812 2010-03-12 08:34:52 CET 1 LOG: database system was shut down at 2010-03-12 08:34:16 CET 7815 2010-03-12 08:34:52 CET 1 LOG: autovacuum launcher started 7809 2010-03-12 08:34:52 CET 1 LOG: database system is ready to accept connections 127.0.0.1 7834 2010-03-12 08:35:02 CET idle 1 LOG: statement: set datestyle to 'ISO'; select version(), case when pg_encoding_to_char(1) = 'SQL_ASCII' then 'UNKNOWN' else getdatabaseencoding() end; 127.0.0.1 7834 2010-03-12 08:35:02 CET idle 2 LOG: statement: set client_encoding = 'UNICODE'
Les messages FATAL, SET DATESTYLE et SET CLIENT_ENCODING sont-ils normaux ?
Partager