Pessoal agora deu certo acredito.... os erros acredito serem de archives feitos anteriormente na tentativa do acerto...
olhem o log de saída LOG: database system was interrupted; last known up at 2011-09-26 13:05:41 BRT LOG: starting archive recovery LOG: restored log file "000000010000000000000004" from archive LOG: redo starts at 0/4000020 LOG: consistent recovery state reached at 0/5000000 LOG: restored log file "000000010000000000000005" from archive LOG: restored log file "000000010000000000000006" from archive LOG: restored log file "000000010000000000000007" from archive LOG: restored log file "000000010000000000000008" from archive LOG: restored log file "000000010000000000000009" from archive LOG: restored log file "00000001000000000000000A" from archive LOG: restored log file "00000001000000000000000B" from archive LOG: restored log file "00000001000000000000000C" from archive LOG: restored log file "00000001000000000000000D" from archive LOG: restored log file "00000001000000000000000E" from archive LOG: restored log file "00000001000000000000000F" from archive LOG: restored log file "000000010000000000000010" from archive LOG: restored log file "000000010000000000000011" from archive LOG: restored log file "000000010000000000000012" from archive LOG: restored log file "000000010000000000000013" from archive LOG: restored log file "000000010000000000000014" from archive FATAL: the database system is starting up LOG: restored log file "000000010000000000000015" from archive LOG: restored log file "000000010000000000000016" from archive LOG: restored log file "000000010000000000000017" from archive LOG: restored log file "000000010000000000000018" from archive LOG: restored log file "000000010000000000000019" from archive LOG: restored log file "00000001000000000000001A" from archive cp: impossÃvel fazer stat em `/home/postgres/replicacao/archive/00000001000000000000001B': Arquivo ou diretório não encontrado LOG: could not open file "pg_xlog/00000001000000000000001B" (log file 0, segment 27): Arquivo ou diretório não encontrado LOG: redo done at 0/1A8FC758 LOG: last completed transaction was at log time 2011-09-26 14:15:46.591136-03 LOG: restored log file "00000001000000000000001A" from archive cp: impossÃvel fazer stat em `/home/postgres/replicacao/archive/00000002.history': Arquivo ou diretório não encontrado LOG: selected new timeline ID: 2 cp: impossÃvel fazer stat em `/home/postgres/replicacao/archive/00000001.history': Arquivo ou diretório não encontrado Em 27 de setembro de 2011 09:25, Dickson S. Guedes <[email protected]>escreveu: > Em 27 de setembro de 2011 09:04, Hélio José <[email protected]> escreveu: > > pg_ctl start -D /opt/postgres/9.0/data -l /opt/postgres/9.0/data/log > > > > pg_ctl: another server might be running; trying to start server anyway > > pg_ctl: could not start server > > Examine the log output. > > Removeu o postmaster.pid? > > > erro gravado em: /opt/postgres/9.0/data/log > > FATAL: data directory "/opt/postgres/9.0/data" has group or world access > > DETAIL: Permissions should be u=rwx (0700). > > > > olha só as permissões do diretório data: > > drwxr-x--- 14 postgres postgres 4096 Set 27 08:49 . > > Exato, é extremamente perigoso cheretas fuçando seus dados não? > Portanto você tem que dar a permissão informada no diretório que > aparece no detalhe. > > -- > Dickson S. Guedes > mail/xmpp: [email protected] - skype: guediz > http://guedesoft.net - http://www.postgresql.org.br > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > -- -- Hélio José (61) 99840139
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
