Re: [Bacula-users] PostgreSQL - pg_dump

2012-03-29 Thread Jose Ildefonso Camargo Tolosa
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:

Re: [Bacula-users] PostgreSQL - pg_dump

2012-03-29 Thread Jeff MacDonald
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).

Re: [Bacula-users] PostgreSQL - pg_dump

2012-03-29 Thread Andrea Conti
On 28/03/12 18.32, Thomas Bennett wrote: 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? You don't need them for Bacula. andrea

[Bacula-users] PostgreSQL - pg_dump

2012-03-28 Thread Thomas Bennett
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