Hi! I don't think bacula uses oids, however, it doesn't hurt if you include them (I think).
What pgsql version are you using? (you said 8, but: 8.0, 8.1, 8.2, 8.3, 8.4). You could also use online backups, and do WAL archiving (maybe even continuous WAL archiving), here: http://www.postgresql.org/docs/8.0/static/backup-online.html (that's for 8.0), or here: http://www.postgresql.org/docs/8.4/static/continuous-archiving.html (for 8.4). Depending on your DB size, this method will save you some time for daily backups (because you can just "add" WAL files, like an incremental backup). Ildefonso. 2012/3/28 Thomas Bennett <bennet...@appstate.edu>: > I am having some hardware issues because of several HVAC outages. So if I > am doing a pg_dump of the bacula database on PostgreSQL, do I need to > include oids? > > From pg_dump man > > -o > --oids Dump object identifiers (OIDs) as part of the data for > every table. Use this option if your application references the OID > columns in some way (e.g., in a foreign key constraint). > Otherwise, this option should not be used. > > This is Bacula 3 PostgreSQL 8. > > > > Thanks, > > Thomas > > ==================================================== > Thomas McMillan Grant Bennett Appalachian State University > Operations & Systems Analyst P O Box 32026 > University Library Boone, North Carolina > 28608 > (828) 262 6587 > Library Systems http://www.library.appstate.edu > ==================================================== > > > ------------------------------------------------------------------------------ > This SF email is sponsosred by: > Try Windows Azure free for 90 days Click Here > http://p.sf.net/sfu/sfd2d-msazure > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > ------------------------------------------------------------------------------ This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
