[pgbr-geral] Banco Corrompeu depois de um desligamento incorreto
Marcelo Costa
marcelojscosta em gmail.com
Quarta Novembro 4 13:52:58 UTC 2009
2009/11/4 Euler Taveira de Oliveira <euler em timbira.com>
> Marcelo Costa escreveu:
> > Euler, o serviço não sobe, se eu fizer um ps auxw | grep postgres não me
> > retorna nada assim como se pedir para verificar com o netstat.
> >
> > Esse é o problema não consigo identificar onde está o xabu. A única
> > mensagem que recebo do log é essa que passei no email anterior.
> >
> Que *não* é uma mensagem de erro, fatal ou pânico, ou seja, aparentemente
> está
> tudo normal. Há algo de estranho aí. Qual a versão do PostgreSQL? Qual o
> SO?
> Como está subindo o serviço? Tente utilizar o pg_ctl diretamente ou mesmo o
> postgres.
>
>
>
1. Versão 8.3
2. SO: Slackware Linux
3. O serviço sobe por meio de um script que chama o pg_ctl
Mais logs
---------------------------------------------------------------------------------------------------------------------------------------------
$ /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data/ start
0 DEBUG: 00000: postgres: PostmasterMain: initial environ dump:
0 LOCATION: PostmasterMain, postmaster.c:733
0 DEBUG: 00000: -----------------------------------------
0 LOCATION: PostmasterMain, postmaster.c:735
0 DEBUG: 00000: CPLUS_INCLUDE_PATH=/usr/lib/qt/include
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000:
MANPATH=/usr/local/man:/usr/man:/usr/lib/java/man:/usr/share/texmf/man
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: HZ=100
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: HOSTNAME=mcosta.uplexis.com.br
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: LINGUAS=pt_BR.utf8
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: TERM=xterm-color
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: SHELL=/bin/bash
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: QTDIR=/usr/lib/qt
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: USER=postgres
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000:
LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:su=37;41:sg=30;43:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.bat=01;32:*.BAT=01;32:*.btm=01;32:*.BTM=01;32:*.cmd=01;32:*.CMD=01;32:*.com=01;32:*.COM=01;32:*.dll=01;32:*.DLL=01;32:*.exe=01;32:*.EXE=01;32:*.arj=01;31:*.bz2=01;31:*.deb=01;31:*.gz=01;31:*.lzh=01;31:*.rar=01;31:*.RAR=01;31:*.rpm=01;31:*.tar=01;31:*.taz=01;31:*.tb2=01;31:*.tbz2=01;31:*.tbz=01;31:*.tgz=01;31:*.tz2=01;31:*.z=01;31:*.Z=01;31:*.zip=01;31:*.ZIP=01;31:*.zoo=01;31:*.asf=01;35:*.ASF=01;35:*.avi=01;35:*.AVI=01;35:*.bmp=01;35:*.BMP=01;35:*.flac=01;35:*.FLAC=01;35:*.gif=01;35:*.GIF=01;35:*.jpg=01;35:*.JPG=01;35:*.jpeg=01;35:*.JPEG=01;35:*.m2a=01;35:*.M2A=01;35:*.m2v=01;35:*.M2V=01;35:*.m4a=01;35:*.M4A=01;35:*.m4p=01;35:*.M4P=01;35:*.m4v=01;35:*.M4V=01;35:*.mov=01;35:*.MOV=01;35:*.mp3=01;35:*.MP3=01;35:*.mpc=01;35:*.MPC=01;35:*.mpeg=01;35:*.MPEG=01;35:*.mpg=01;35:*.MPG=01;35:*.ogg=01;35:*.OGG=01;35:*.pbm=01;35:*.pgm=01;35:*.png=01;35:*.PNG=01;35:*.ppm=01;35:*.ram=01;35:*.RAM=01;35:*.rm=01;35:*.RM=01;35:*.tga=01;35:*.TGA=01;35:*.tif=01;35:*.TIF=01;35:*.tiff=01;35:*.TIFF=01;35:*.wav=01;35:*.WAV=01;35:*.wma=01;35:*.WMA=01;35:*.wmv=01;35:*.WMV=01;35:*.xbm=01;35:*.xcf=01;35:*.xpm=01;35:*.xwd=01;35:*.XWD=01;35:
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: GDK_USE_XFT=1
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: KDEDIR=/usr
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: XDG_CONFIG_DIRS=/etc/xdg:/etc/kde/xdg:/etc/xfce/xdg
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: T1LIB_CONFIG=/usr/share/t1lib/t1lib.config
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: MINICOM=-c on
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000:
PATH=/usr/local/bin:/usr/bin:/bin:/usr/games:/usr/local/Adobe/Reader9/bin:/usr/local/pgsql/bin:/usr/lib/jdk1.6.0_13/bin:/usr/lib/jdk1.6.0_13:/usr/lib/java/bin:/usr/lib/java/jre/bin:/usr/lib/qt/bin:/usr/share/texmf/bin:.
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: MAIL=/var/spool/mail/postgres
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: _=/usr/local/pgsql/bin/postgres
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: LC_COLLATE=pt_BR.utf8
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: PWD=/home/postgres
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: INPUTRC=/etc/inputrc
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: JAVA_HOME=/usr/lib/java
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: LANG=pt_BR.utf8
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: PGSYSCONFDIR=/usr/local/pgsql/etc
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: HOME=/home/postgres
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: SHLVL=2
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: LANGUAGE=pt_BR.utf8
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: LS_OPTIONS= -F -b -T 0 --color=auto
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: LOGNAME=postgres
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: LESS=-M
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: G_FILENAME_ENCODING=@locale
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: PGDATA=/usr/local/pgsql/data
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: LESSOPEN=|lesspipe.sh %s
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000:
PKG_CONFIG_PATH=/usr/local/lib/pkgconfig:/usr/lib/pkgconfig
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: G_BROKEN_FILENAMES=1
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: LC_CTYPE=pt_BR.utf8
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: LC_MESSAGES=C
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: LC_MONETARY=C
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: LC_NUMERIC=C
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: LC_TIME=C
0 LOCATION: PostmasterMain, postmaster.c:738
0 DEBUG: 00000: -----------------------------------------
0 LOCATION: PostmasterMain, postmaster.c:740
server starting
--------------------------------------------------------------------------------------------------------------------------------------------------
--
Marcelo Costa
www.marcelocosta.net
-------------------------------------------------
“You can't always get what want”,
Doctor House in apology to Mike Jagger
-------------- Próxima Parte ----------
Um anexo em HTML foi limpo...
URL: <http://listas.postgresql.org.br/pipermail/pgbr-geral/attachments/20091104/2f88df99/attachment.html>
More information about the pgbr-geral
mailing list