[Bucardo-general] Patch: fix quoted table/index names

Greg Sabino Mullane greg at endpoint.com
Wed Nov 23 15:50:47 UTC 2011

On Sat, Nov 12, 2011 at 08:21:30AM +0100, Sean M. Pappalardo wrote:
> What was happening is that the field was being wrapped twice: once
> by the qq{} and once by the quotes around the variable, causing an
> error when Perl tried to parse ""foo_bar_Table name_txn""

Okay, thanks, I'll look into that closer.

> Speaking of passwords, that's another problem: I have to specify
> -dbpass=<bucardo password> on every invocation of bucardo_ctl or I
> get an error:

Looks like a bug: will add to the TODO list

> But which user are we talking about here? The Linux user running the
> bucardo_ctl script, the Bucardo DB user, the user for the source
> DB/herd, or the one for the target DB? (After messing around a bit,
> I got it to proceed having the source and target DB connecting users
> set to superuser.)

Any Postgres user specified in the bucardo.db table should be a superuser. 
It's genreally easiest to create a superuser named 'bucardo' on every 
database involved and use that everywhere.

> It tries again but fails. The source DB log just shows:
> EST LOG:  could not receive data from client: Connection reset by peer
> EST LOG:  unexpected EOF on client connection
> And the target (where the changes actually are) only shows:
> CET LOG:  unexpected EOF on client connection
> CET LOG:  unexpected EOF on client connection
> FWIW, I'm using a local connection to the target and an ssl
> connection to the source.

Hmm that's not a lot to go on. One thing I would suggest is 
try it without the ssl to see if that is the problem or not.
Might also try bumping the log_level to DEBUG and see if 
the Bucardo logs give any more clues.

> Also, I thought I specified all of my syncs to be manual but when I
> start the Bucardo service, it tries to run some of them I didn't ask
> for, so I had to delete all but the one I want to run (swap,) since
> one of the others was a fullcopy.

FWIW, I dug through this one and think I found the issue (for B5). 
Commited and pushed something just now. I'll look into doing the 
same for B4.

Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20111123/941093b4/attachment.bin 

More information about the Bucardo-general mailing list