Martin Pitt wrote, on 2009-07-12 19:15:
Hello Arthur,
Arthur Marsh [2009-07-12 17:37 +0930]:
Starting PostgreSQL 8.4 database server: mainThe PostgreSQL server
failed to start. Please check the log output: failed! failed!
Weird that there was no log output. Can you please attach
/var/log/postgresql/* ?
Thanks,
Martin
Hi, there was nothing too obvious:
2009-07-12 16:39:09 CST LOG: incomplete startup packet
2009-07-12 16:39:11 CST LOG: received fast shutdown request
2009-07-12 16:39:11 CST LOG: aborting any active transactions
2009-07-12 16:39:11 CST LOG: autovacuum launcher shutting down
2009-07-12 16:39:11 CST LOG: shutting down
2009-07-12 16:39:11 CST LOG: database system is shut down
2009-07-12 16:59:32 CST LOG: database system was shut down at
2009-07-12 16:39:11 CST
I tried a restart, it reported a failure but appeared to work:
victoria:/var/log/postgresql# sh -x /etc/init.d/postgresql-8.4 restart
+ '[' -r /usr/share/postgresql-common/init.d-functions ']'
+ . /usr/share/postgresql-common/init.d-functions
++ . /lib/lsb/init-functions
+++ FANCYTTY=
+++ '[' -e /etc/lsb-base-logging.sh ']'
+++ true
+ VERSION=8.4
+ case "$1" in
+ restart 8.4
+ do_ctl_all restart 8.4 'Restarting PostgreSQL 8.4 database server'
+ '[' restart ']'
+ '[' 8.4 ']'
+ '[' -d /etc/postgresql/8.4 ']'
++ ls /etc/postgresql/8.4
+ '[' main ']'
+ '[' -x /usr/lib/postgresql/8.4/bin/postmaster ']'
+ status=0
+ log_daemon_msg 'Restarting PostgreSQL 8.4 database server'
+ '[' -z 'Restarting PostgreSQL 8.4 database server' ']'
+ log_daemon_msg_pre 'Restarting PostgreSQL 8.4 database server'
+ :
+ '[' -z '' ']'
+ echo -n 'Restarting PostgreSQL 8.4 database server:'
Restarting PostgreSQL 8.4 database server:+ return
+ for c in '/etc/postgresql/"$2"/*'
+ '[' -e /etc/postgresql/8.4/main/postgresql.conf ']'
++ basename /etc/postgresql/8.4/main
+ name=main
+ '[' -e /etc/postgresql/8.4/main/start.conf ']'
++ sed 's/#.*$//; /^[[:space:]]*$/d; s/^\s*//; s/\s*$//'
/etc/postgresql/8.4/main/start.conf
+ start=auto
+ '[' auto = auto ']'
+ log_progress_msg main
+ '[' -z main ']'
+ echo -n ' main'
main+ set +e
+ '[' restart = stop ']'
+ '[' restart = restart ']'
++ pg_ctlcluster --force 8.4 main restart
+ ERRMSG='The PostgreSQL server failed to start. Please check the log
output:'
+ res=1
+ set -e
+ '[' 1 -eq 0 ']'
+ '[' 1 -eq 2 ']'
+ status=1
+ '[' 1 -ne 0 -a -n 'The PostgreSQL server failed to start. Please check
the log output:' ']'
+ log_failure_msg 'The PostgreSQL server failed to start. Please check
the log output:'
+ '[' -n 'The PostgreSQL server failed to start. Please check the log
output:' ']'
+ log_begin_msg The PostgreSQL server failed to start. Please check the
log output:
+ '[' -z The ']'
+ echo -n The PostgreSQL server failed to start. Please check the log
output:
The PostgreSQL server failed to start. Please check the log output:+
log_end_msg 1
+ '[' -z 1 ']'
+ retval=1
+ log_end_msg_pre 1
+ :
+ log_use_fancy_output
+ TPUT=/usr/bin/tput
+ EXPR=/usr/bin/expr
+ '[' -t 1 ']'
+ '[' xxterm '!=' '' ']'
+ '[' xxterm '!=' xdumb ']'
+ '[' -x /usr/bin/tput ']'
+ '[' -x /usr/bin/expr ']'
+ /usr/bin/tput hpa 60
+ /usr/bin/tput setaf 1
+ '[' -z ']'
+ FANCYTTY=1
+ case "$FANCYTTY" in
+ true
++ /usr/bin/tput setaf 1
+ RED=''
++ /usr/bin/tput setaf 3
+ YELLOW=''
++ /usr/bin/tput op
+ NORMAL=''
+ '[' 1 -eq 0 ']'
+ '[' 1 -eq 255 ']'
+ /bin/echo -e ' failed!'
failed!
+ log_end_msg_post 1
+ :
+ return 1
+ true
+ log_end_msg 1
+ '[' -z 1 ']'
+ retval=1
+ log_end_msg_pre 1
+ :
+ log_use_fancy_output
+ TPUT=/usr/bin/tput
+ EXPR=/usr/bin/expr
+ '[' -t 1 ']'
+ '[' xxterm '!=' '' ']'
+ '[' xxterm '!=' xdumb ']'
+ '[' -x /usr/bin/tput ']'
+ '[' -x /usr/bin/expr ']'
+ /usr/bin/tput hpa 60
+ /usr/bin/tput setaf 1
+ '[' -z 1 ']'
+ true
+ case "$FANCYTTY" in
+ true
++ /usr/bin/tput setaf 1
+ RED=''
++ /usr/bin/tput setaf 3
+ YELLOW=''
++ /usr/bin/tput op
+ NORMAL=''
+ '[' 1 -eq 0 ']'
+ '[' 1 -eq 255 ']'
+ /bin/echo -e ' failed!'
failed!
+ log_end_msg_post 1
+ :
+ return 1
2009-07-13 07:28:26 CST LOG: database system was shut down at
2009-07-13 07:27:50 CST
2009-07-13 07:28:26 CST LOG: database system is ready to accept connections
2009-07-13 07:28:26 CST LOG: autovacuum launcher started
Regards,
Arthur.
--
To UNSUBSCRIBE, email to [email protected]
with a subject of "unsubscribe". Trouble? Contact [email protected]
