Ok, JotaComm, Obigado pelo suporte. Att., Sergio
2009/6/23 JotaComm <jota.c...@gmail.com> > > Olá, > > Antes de um backup não é necessário o processo de vacuum. Se for isso não > precisa se preocupar. > > > 2009/6/23 sergio nogueira <sergiop...@gmail.com> > >> Boa tarde, JotaComm. >> Isto não acontece no Linux! >> No trabalho tenho esta base (uns 20Gb), na minha máquina local (Ruindows). >> Vou transferí-la para um Linux e resolvi fazer um vacuum antes do backup. O >> processo abortou e o servidor não voltou. O Tom Lane acha que pode ser o >> antivirus. Bom, eu insiro e excluo dados sem problemas. Mas consegui fazer o >> backup. A minha dúvida é se a mensagem pode significar alguma perda de >> dados. >> >> Att., >> Sergio >> >> 2009/6/23 JotaComm <jota.c...@gmail.com> >> >> Olá, Sérgio >>> >>> 2009/6/23 sergio nogueira <sergiop...@gmail.com> >>> >>>> Pessoal,. >>>> >>>> C:\>psql -U postgres monitor >>>> Welcome to psql 8.2.4, the PostgreSQL interactive terminal. >>>> >>>> Type: \copyright for distribution terms >>>> \h for help with SQL commands >>>> \? for help with psql commands >>>> \g or terminate with semicolon to execute query >>>> \q to quit >>>> >>>> Warning: Console code page (850) differs from Windows code page (1252) >>>> 8-bit characters may not work correctly. See psql reference >>>> page "Notes for Windows users" for details. >>>> >>>> monitor=# vacuum full >>>> monitor-# ; >>>> ERROR: could not truncate relation 18293/18295/19113 to 68908 blocks: >>>> Permission denied >>> >>> >>> O erro é devido a questões de permissões. >>> >>>> >>>> PANIC: cannot abort transaction 140578842, it was already committed >>>> server closed the connection unexpectedly >>>> This probably means the server terminated abnormally >>>> before or while processing the request. >>>> The connection to the server was lost. Attempting reset: Failed. >>>> !> >>> >>> >>> Neste ponto aqui o servidor está parado ou esta mensagem foi gerado e o >>> PostgreSQL voltou? Ou o serviço do PostgreSQL está parado? >>> >>> >>>> >>>> Alguma idéia do que aconteceu e das consequências? >>>> >>>> Att., >>>> Sergio >>>> >>>> _______________________________________________ >>>> pgbr-geral mailing list >>>> pgbr-geral@listas.postgresql.org.br >>>> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >>>> >>>> >>> >>> []s >>> -- >>> JotaComm >>> http://jotacomm.wordpress.com >>> http://www.dextra.com.br/postgres >>> >>> _______________________________________________ >>> pgbr-geral mailing list >>> pgbr-geral@listas.postgresql.org.br >>> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >>> >>> >> >> _______________________________________________ >> pgbr-geral mailing list >> pgbr-geral@listas.postgresql.org.br >> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >> >> > > []s > -- > JotaComm > http://jotacomm.wordpress.com > http://www.dextra.com.br/postgres > > _______________________________________________ > pgbr-geral mailing list > pgbr-geral@listas.postgresql.org.br > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > >
_______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral