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
