Column 2 cannot have an empty string if it is truly a bigint - can you
share the DDL (i.e. CREATE TABLE statement) for that table? Bucardo should
have no problem with bigint columns. Could be some sort of edge case but
seeing the exact table could help us narrow things down.
Cheers,
Greg
Just saw this again: I don't think we have anything that can quite handle
this case. Since you asked Bucardo to re-do the sync, but the PKs have
changed, it is going to delete all the affected PKs and then re-add them.
But it cannot re-add the same ones, as the custom code has modified them.
major version is to remove the plperl dependency.
I
had a branch and got about 75% of the way there at one point, but it's probably
too stale to worry about now. I seem to recall it wasn't too hard, as most of
the logic can be handled directly by the 'bucardo' script.
- --
Greg Sab
n
## Assign the version variables
-my ($maj,$min,$rev) = ($1,$2,$3);
-## We need to be able to handle things such as 9.2devel
-$rev =~ s/^\.//;
-$rev =~ s/(\d+)\.\d+/$1/;
+my ($maj,$min) = ($1,$2);
$QUIET or print "Postgres version is: $maj.$min\n";
nt to fix it, but it
did help me identify the problem. A fix should be arriving soon.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8
signature.asc
Description: PGP signature
__
t look for this line:
$QUIET or print "Postgres version is: $maj.$min\n";
and change it to:
$QUIET or print "Postgres version is: $maj.$min ($res)\n";
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8
sign
the pkey fields get populated.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8
signature.asc
Description: PGP signature
___
Bucardo-general mailing list
Bucardo-genera
On Tue, Nov 14, 2017 at 03:08:37PM +, Rohit Suraj Kapoor wrote:
> Thanks Greg, I was able to resolve this issue with altering tcp keepalive
> parameters.
Great, good to know. Can you share what you adjusted them to for the benefits
of the archives?
--
Greg Sabino Mullane g...@endpoi
o's
statement_chunk_size to 1000), more memory on the server, or perhaps
decreasing work_mem or other schemes to reduce the overall memory usage.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8
signature.asc
Description:
txntime field now for any reason.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8
signature.asc
Description: PGP signature
___
Bucardo-general mailing list
Bucardo-general@buca
y to upgrade existing installations - the timestamp and
timestamp+txid
can coexist peacefully
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8
signature.asc
Description: PGP signature
__
ent, which basically adds some precision to the
timestamp, e.g. now() || txid_current()::text
This means we have to store it as a text, and not a timestamp field,
but it still sorts, and we don't do any other time-based queries on
the field, other than the vac process, but that can be chang
On Wed, Jul 19, 2017 at 05:49:00AM +, Om Prakash Jaiswal wrote:
> Thanks Sir.Now I installed Bucardo-5.4.1 successfully with PostgreSQL 9.4.8
> 64bit RHEL 7 OS.
> is this version will also work with PostgreSQL 9.6.xxx ?
Yes, that will be fine.
--
Greg Sabino Mullane g...@endpoin
uperuser" role enabled.
From the psql prompt, \du will show you a list of all users and
their roles.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8
signature.asc
Description:
e to get
everything
setup, then change the bucardo.db table to point to the real one when it is up
and running.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8
signature.asc
Description: PGP signature
o bucardo [local] COMMIT waiting for 0/F04F938
That's unusual as well. Are you seeing that anywhere else? You could
also try setting a timeout to help with the debug:
$ export PGCONNECT_TIMEOUT=10
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944
ally supported is bucardo_latest - the other
ones used in Bucardo 4 do not make sense any more, as we can have any number
of sources or targets.
Thanks for your patience. Questions and complaints on the mailing list are
a great way of gauging what parts of Bucardo need to be worked on next! :)
--
Gr
is the place you installed bucardo. Also
try a command line invocation to view the config contents:
bucardo show all
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8
signature.asc
Descriptio
On Fri, Jun 09, 2017 at 02:42:50PM +0800, 张远 wrote:
> what is "a standalone session" , connect db with a different ip ?
It means connect to the database yourself (for example, with the "psql"
program) and run the SQL manually.
--
Greg Sabino Mullane g...@endpoint.co
r each database to e replicated.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8
signature.asc
Description: PGP signature
___
Bucardo-general mailing list
Bucardo-general@bucar
e 308.
> """
Make sure the .pgpass file has an entry for the bucardo user, connecting
to the database shown in the error. The line should look like this:
localhost:5432:bucardo:bucardo:yourpassword
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF
As long as the
function
already exists, it can be created at any time.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8
signature.asc
Description: PGP signature
___
Bucardo-
on the slave
server?
Generally it is better to run it only on the master server. Either way, you
can set the piddir to something else by adding this to your ~/.bucardorc file:
piddir=/tmp
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944 45B
syncs specified for it.
A brute force solution is to truncate this table then run:
bucardo validate all
Which in theory will correctly populate the table.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8
signatu
esume it has an
identical schema. If not, you will need to add the trigger so that the
inherited tables are populated. It should have the ame trigger and supporting
function as the source database: the only change will be to set it to 'always'
fire.
--
Greg Sabino Mullane g...@endpoint.com
that does the
vacuuming for you, so make sure that it is still enabled by doing:
bucardo show bucardo_vac
It should show: bucardo_vac = 1
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8
signature.asc
Description: PGP
e to disable. It was an optimization that doesn't work as
well as
hoped. We will probably disable it by default in the next version and see if
it can be improved.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8
signature.asc
, the quick_delta function may be slowing you down.
Try adding this line to your .bucardorc file:
quick_delta_check=0
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8
signature.asc
Descripti
user running bucardo:
echo "piddir=/tmp" >> ~/.bucardorc
Or globally on the box:
echo "piddir=/tmp" >> /etc/bucardorc
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC
orking as it should, the safest bet would be to stop
Bucardo, make the changes, and restart Bucardo.
I'm still not sure I understand why this is happening - any chance
you can enable logging on those servers and see the COPY
commands in question?
--
Greg Sabino Mullane g...@endpoint.com
End
onstraint?
Bucardo sets session_replication_role, and thus ignores all triggers
and rules (foreign keys are trigger based)
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8
signature.asc
De
which is still trying to run
bucardo_delta_check(). Kill all your Bucardo proceses, make sure
nothing is still running by checking pg_stat_activity, then
add this to your ~/.bucardorc file:
quick_delta_check=0
Then restart Bucardo and see what happens.
--
Greg Sabino Mullane g...@endpoint.com
E
eal, and generally
requires
updating the internal Bucardo tables as well as a full restart.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8
signature.asc
Description: PGP signature
___
Bucardo, and check the log file (log.bucardo) for any
clues if things are still not working. It would also help to send us
the output of:
bucardo list all
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8
signature.as
h_events_y2015_m11 FOR
> EACH STATEMENT EXECUTE PROCEDURE bucardo_note_truncation('the_sync')
Was this the master or the replica? Maybe you can send me the output of:
bucardo show all
(sending private is fine if you don't want to send to the list)
--
Greg Sabino Mullane g...@endpoint.com
End Poin
an
area that is highly used: it is also possible Bucardo is missing, for example,
and ONLY somewhere in its calls, which would further gum things up, as
generally,
we do not want to involve child tables unless being explicit.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP
dauth: no password supplied at ./bucardo line 8691
Try creating an entry in the .pgpass file of the user you are running as.
Something like this:
echo "127.0.0.1:5432:*:bucardo:passwordhere" >> ~/.pgpass
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2
icated rows) from the bucardo logs.
Setting up a "modified" column in each table would be another solution.
It could be a timestamp, a serial, or even just a boolean that gets set to
true on any change, and your audit process then changes it back to false
when done checking that r
d as part of the validation step. Something
probably went wrong - try a manual kickoff like so:
bucardo validate all
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8
signature.asc
Description: PGP
update table mytable set strict_checking=0
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8
signature.asc
Description: PGP signature
___
Bucardo-general mailing list
Bucardo-g
es like this:
(13639) [Fri Jan 13 17:38:10.588 2017] #10014 KID (mongo) Rows copied to
(postgres) C.public.bucardo_test9: 1
If you can describe what you are looking for in more detail, there may be
some different options, but that's the first thing that springs to mind.
--
Greg Sabino Mullane
eral idea is
that it is a type of database target, so you would set one (or more of the DBs
as a "source",
and one or more as "fullcopy" like this:
bucardo add sync foobar herd=myherd dbs=A:source,B:fullcopy
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP
d solution for production.
Agreed, not ideal: you want to use 'md5' instead of 'peer' or 'trust'.
Then you can store the password in the ~postgres/.pgpass file.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8
signature.asc
D
this in your ~/.pgpass file:
localhost:5432:bucardo:bucardo:somepassword
Where "somepassword" is replaced with the actual password of course.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8
signature.asc
Description: PGP signature
_
ectly rather than letting the bucardo triggers do it by
touching the rows. A bit complicated, but you can get help on #bucardo
at irc.freenode.net or here.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8
signature.asc
D
t; no appreciable lag caused by the remote databases replicating data in.
Excellent, glad to hear this.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8
signature.asc
Descr
o connect as a non-superuser, since we would not need to do any
session_replication_role changes on the master. Maybe a change we should
make anyway... /wild_speculation
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8
sign
s, although that may
be a little more involved than running those two statemnts. :)
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8
signature.asc
Description: PGP signature
___
ething that won't go away, like /tmp:
echo piddir=/tmp >> /etc/bucardorc
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8
signature.asc
Description: PGP signature
___
Buc
On Thu, Oct 06, 2016 at 12:33:49PM -0700, Periko Support wrote:
> Bucardo user inside postgresql DB must be superuser?
> Or this step can be done with postgres main user?
> thanks.
Yes, bucardo user must be a superuser, but either can be
used to create the language.
--
Greg Sabino
On Thu, Sep 22, 2016 at 06:00:33PM +0300, Danil Rakevich wrote:
> I have tried this:
>
> RETURN 'Tables processed: ' || total::text;
Thanks, have pushed it to the repo. And thanks for reporting this!
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF6A
ext || total;
Could you see if that is a valid solution for your version of Postgres?
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8
signature.asc
Description: PGP signature
___
So the bucardo database was on A,
and was doing multi-master replication between A and B, and A suffered some
sort of failure but is back up now?
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8
signature.asc
D
are a contributor, please send me your github username. Another
announcement will go out once the change has been made.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8
signature.asc
Description: PGP signature
sync!
>
> I guess that's the first thing to fix…
Any progress on this?
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
Description: PGP signature
___
Bucardo-general mailing list
Bucardo-general
"Invalid log_level!\n";
+die "Invalid log_level! ($setting)\n";
}
$config{log_level_number} = $newvalue;
}
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
bucardo channel at irc.freenode.net.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
Description: PGP signature
___
Bucardo-general mailing list
Bucardo-general@bucardo.org
https://mail.endcrypt.com/mailman/l
rl? Are there any perl-related
files inside of /usr/pgsql-9.4/share/extension/ ?
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
Description: PGP signature
___
Bucardo-general mailing list
Bucardo-ge
ion of Bucardo (e.g. not HEAD) and a slightly older
MongoDB driver (I think that means <- 1.0.4). If you still see issues with
that version, please let us know. You are also welcome to test on -HEAD:
I think we are fairly close to getting it working.
--
Greg Sabino Mullane g...@endpoint.com
End
ange to make. Feel free
to make a github pull request if you want to get in the habit, or
I can just make it directly.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
Description: PGP signature
___
Buc
t; >
> The bigint serial is the neatest idea so far.
Anyone else want to comment? I've resigned myself to give up on the timestamp
in the name of simplicity and correctness, but am open to alternative
suggestions.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP K
into the mix too. Would certainly
win the space and efficiency awards.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
Description: PGP signature
___
Bucardo-general mailing list
Bucardo-g
for each slave?
That is correct. Solving that problem is a highly wanted TODO item,
but for now if you want things to keep chugging along when one goes
down, have two syncs.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
Description
ry from going
any
further, so you should examine pg_stat_activity (look for waiting='t') and
pg_locks.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
Description: PGP signature
___
Bucardo-gene
nical way to kick a sync is through the bucardo script. Anyone
can run it, as long as things are configured correctly. You can also
trigger it by sending a special database NOTIFY command.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
De
rmance looks a lot better.:
Excellent, thanks for that! I will look it over and try it out soon.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
Description: PGP signature
___
Bucardo-general mailing li
e delta changes?
No, it is all or nothing, to keep the database consistent. Is there some
problem that doing partial records would solve for you? Maybe there is
a different solution.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
Description
ay help in your circumstance. Either way,
it would be good to see where the pain points are: maybe you could
email me some log output?
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
Description: PGP signature
___
in @INC
This means you need to install the Perl module DBI, one of the prerequisites
for Bucardo. You should have received a warning aout that when you did the
step: perl Makefile.PL
Your best bet would be to install DBI (and more specifically, DBD::Pg) using
Solaris' package management
alidate process.
>
> How can I use bucardo in this situation ?
The best solution is to give those tables a primary key (or a unique index).
It is far more efficient to only copy the rows that have changed than
to have to copy the entire table every time the sync runs.
--
Greg Sabino Mullane
been many
changes in that part of the code recently.
The 'clone' system, once finished, should obsolete both 'fullcopy' and
'onetimecopy'.
Sorry for all the confusion.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
Description: Digital
to handle them. You might want to use the offset-sequence
trick [1] as well to help prevent conflicts and for better auditing.
[1] Server A does 1,3,5,7,... Server B does 2,4,6,8, etc.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
Description
On Fri, Aug 21, 2015 at 06:29:29PM -0700, Florin Andrei wrote:
So, is there a non-interactive installation method that I could use?
Yes, the --batch argument is meant to facilitate this.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
objects at
/usr/local/share/perl/5.14.2/Bucardo.pm line 9466
Is that the exact error message? As far as I know, we have
never had a variable named $nor. What version is this?
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
Description: Digital
a
manual copy of the data, or touch all the rows on the source.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
Description: Digital signature
___
Bucardo-general mailing list
Bucardo-general
number of pending
delta rows on source databases.
[Greg Sabino Mullane]
- Fix incorrect usage of the 'dbconn' parameter in the bucardo.db table
[Greg Sabino Mullane, reported by Alexandre Busquets]
- Fix case where VAC sometimes skipped databases used in multiple syncs.
[Greg
the new release so quickly!
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
Description: Digital signature
___
Bucardo-general mailing list
Bucardo-general@bucardo.org
https://mail.endcrypt.com/mailman
this.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
Description: Digital signature
___
Bucardo-general mailing list
Bucardo-general@bucardo.org
https://mail.endcrypt.com/mailman/listinfo/bucardo-general
and the customcols?
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
Description: Digital signature
___
Bucardo-general mailing list
Bucardo-general@bucardo.org
https://mail.endcrypt.com/mailman/listinfo
, but there
are cases where it will stop retrying, depending on the nature of the
error. As far as detecting bad sync, you can use bucardo status syncname
to see if the last run completed, and if it was good or bad.
We will be happy to give more answers if you have more specific questions.
--
Greg Sabino
(round
$t-{delete_round} of $t-{delete_rounds}), LOG_DEBUG);
$did_something++;
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
Description: Digital signature
___
Bucardo-general mailing
.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
Description: Digital signature
___
Bucardo-general mailing list
Bucardo-general@bucardo.org
https://mail.endcrypt.com/mailman/listinfo/bucardo-general
.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
Description: Digital signature
___
Bucardo-general mailing list
Bucardo-general@bucardo.org
https://mail.endcrypt.com/mailman/listinfo/bucardo-general
to, but since a manual kick
works, that's a mystery, as the manual kick should be issuing the
exact same NOTIFY the trigger does. Double check the triggers
and functions on one of those tables and make sure it is issuing
the correct NOTIFY.
--
Greg Sabino Mullane g...@endpoint.com
End Point
Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
Description: Digital signature
___
Bucardo-general mailing list
Bucardo-general@bucardo.org
https://mail.endcrypt.com/mailman/listinfo/bucardo-general
, as Bucardo
needs active, serializable, concurrent transactions most of the time.
You may get more benefit by having the KID and CTL processes exit
when done, by setting kidsalive=0 and stayalive=0 for each sync.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
using /tmp, so you
are probably using Debian (or Ubuntu). The easiest solution may be
to simply adjust your postgresql.conf and add /tmp to your
unix_socket_directories. That way programs are happy no matter which
socket directory they expect.
--
Greg Sabino Mullane g...@endpoint.com
End Point
commands you are trying,
but if you want to add a table from a specific database, you can
add the database to the end of the add table command like so:
bucardo add table foobar db=DB2
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
Description
db1_remote:target
bucardo add sync db1_sync relgroup=group1 dbs=db1_dbgroup autokick=0
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
Description: Digital signature
___
Bucardo-general mailing list
Bucardo-general
to
reload the sync:
$ bucardo reload sync foobar
You may see some errors if a sync starts up after you ALTER and before the
sync reloads, but as long as the changes do not involve the primary keys,
it should work.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key
On Mon, May 18, 2015 at 10:32:49AM -0300, Rangel Nunes wrote:
Error attached
Thanks for the report, I will see if I can duplicate (and hopefully fix)
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
Description: Digital signature
the default trigger behavior (e.g. 'origin',
not 'always'), work for you? There are some other workarounds that
should be tried before resorting to setting triggers as 'always'.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
Description: Digital
be getting cleaned up automatically. The latest version
has no specific vcacuum related fixes. Perhaps looks at your
bucardo_delta_names tables and make sure you don't have any duplicated
or stale entries.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-{server_side_prepares};
$ssp = 1 if ! defined $ssp;
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
Description: Digital signature
___
Bucardo-general mailing list
Bucardo-general@bucardo.org
https
of the bucardo.db table, and make sure it says sslmode=require,
not conn=sslmode=require
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
Description: Digital signature
___
Bucardo-general mailing list
Bucardo
in 3a6cdce7e60de30a3da6f2dc8698ee2124201c9b
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
Description: Digital signature
___
Bucardo-general mailing list
Bucardo-general@bucardo.org
https://mail.endcrypt.com/mailman/listinfo
On Wed, Mar 04, 2015 at 10:11:48AM +0100, Laurent GARCES wrote:
Wiki updated: https://bucardo.org/wiki/Bucardo/remove_table
Hope that will be ok.
Looks great, thanks for all the wiki changes!
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
is going on. Try bumping the log_level up (perhaps to DEBUG) and
see if that gives you a better message.
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
Description: Digital signature
___
Bucardo
:
bucardo remove table public.foobar db=bazzo
Documentation patches welcome :)
--
Greg Sabino Mullane g...@endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
signature.asc
Description: Digital signature
___
Bucardo-general mailing list
Bucardo-general
I will reply to the other questions when I have some time, but this
one is easy:
2) Is there a way to get rid of those errors? I guess they are
related to the fact the sync are not refreshed.
Upgrading to the latest bucardo (5.3.1) should remove those errors
--
Greg Sabino Mullane g
1 - 100 of 257 matches
Mail list logo