Re: [Bacula-users] PostgreSQL - pg_dump
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 -- 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
Re: [Bacula-users] PostgreSQL - pg_dump
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 : >> 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 AnalystP O Box 32026 >> University LibraryBoone, 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
Re: [Bacula-users] PostgreSQL - pg_dump
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 : > 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
[Bacula-users] PostgreSQL - pg_dump
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 AnalystP O Box 32026 University LibraryBoone, 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