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
|