[Bacula-users] grant privileges ERROR

[antonio.mannatzu <ama...@ar...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

hi,

here my steps:

- - -bash-4.1$ psql bacula
psql: FATAL:  database "bacula" does not exist
DETAIL:  The database subdirectory "base/16386" is missing.

so rename DB:
ALTER DATABASE bacula RENAME TO bacula_corrupt;

recreate db:
- -bash-4.1$ /etc/alternatives/create_bacula_database
Creating PostgreSQL database
CREATE DATABASE
ALTER DATABASE
Creation of bacula database succeeded.
Database encoding OK



recreate tables:
/etc/alternatives/make_bacula_tables
Making PostgreSQL tables
......
......
Creation of Bacula PostgreSQL tables succeeded.


- -bash-4.1$ /etc/alternatives/grant_bacula_privileges
Granting PostgreSQL privileges
psql:<stdin>:2: ERROR:  role "bacula" already exists


any hint?

thx a lot


- -- 
Antonio G. Mannatzu
- - -------------------------------------------------------------
A.R.C.E.S. University of Bologna,

Via Toffano 2, 40125 Bologna, Italy
TEL: +39 051 2095432	Fax:    +39 051 2095410

Viale Risorgimento 2, 40136, Bologna, Italy
Tel:	+39 051 2093774	Fax:    +39 051 2093779

web:	http://www.arces.unibo.it
feed:	http://syspad.arces.unibo.it/feed/
Email:	ant...@un...
	ama...@ar...
	sy...@ar...
- - --------------------------------------------------------------
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (Darwin)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQEcBAEBAgAGBQJTu6wtAAoJEMLhZpuxXg8flkIH/04KmaWsVUK2OwYlvTQIiwZT
PQXyA88L/05VdFG6AGtpw0HbVaFZBKSLu7r6HvT5bhT4go2BFeIxeG4Cst+vtjtO
YUxtaMemS0PSZZDfhIc9g42tpbbsOkkmavc55NQ2l58O2TK/f8uQoHqSvQ7znAvz
qNzY5es8JWw2TuCLs58j/mepo2v0GxLocBt+NJ1pb7ayLc12wtqDFVBoUyze+4Ge
Xg5qUSukW8BsmYW1Y4uxhOhM4y/rbfhbjCaR+W1/QgzjObgyJ+dACKpJf0h0xcGz
rTeSpJhxSkWvlJyv8apkLRb3Nj9i7j27eqgd5scb2psmMwnkpG7idlzGGguijVY=
=6UbB
-----END PGP SIGNATURE-----