Oi JotaComm,
2011/8/25 JotaComm <[email protected]>: > Olá, > > Em 25 de agosto de 2011 16:43, Diogo Borsoi <[email protected]> > escreveu: >> >> Pessoal, >> >> Fiz a migração do PG 8.2.5 para PG 9.0.4, porém nos logs observei o >> erro de "permission denied for large object". >> >> Teriam alguma sugestão? > > Sim. > > Da uma olhada no parâmetro lo_compat_privileges no arquivo postgresql.conf. > > Se você configurar ele para on o comportamento será o mesmo da versão 8 do > PostgreSQL. > Obrigado pela dica, em parte funcionou, não está dando mais o erro de permissão. No entanto está acontecendo alguma coisa estranha, a aplicação "morre" ao executar alguma operação no BD, segue erro: < 2011-08-25 20:53:17.329 BRT: 26574 - 192.168.1.7(59073) - idle in transaction > DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. < 2011-08-25 20:53:17.329 BRT: 26574 - 192.168.1.7(59073) - idle in transaction > HINT: In a moment you should be able to reconnect to the database and repeat your command. < 2011-08-25 20:53:17.329 BRT: 26574 - 192.168.1.7(59073) - idle in transaction > LOCATION: quickdie, postgres.c:2632 ... < 2011-08-25 20:53:17.350 BRT: 25077 - - > LOG: 00000: all server processes terminated; reinitializing < 2011-08-25 20:53:17.350 BRT: 25077 - - > LOCATION: PostmasterStateMachine, postmaster.c:3084 < 2011-08-25 20:53:17.388 BRT: 26796 - - > LOG: 00000: database system was interrupted; last known up at 2011-08-25 20: 52:16 BRT < 2011-08-25 20:53:17.388 BRT: 26796 - - > LOCATION: StartupXLOG, xlog.c:5744 < 2011-08-25 20:53:17.415 BRT: 26796 - - > LOG: 00000: database system was not properly shut down; automatic recovery i n progress < 2011-08-25 20:53:17.415 BRT: 26796 - - > LOCATION: StartupXLOG, xlog.c:5986 < 2011-08-25 20:53:17.418 BRT: 26796 - - > LOG: 00000: consistent recovery state reached at 23/F55735C8 < 2011-08-25 20:53:17.418 BRT: 26796 - - > LOCATION: CheckRecoveryConsistency, xlog.c:6604 < 2011-08-25 20:53:17.418 BRT: 26796 - - > LOG: 00000: redo starts at 23/F55735C8 < 2011-08-25 20:53:17.418 BRT: 26796 - - > LOCATION: StartupXLOG, xlog.c:6176 < 2011-08-25 20:53:17.530 BRT: 26796 - - > LOG: 00000: record with zero length at 23/F56DFEB0 < 2011-08-25 20:53:17.530 BRT: 26796 - - > LOCATION: ReadRecord, xlog.c:3766 < 2011-08-25 20:53:17.530 BRT: 26796 - - > LOG: 00000: redo done at 23/F56DFE70 < 2011-08-25 20:53:17.530 BRT: 26796 - - > LOCATION: StartupXLOG, xlog.c:6275 < 2011-08-25 20:53:17.530 BRT: 26796 - - > LOG: 00000: last completed transaction was at log time 2011-08-25 20:52:25.1 38216-03 < 2011-08-25 20:53:17.530 BRT: 26796 - - > LOCATION: StartupXLOG, xlog.c:6280 < 2011-08-25 20:53:17.589 BRT: 25077 - - > LOG: 00000: database system is ready to accept connections < 2011-08-25 20:53:17.589 BRT: 25077 - - > LOCATION: reaper, postmaster.c:2407 Teria alguma sugestão? [ ]s Diogo > >> >> Att. >> >> >> -- >> ================================================= >> Diogo Borsoi >> Mobile: +55 12 91436960 >> >> http://br.linkedin.com/in/diborsoi >> http://diborsoi.wordpress.com/ >> ================================================= >> _______________________________________________ >> pgbr-geral mailing list >> [email protected] >> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > > > Abraços > > -- > JotaComm > http://jotacomm.wordpress.com > > _______________________________________________ > 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
