Re: [Bacula-users] PostgreSQL - how to exclude bacula database?

2012-12-28 Thread lst_hoe02
Zitat von Dan Langille d...@langille.org: On Dec 27, 2012, at 8:40 PM, Jérôme Blion wrote: You can use pg_dump to backup databases separately. (as far as I know, the pg_dump creates consistent backup by defaults, whereas mysqldump does not by default) Say what? mysqldump doesn't produce

Re: [Bacula-users] PostgreSQL - how to exclude bacula database?

2012-12-28 Thread Jérôme Blion
Le 2012-12-28 11:19, lst_ho...@kwsoft.de a écrit : Zitat von Dan Langille d...@langille.org: On Dec 27, 2012, at 8:40 PM, Jérôme Blion wrote: You can use pg_dump to backup databases separately. (as far as I know, the pg_dump creates consistent backup by defaults, whereas mysqldump does

Re: [Bacula-users] PostgreSQL - how to exclude bacula database?

2012-12-28 Thread Wolfgang Denk
Dear Dan, In message a216f657-338f-4bdf-bdbd-814508cca...@langille.org you wrote: However, none of the PostgreSQL based examples I have seen so far contain similar (at least similar obvious) exclude rules. What am I missing here? It depends on where your PostgreSQL database is. On

Re: [Bacula-users] PostgreSQL - how to exclude bacula database?

2012-12-28 Thread Dan Langille
On Dec 28, 2012, at 6:12 AM, Jérôme Blion wrote: Le 2012-12-28 11:19, lst_ho...@kwsoft.de a écrit : Zitat von Dan Langille d...@langille.org: On Dec 27, 2012, at 8:40 PM, Jérôme Blion wrote: You can use pg_dump to backup databases separately. (as far as I know, the pg_dump creates

[Bacula-users] PostgreSQL - how to exclude bacula database?

2012-12-27 Thread Wolfgang Denk
Hi again, here is another PostgreSQL related question: when backing up the database server, I would like to exclude the bacula database (which gets backed up separately anyway). With MySQL, I could do this easily with somthing like this: Options { RegexFile =

Re: [Bacula-users] PostgreSQL - how to exclude bacula database?

2012-12-27 Thread Dan Langille
On Dec 27, 2012, at 4:21 PM, Wolfgang Denk wrote: Hi again, here is another PostgreSQL related question: when backing up the database server, I would like to exclude the bacula database (which gets backed up separately anyway). With MySQL, I could do this easily with somthing like

Re: [Bacula-users] PostgreSQL - how to exclude bacula database?

2012-12-27 Thread Jérôme Blion
Hello, Le 27/12/2012 22:21, Wolfgang Denk a écrit : Hi again, here is another PostgreSQL related question: when backing up the database server, I would like to exclude the bacula database (which gets backed up separately anyway). With MySQL, I could do this easily with somthing like this:

Re: [Bacula-users] PostgreSQL - how to exclude bacula database?

2012-12-27 Thread Dan Langille
On Dec 27, 2012, at 8:40 PM, Jérôme Blion wrote: You can use pg_dump to backup databases separately. (as far as I know, the pg_dump creates consistent backup by defaults, whereas mysqldump does not by default) Say what? mysqldump doesn't produce a valid backup? -- Dan Langille -