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 - http:

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

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 lik

[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 = "^/var/lib/mysql/mysql-bi

Re: [Bacula-users] PostgreSQL - Could not open Catalog "MyCatalog", database "bacula"

2012-12-27 Thread Wolfgang Denk
Dear Dan, In message <74ff5871-d1bc-4ea8-ac5e-f257e1244...@langille.org> you wrote: > > With what you have now, you're connecting to localhost. PostgreSQL > is most likely configured to listen only on localhost. Yes, this was the problem. > listen_addresses = 'localhost, 10.1.1.1' Indeed - fi

Re: [Bacula-users] PostgreSQL - Could not open Catalog "MyCatalog", database "bacula"

2012-12-27 Thread Dan Langille
On Dec 27, 2012, at 2:51 PM, Wolfgang Denk wrote: > Dear Dan Langille, > > In message <5a6c0b9b-5b81-4c58-90f5-ca93ba43a...@langille.org> you wrote: >> >> As the PostgreSQL back-end author, I applaud your decision. ;) > > I'm aware that I should have dont that a long time ago, but you know >

Re: [Bacula-users] PostgreSQL - Could not open Catalog "MyCatalog", database "bacula"

2012-12-27 Thread Wolfgang Denk
Dear Dan Langille, In message <5a6c0b9b-5b81-4c58-90f5-ca93ba43a...@langille.org> you wrote: > > As the PostgreSQL back-end author, I applaud your decision. ;) I'm aware that I should have dont that a long time ago, but you know how it is when you have a system that is basically running just fi

Re: [Bacula-users] PostgreSQL - Could not open Catalog "MyCatalog", database "bacula"

2012-12-27 Thread Dan Langille
On Dec 27, 2012, at 10:12 AM, Wolfgang Denk wrote: > Hi, > > I would like to apologize in advance for re-asking a FAQ: I am well > aware that here have been a ton of similar reports before, and I did > read these and try out suggested solutions, with no avail. > > After running bacula for a lo

Re: [Bacula-users] PostgreSQL - Could not open Catalog "MyCatalog", database "bacula"

2012-12-27 Thread Wolfgang Denk
Dear Simone Caronni, In message you wrote: > > Inside the README.Fedora there is also a brief how to on how to > quickly setup a PostgreSQL based Bacula Director. Thanks again. I followed exactly the steps as described in the README (which are more or less identical http://www.bacula.org/manu

Re: [Bacula-users] PostgreSQL - Could not open Catalog "MyCatalog", database "bacula"

2012-12-27 Thread Wolfgang Denk
Dear Simone Caronni, In message you wrote: > > What's missing is only your choice in the alternatives system for the > database backend: No, that's not the reason. These are set up correctly, at least I think so: # alternatives --display libbaccats.so libbaccats.so - status is manual. link

Re: [Bacula-users] PostgreSQL - Could not open Catalog "MyCatalog", database "bacula"

2012-12-27 Thread Simone Caronni
Oops, sorry, I hit enter while still modifying the mail. Inside the README.Fedora there is also a brief how to on how to quickly setup a PostgreSQL based Bacula Director. Regards, --Simone On 27 December 2012 16:33, Simone Caronni wrote: > Hello, > > that's related to Fedora packaging and shou

Re: [Bacula-users] PostgreSQL - Could not open Catalog "MyCatalog", database "bacula"

2012-12-27 Thread Simone Caronni
Hello, that's related to Fedora packaging and should not be addressed to this list. Please take a look at your installed file: /usr/share/doc/bacula-common-5.2.12/README.Fedora What's missing is only your choice in the alternatives system for the database backend: # alternatives --config libb

[Bacula-users] PostgreSQL - Could not open Catalog "MyCatalog", database "bacula"

2012-12-27 Thread Wolfgang Denk
Hi, I would like to apologize in advance for re-asking a FAQ: I am well aware that here have been a ton of similar reports before, and I did read these and try out suggested solutions, with no avail. After running bacula for a long, long time with MySQL, I decided to try it out with PostgreSQL i

Re: [Bacula-users] Compiling Bacula with readline support on CentOS6

2012-12-27 Thread Uwe Schuerkamp
On Mon, Dec 24, 2012 at 06:52:52PM +0100, Tilman Schmidt wrote: > Am 24.12.2012 10:53, schrieb Uwe Schuerkamp: > > Now that I have readline support enabled, how does > > tab completion work in bconsole? > > It doesn't. AFAIK support for it hasn't been implemented. > Ah ok, it may be available in

Re: [Bacula-users] SQL query to find media without jobs or with zero file bytes?

2012-12-27 Thread Uwe Schuerkamp
On Mon, Dec 24, 2012 at 05:48:35PM -0500, K. M. Peterson wrote: > Hi Mark, > > I have two jobs that I run periodically. > > query_errvols.sql generates a list of volumes that were written by failed > jobs. If a job failed, or was cancelled, it gets returned by this program. > query_orphan_volume

Re: [Bacula-users] lots of copy jobs fail suddenly (5.2.12)

2012-12-27 Thread Uwe Schuerkamp
On Mon, Dec 24, 2012 at 06:45:51PM +0100, Tilman Schmidt wrote: > Am 24.12.2012 10:51, schrieb Uwe Schuerkamp: > > As for my previous question on how to run a job using bconsole, > > passing pool, storage and other params it works like this: > > (echo run catalog=MyCatalog job=copy-single > > stor