I would check the source of the catalog backup script and see what options it
uses.
--
Jeff MacDonald
j...@terida.com
902 880 7375
On 2012-03-29, at 10:15 AM, Jose Ildefonso Camargo Tolosa wrote:
> 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
------------------------------------------------------------------------------
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