[Bucardo-general] Possible bug?

Olaf Rühenbeck some.individuum at gmail.com
Tue Jun 4 10:01:21 UTC 2013

Hi there and thanks for the quick answer:

On Mon, 3 Jun 2013 10:18:19 -0400
Greg Sabino Mullane <greg at 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 at 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:


(So the user is a superuser and bucardo actually connected as this one)


(same here)

sadly same error:

root at 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

maguro and bucardo respectively have been granted all on bucardo and
baculadir databases on both hosts.


Olaf Rühenbeck
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 836 bytes
Desc: not available
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20130604/3ec971e7/attachment.sig>

More information about the Bucardo-general mailing list