Bacula-users

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

2012-12-27 14:53:44
Subject: Re: [Bacula-users] PostgreSQL - Could not open Catalog "MyCatalog", database "bacula"
From: Wolfgang Denk <wd AT denx DOT de>
To: Dan Langille <dan AT langille DOT org>
Date: Thu, 27 Dec 2012 20:51:19 +0100
Dear Dan Langille,

In message <5A6C0B9B-5B81-4C58-90F5-CA93BA43A02C AT langille DOT 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 fine,
albeit eventually not as performant as possible...

> Please show us your Catalog resource from bacula-dir.conf.
> 
> Mine is:
>
> Catalog {
>   Name = MyCatalog
>   dbname = bacula; dbaddress = localhost; user = bacula; password = ""
> }

I have this:

Catalog {
  Name = MyCatalog
  dbdriver = "dbi:postgresql"; dbaddress = HHHH.denx.de; dbport = 5432
  dbname = "bacula"; dbuser = "bacula"; dbpassword = "XXXXXX"
}

> Is bacula-dir running on the same host as PostgreSQL?

Yes, both are running on host "HHHH"...


Ooops...  I was just about to write that I had also tested this with
"dbaddress = localhost" before, and it didn't work either; but that
was probably before some other changes... Fortunately I was wise
enough to retest it before sending this, and indeed this fixes the
problem.


OK, assuming I would like to have the flexibility of running the DB
on another host it seems I need to re-check pg_hba.conf ?

Best regards,

Wolfgang Denk

-- 
DENX Software Engineering GmbH,     MD: Wolfgang Denk & Detlev Zundel
HRB 165235 Munich, Office: Kirchenstr.5, D-82194 Groebenzell, Germany
Phone: (+49)-8142-66989-10 Fax: (+49)-8142-66989-80 Email: wd AT denx DOT de
"Just Say No."   - Nancy Reagan
"No."            - Ronald Reagan

------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122712
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users