Placido Loko wrote: > > > Primeiramente gostaria de agradecer pela ajuda que me foi dada com relação > a > migração de um banco do SQL SERVER para Postgres. > Bom minha duvida é: > BACKUP....Gostaria de saber a diferença entre COMPRESS, TAR e PLAIN....Ao > clicar em backup aparece uma caixa com estas opções...bom gostaria de umas > dicas de como executar um backup..como posso fazer um agendamento de > backup... > Da documentação em: http://www.postgresql.org/docs/8.2/interactive/app-pgdump.html "-F format --format=format Selects the format of the output. format can be one of the following: p plain Output a plain-text SQL script file (the default). c custom Output a custom archive suitable for input into pg_restore. This is the most flexible format in that it allows reordering of loading data as well as object definitions. This format is also compressed by default. t tar Output a tar archive suitable for input into pg_restore. Using this archive format allows reordering and/or exclusion of database objects at the time the database is restored. It is also possible to limit which data is reloaded at restore time." Se preferir rm português: http://pgdocptbr.sourceforge.net/pg80/app-pgdump.html []s Osvaldo -- View this message in context: http://www.nabble.com/Duvida-Backup-tf3875005.html#a10980829 Sent from the PostgreSQL - Brasil mailing list archive at Nabble.com.
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
