Só para completar, usuário do banco somente o postgres. 2009/3/12 José Mello Júnior <[email protected]>
> 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 > -- 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
