Falhar a subir o postgres

Tchole
(usa Ubuntu)

Enviado em 04/05/2012 - 11:22h

Bom dia!

Estou instalando o "expressolivre" no ubuntu server 11.10, ao finalizar a instalação não sobe o Postgresql, já refiz a instalação e toda vez me retorna a mesma mensagem, se puderem me auxliliar.

* Starting PostgreSQL 9.1 database server
* The PostgreSQL server failed to start. Please check the log output. [fail]

Obrigado

removido
(usa Nenhuma)

Enviado em 04/05/2012 - 11:42h

Tá pedindo para você checar o log de saída. Você checou? Posta ele ai!

Tchole
(usa Ubuntu)

Enviado em 05/05/2012 - 20:48h

Então, o arquivo de log fica em var/log/postgresql???!!!!!!

segue log:
2012-05-03 09:19:42 BRT LOG: database system was shut down at 2012-05-03 09:19:40 BRT
2012-05-03 09:19:42 BRT LOG: incomplete startup packet
2012-05-03 09:19:42 BRT LOG: database system is ready to accept connections
2012-05-03 09:19:42 BRT LOG: autovacuum launcher started
2012-05-03 09:19:46 BRT LOG: incomplete startup packet
2012-05-03 09:19:46 BRT LOG: received fast shutdown request
2012-05-03 09:19:46 BRT LOG: aborting any active transactions
2012-05-03 09:19:46 BRT LOG: autovacuum launcher shutting down
2012-05-03 09:19:46 BRT LOG: shutting down
2012-05-03 09:19:47 BRT LOG: database system is shut down

Desde o dia que instalei pela primeira vez o log parece inalterado, onde estou errando, se puderem me ajudar.

Obrigado

removido
(usa Nenhuma)

Enviado em 06/05/2012 - 20:49h

Não tem informação nesse log! Tu instalou via apt mesmo? Ou compilou? Já chegou a dar uma olhada no syslog? Restarta o postgres e veja se tem alguma informação no syslog.

# tail -100 /var/log/syslog

Veja se esse diretório existe e se está com as devidas permissões:

# ls -lh /var/run/postgresql/

Se não crie:

# mkdir -p /var/run/postgresql
# chown postgres.postgres /var/run/postgresql

Restarte o postgres.

# /etc/init.d/postgresql-<version> restart

Tchole
(usa Ubuntu)

Enviado em 07/05/2012 - 09:38h

Sim instalei via apt.
Dei um restart no postgres e o que traz o syslog é o seguinte (lembrando que ele da falha ao restartar):
May 7 09:36:20 expresso cyrus/lmtpunix[14736]: DBERROR: critical database situation
May 7 09:36:20 expresso master[14738]: about to exec /usr/lib/cyrus/bin/lmtpd
May 7 09:36:20 expresso cyrus/imap[14737]: DBERROR db4: PANIC: fatal region error detected; run recovery
May 7 09:36:20 expresso cyrus/imap[14737]: DBERROR: critical database situation
May 7 09:36:20 expresso master[14739]: about to exec /usr/lib/cyrus/bin/imapd
May 7 09:36:20 expresso cyrus/lmtpunix[14738]: DBERROR db4: PANIC: fatal region error detected; run recovery
May 7 09:36:20 expresso cyrus/lmtpunix[14738]: DBERROR: critical database situation
May 7 09:36:20 expresso master[14740]: about to exec /usr/lib/cyrus/bin/lmtpd
May 7 09:36:20 expresso cyrus/imap[14739]: DBERROR db4: PANIC: fatal region error detected; run recovery
May 7 09:36:20 expresso cyrus/imap[14739]: DBERROR: critical database situation
May 7 09:36:20 expresso master[14741]: about to exec /usr/lib/cyrus/bin/imapd
May 7 09:36:20 expresso cyrus/lmtpunix[14740]: DBERROR db4: PANIC: fatal region error detected; run recovery
May 7 09:36:20 expresso cyrus/lmtpunix[14740]: DBERROR: critical database situation
May 7 09:36:20 expresso master[14742]: about to exec /usr/lib/cyrus/bin/lmtpd
May 7 09:36:20 expresso cyrus/imap[14741]: DBERROR db4: PANIC: fatal region error detected; run recovery
May 7 09:36:20 expresso cyrus/imap[14741]: DBERROR: critical database situation
May 7 09:36:20 expresso master[14743]: about to exec /usr/lib/cyrus/bin/imapd
May 7 09:36:20 expresso cyrus/lmtpunix[14742]: DBERROR db4: PANIC: fatal region error detected; run recovery
May 7 09:36:20 expresso cyrus/lmtpunix[14742]: DBERROR: critical database situation
May 7 09:36:20 expresso master[14744]: about to exec /usr/lib/cyrus/bin/lmtpd
May 7 09:36:20 expresso cyrus/imap[14743]: DBERROR db4: PANIC: fatal region error detected; run recovery
May 7 09:36:20 expresso cyrus/imap[14743]: DBERROR: critical database situation
May 7 09:36:20 expresso master[14745]: about to exec /usr/lib/cyrus/bin/imapd
May 7 09:36:20 expresso cyrus/lmtpunix[14744]: DBERROR db4: PANIC: fatal region error detected; run recovery
May 7 09:36:20 expresso cyrus/lmtpunix[14744]: DBERROR: critical database situation
May 7 09:36:20 expresso master[14746]: about to exec /usr/lib/cyrus/bin/lmtpd
May 7 09:36:20 expresso cyrus/imap[14745]: DBERROR db4: PANIC: fatal region error detected; run recovery
May 7 09:36:20 expresso cyrus/imap[14745]: DBERROR: critical database situation
May 7 09:36:20 expresso master[14747]: about to exec /usr/lib/cyrus/bin/imapd
May 7 09:36:20 expresso cyrus/lmtpunix[14746]: DBERROR db4: PANIC: fatal region error detected; run recovery
May 7 09:36:20 expresso cyrus/lmtpunix[14746]: DBERROR: critical database situation
May 7 09:36:20 expresso master[14748]: about to exec /usr/lib/cyrus/bin/lmtpd
May 7 09:36:20 expresso cyrus/imap[14747]: DBERROR db4: PANIC: fatal region error detected; run recovery
May 7 09:36:20 expresso cyrus/imap[14747]: DBERROR: critical database situation
May 7 09:36:20 expresso master[14749]: about to exec /usr/lib/cyrus/bin/imapd
May 7 09:36:20 expresso cyrus/lmtpunix[14748]: DBERROR db4: PANIC: fatal region error detected; run recovery
May 7 09:36:20 expresso cyrus/lmtpunix[14748]: DBERROR: critical database situation
May 7 09:36:20 expresso master[14750]: about to exec /usr/lib/cyrus/bin/lmtpd
May 7 09:36:20 expresso cyrus/imap[14749]: DBERROR db4: PANIC: fatal region error detected; run recovery
May 7 09:36:20 expresso cyrus/imap[14749]: DBERROR: critical database situation
May 7 09:36:20 expresso master[14751]: about to exec /usr/lib/cyrus/bin/imapd
May 7 09:36:20 expresso cyrus/lmtpunix[14750]: DBERROR db4: PANIC: fatal region error detected; run recovery
May 7 09:36:20 expresso cyrus/lmtpunix[14750]: DBERROR: critical database situation
May 7 09:36:20 expresso master[14752]: about to exec /usr/lib/cyrus/bin/lmtpd
May 7 09:36:20 expresso cyrus/imap[14751]: DBERROR db4: PANIC: fatal region error detected; run recovery
May 7 09:36:20 expresso cyrus/imap[14751]: DBERROR: critical database situation
May 7 09:36:20 expresso master[14753]: about to exec /usr/lib/cyrus/bin/imapd
May 7 09:36:20 expresso cyrus/lmtpunix[14752]: DBERROR db4: PANIC: fatal region error detected; run recovery
May 7 09:36:20 expresso cyrus/lmtpunix[14752]: DBERROR: critical database situation
May 7 09:36:20 expresso master[14754]: about to exec /usr/lib/cyrus/bin/lmtpd
May 7 09:36:20 expresso cyrus/imap[14753]: DBERROR db4: PANIC: fatal region error detected; run recovery
May 7 09:36:20 expresso cyrus/imap[14753]: DBERROR: critical database situation
May 7 09:36:20 expresso master[14755]: about to exec /usr/lib/cyrus/bin/imapd
May 7 09:36:20 expresso cyrus/lmtpunix[14754]: DBERROR db4: PANIC: fatal region error detected; run recovery
May 7 09:36:20 expresso cyrus/lmtpunix[14754]: DBERROR: critical database situation
May 7 09:36:20 expresso master[14756]: about to exec /usr/lib/cyrus/bin/lmtpd
May 7 09:36:20 expresso cyrus/imap[14755]: DBERROR db4: PANIC: fatal region error detected; run recovery
May 7 09:36:20 expresso cyrus/imap[14755]: DBERROR: critical database situation
May 7 09:36:20 expresso master[14757]: about to exec /usr/lib/cyrus/bin/imapd
May 7 09:36:20 expresso cyrus/lmtpunix[14756]: DBERROR db4: PANIC: fatal region error detected; run recovery
May 7 09:36:20 expresso cyrus/lmtpunix[14756]: DBERROR: critical database situation
May 7 09:36:20 expresso master[14758]: about to exec /usr/lib/cyrus/bin/lmtpd
May 7 09:36:20 expresso cyrus/imap[14757]: DBERROR db4: PANIC: fatal region error detected; run recovery
May 7 09:36:20 expresso cyrus/imap[14757]: DBERROR: critical database situation
May 7 09:36:20 expresso master[14759]: about to exec /usr/lib/cyrus/bin/imapd
May 7 09:36:20 expresso cyrus/lmtpunix[14758]: DBERROR db4: PANIC: fatal region error detected; run recovery
May 7 09:36:20 expresso cyrus/lmtpunix[14758]: DBERROR: critical database situation
May 7 09:36:20 expresso master[14760]: about to exec /usr/lib/cyrus/bin/lmtpd
May 7 09:36:20 expresso cyrus/imap[14759]: DBERROR db4: PANIC: fatal region error detected; run recovery
May 7 09:36:20 expresso cyrus/imap[14759]: DBERROR: critical database situation
May 7 09:36:20 expresso master[14761]: about to exec /usr/lib/cyrus/bin/imapd
May 7 09:36:20 expresso cyrus/lmtpunix[14760]: DBERROR db4: PANIC: fatal region error detected; run recovery
May 7 09:36:20 expresso cyrus/lmtpunix[14760]: DBERROR: critical database situation
May 7 09:36:20 expresso master[14762]: about to exec /usr/lib/cyrus/bin/lmtpd
May 7 09:36:20 expresso cyrus/imap[14761]: DBERROR db4: PANIC: fatal region error detected; run recovery
May 7 09:36:20 expresso cyrus/imap[14761]: DBERROR: critical database situation
May 7 09:36:20 expresso master[14763]: about to exec /usr/lib/cyrus/bin/imapd
May 7 09:36:20 expresso cyrus/lmtpunix[14762]: DBERROR db4: PANIC: fatal region error detected; run recovery
May 7 09:36:20 expresso cyrus/lmtpunix[14762]: DBERROR: critical database situation
May 7 09:36:20 expresso master[14764]: about to exec /usr/lib/cyrus/bin/lmtpd
May 7 09:36:20 expresso cyrus/imap[14763]: DBERROR db4: PANIC: fatal region error detected; run recovery
May 7 09:36:20 expresso cyrus/imap[14763]: DBERROR: critical database situation
May 7 09:36:20 expresso master[14765]: about to exec /usr/lib/cyrus/bin/imapd
May 7 09:36:20 expresso cyrus/lmtpunix[14764]: DBERROR db4: PANIC: fatal region error detected; run recovery
May 7 09:36:20 expresso cyrus/lmtpunix[14764]: DBERROR: critical database situation
May 7 09:36:20 expresso master[14766]: about to exec /usr/lib/cyrus/bin/lmtpd
May 7 09:36:20 expresso cyrus/imap[14765]: DBERROR db4: PANIC: fatal region error detected; run recovery
May 7 09:36:20 expresso cyrus/imap[14765]: DBERROR: critical database situation
May 7 09:36:20 expresso master[14767]: about to exec /usr/lib/cyrus/bin/imapd
May 7 09:36:20 expresso cyrus/lmtpunix[14766]: DBERROR db4: PANIC: fatal region error detected; run recovery
May 7 09:36:20 expresso cyrus/lmtpunix[14766]: DBERROR: critical database situation
May 7 09:36:20 expresso master[14768]: about to exec /usr/lib/cyrus/bin/lmtpd
May 7 09:36:20 expresso cyrus/imap[14767]: DBERROR db4: PANIC: fatal region error detected; run recovery
May 7 09:36:20 expresso cyrus/imap[14767]: DBERROR: critical database situation
May 7 09:36:20 expresso master[14769]: about to exec /usr/lib/cyrus/bin/imapd
May 7 09:36:20 expresso cyrus/lmtpunix[14768]: DBERROR db4: PANIC: fatal region error detected; run recovery
May 7 09:36:20 expresso cyrus/lmtpunix[14768]: DBERROR: critical database situation
May 7 09:36:20 expresso master[14770]: about to exec /usr/lib/cyrus/bin/lmtpd
May 7 09:36:20 expresso cyrus/imap[14769]: DBERROR db4: PANIC: fatal region error detected; run recovery
May 7 09:36:20 expresso cyrus/imap[14769]: DBERROR: critical database situation

O diretório /var/run/postgresql existe com as devidas permissões.

removido
(usa Nenhuma)

Enviado em 07/05/2012 - 09:52h

É... não tem informação também. Esse é servidor de e-mail é? Tu tá com problemas no cyrus! Enfim... Remove o postgres e instala novamente.

Listando pacotes instalados:

# dpkg -l | grep postgres

Removendo

# dpkg --purge postgres-9.xxxx

Tchole
(usa Ubuntu)

Enviado em 07/05/2012 - 10:08h

Sim é um servidor de emails. Pois nem cheguei ainda no cyrus... vou tentar remover o postgres, ja posto o resultado. obrigado

Tchole
(usa Ubuntu)

Enviado em 07/05/2012 - 10:50h

Ok. agora passou.
Obrigado

removido
(usa Nenhuma)

Enviado em 07/05/2012 - 10:58h

Por nada!