Hi there and thanks for the quick answer: On Mon, 3 Jun 2013 10:18:19 -0400 Greg Sabino Mullane <g...@endpoint.com> wrote:
> On Mon, Jun 03, 2013 at 12:35:25PM +0200, Olaf Rühenbeck wrote: > ... > > Well as I said, I cant figure out why bucardo would get a permission > > denied as I granted all on database baculadir to bucardo and can do > > everything "by hand" :x > > Make sure the bucardo account exists on all databases involved, and > that it is a superuser. Then make sure that's the account name used > inside the bucardo.db table: > > bucardo list dbs > root@maguro:~# bucardo list dbs Database: m_baculadir Status: active Conn: psql -p 5432 -U baculadir -d baculadir -h localhost Database: v_baculadir Status: active Conn: psql -p 5432 -U maguro -d baculadir -h XXX Postgres on XXX: http://pastebin.com/CbE9ye7z (So the user is a superuser and bucardo actually connected as this one) http://pastebin.com/VxmqApwF (same here) sadly same error: root@maguro:/home/rueheo4v# bucardo add sync m_baculadir_v herd=maguro dbs=maguro onetimecopy=2 WARNING: Issuing rollback() due to DESTROY without explicit disconnect() of DBD::Pg::db handle dbname=baculadir;host=localhost;port=5432 at line 273. CONTEXT: PL/Perl function "validate_sync" SQL statement "SELECT validate_sync('m_baculadir_v')" PL/Perl function "validate_sync" Failed to add sync: DBD::Pg::st execute failed: ERROR: DBD::Pg::db do failed: ERROR: permission denied for database baculadir at line 274. at line 30. CONTEXT: PL/Perl function "validate_sync" at /usr/bin/bucardo line 4113. maguro and bucardo respectively have been granted all on bucardo and baculadir databases on both hosts. Greetings, Olaf Rühenbeck
signature.asc
Description: PGP signature
_______________________________________________ Bucardo-general mailing list Bucardo-general@bucardo.org https://mail.endcrypt.com/mailman/listinfo/bucardo-general