Am 24.11.2015 um 15:17 schrieb [email protected]:
>> In 
>> http://doc.bareos.org/master/html/bareos-manual-main-reference.html#CatalogDatabase
>>
>>
>> 
is a description about how to check your database. In essence:
>> 
>> # su to bareos to have the same database permissions as the
>> bareos-director
>> 
>> root@linux:~# su − bareos −s /bin/sh
>> 
>> # connect to the database bareos@linux:~# psql
>> 
>> # manually check the database, e.g. bareos=> select * from
>> Version;


> Should I remove postgres from the bareos group then? Happy to follow
> standard practice. Wasn't aware the permission denied would be ok to
> ignore so I just went through solving one step at a time. :)

no, it is fine to have postgres in the bareos group.


> [root@vm-backups1]# su bareos sh-4.1$ psql psql (8.4.20) Type "help"
> for help.
> 
> bareos=> select * from version; versionid ----------- 2004 (1 row)

Again this looks correct.

I'm wondering about:
> Running the bareos-dir -t just results in...
> 
> 23-Nov 16:47 bareos-dir JobId 0: Fatal error: Could not open Catalog 
> "MyCatalog", database "bareos".
> 23-Nov 16:47 bareos-dir JobId 0: Fatal error: postgresql.c:246 Unable to 
> connect to PostgreSQL server. Database=bareos User=bareos
> Possible causes: SQL server not running; password incorrect; max_connections 
> exceeded.
> 23-Nov 16:47 bareos-dir ERROR TERMINATION

Maybe you tried this as root?

Please try

su − bareos −s /bin/sh
bareos-dir -t

If this succeeds, also check
psql baroes
\dt
and
\dp


After this, try to run bareos-dir in debug mode:

su - bareos
bareos-dir -f -d 100

Maybe we see there, what the problem is.

Jörg

-- 
 Jörg Steffens                   [email protected]
 Bareos GmbH & Co. KG            Phone: +49 221 630693-91
 http://www.bareos.com           Fax:   +49 221 630693-10

 Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRA 29646
 Komplementär: Bareos Verwaltungs-GmbH
 Geschäftsführer:
 S. Dühr, M. Außendorf, Jörg Steffens, P. Storz, M. v. Wieringen

-- 
You received this message because you are subscribed to the Google Groups 
"bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to