Nesta altura aceito qualquer opinião, mas acredito que não esteja muito fora, ao parar o serviço o segundo log que estava com zero bytes enquanto a tentativa de conexão se efetivava, apareceu o seguinte:
2009-03-12 08:16:51 LOG: database system was shut down at 2009-03-12 06:15:11 2009-03-12 08:16:51 LOG: checkpoint record is at 0/7DB138 2009-03-12 08:16:51 LOG: redo record is at 0/7DB138; undo record is at 0/0; shutdown TRUE 2009-03-12 08:16:51 LOG: next transaction ID: 0/667; next OID: 17875 2009-03-12 08:16:51 LOG: next MultiXactId: 1; next MultiXactOffset: 0 2009-03-12 08:16:52 LOG: database system is ready 2009-03-12 08:16:52 FATAL: the database system is starting up 2009-03-12 08:16:53 ERROR: could not open relation 1663/1/1259: Permission denied 2009-03-12 08:17:06 FATAL: could not open relation 1663/10819/1259: Permission denied 2009-03-12 08:17:17 FATAL: could not open relation 1663/10819/1259: Permission denied 2009-03-12 08:18:07 FATAL: could not open relation 1663/10819/1259: Permission denied 2009-03-12 08:18:07 ERROR: could not open relation 1663/10819/1259: Permission denied 2009-03-12 08:19:07 ERROR: could not open relation 1663/1/1259: Permission denied 2009-03-12 08:19:56 FATAL: password authentication failed for user "JUNIOR" 2009-03-12 08:20:07 FATAL: password authentication failed for user "JUNIOR" 2009-03-12 08:20:07 ERROR: could not open relation 1663/10819/1259: Permission denied 2009-03-12 08:21:29 ERROR: could not open relation 1663/1/1259: Permission denied 2009-03-12 08:22:29 ERROR: could not open relation 1663/10819/1259: Permission denied 2009-03-12 08:23:29 ERROR: could not open relation 1663/1/1259: Permission denied 2009-03-12 08:24:30 ERROR: could not open relation 1663/10819/1259: Permission denied 2009-03-12 08:25:30 ERROR: could not open relation 1663/1/1259: Permission denied 2009-03-12 08:26:31 ERROR: could not open relation 1663/10819/1259: Permission denied 2009-03-12 08:27:31 ERROR: could not open relation 1663/1/1259: Permission denied 2009-03-12 08:28:31 ERROR: could not open relation 1663/10819/1259: Permission denied 2009-03-12 08:29:32 ERROR: could not open relation 1663/1/1259: Permission denied 2009-03-12 08:30:32 ERROR: could not open relation 1663/10819/1259: Permission denied 2009-03-12 08:31:33 ERROR: could not open relation 1663/1/1259: Permission denied 2009-03-12 08:32:33 ERROR: could not open relation 1663/10819/1259: Permission denied 2009-03-12 08:33:34 ERROR: could not open relation 1663/1/1259: Permission denied 2009-03-12 08:34:34 ERROR: could not open relation 1663/10819/1259: Permission denied 2009-03-12 08:35:18 LOG: received fast shutdown request 2009-03-12 08:35:18 LOG: shutting down 2009-03-12 08:35:18 LOG: database system is shut down 2009-03-12 08:35:19 LOG: logger shutting down Sistema operacional Windows Vista, usuário administrador JUNIOR e usuário para o serviço postgres, como o usuário JUNIOR é administrador (o mesmo nome tbem de antes da formatação) deveria automaticamente ter todas as permissões, mas o acesso foi negado, como posso tentar burlar esta permissão? 2009/3/12 Beto <[email protected]> > Seria muita inocencia minha pedir para verificar se o usuário que está > rodando o postgre tem permissão para acessar estes arquivos que foram > copiados para a pasta? (no caso de ter sido copiado por outro usuário por > exemplo, root) > > (Se for inocencia, favor ignorar a msg, mas também não tenho muita > experiência não...) > > 2009/3/12 José Mello Júnior <[email protected]> > >> Tive de formatar meu hd e reinstalei o postgres, mas ao retornar a >> pasta data o serviço não sobre, apresentando no LOG as últimas linhas o >> seguinte: >> >> 2009-03-12 06:14:09 DETAIL: Creating a shell type definition. >> 2009-03-12 06:14:09 NOTICE: argument type gtsq is only a shell >> 2009-03-12 06:14:09 WARNING: there is no transaction in progress >> 2009-03-12 06:15:10 LOG: received fast shutdown request >> 2009-03-12 06:15:10 LOG: shutting down >> 2009-03-12 06:15:11 LOG: database system is shut down >> 2009-03-12 06:15:11 LOG: logger shutting down >> tentando contornar o problema, renomeei a pasta "base" e copiei >> somente esta pasta do BKP para esta instalação, então vem mensagem em tempo >> de execuçao do pgadmin na tentativa de abrir o banco, a seguinte mensagem: >> >> Error connecting to server: FATAL: could not open relation >> 1663/10819/1259: permission denied >> >> Tenho chance de recuperar os dados? >> >> Muito obrigado >> >> -- >> José de Mello Júnior >> 41.9957-2007 >> >> _______________________________________________ >> pgbr-geral mailing list >> [email protected] >> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >> >> > > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > > -- José de Mello Júnior 41.9957-2007
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
