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 <[email protected]> > 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 <[email protected]> > > Olá, Sérgio >> >> 2009/6/23 sergio nogueira <[email protected]> >> >>> 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 >>> [email protected] >>> 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 >> [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 > > []s -- JotaComm http://jotacomm.wordpress.com http://www.dextra.com.br/postgres
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
