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 <bennetttm AT appstate DOT 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 AT lists.sourceforge DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
