If you're not sure what's going on on a node, look at its logs.
The background worker API and PostgreSQL's lack of autonomous transactions
makes it quite challenging for BDR workers to capture logs and expose them
to users at the SQL level. So always, if in doubt, examine the log files.
On 11/27/15 5:45 PM, DrakoRod wrote:
Hi everybody
I've the next architecture with pgpool (streaming replication mode):
4 nodes
1 Master Node
2 Standbys Node
1 pgpool Node
I've disabled the load balancing, because some clients report me problems
with the load balancer, they told me the load ba
On 11/26/15 1:12 AM, Francisco Olarte wrote:
Anyway, I think people should be told to respect types, and people
should be teach that strings are sequences of characters, that to do
what people think is 'hex encoding' ( two digits per*byte*, no
delimiter ), you need to first transform the string t
On 12/4/15 4:15 AM, Peter J. Holzer wrote:
On 2015-12-03 10:02:18 -0500, Tom Lane wrote:
>"Peter J. Holzer" writes:
> >Can those signals be safely ignored? Just blocking them (so that they
> >are delivered after the UDF finishes) might be safer. But even that may
> >be a problem: If the UDF th
On 12/4/15 11:34 AM, Gerdan Rezende dos Santos wrote:
Someone has some way of identifying all invalid blocks of a table
postgresql?
Plpgsql a function, a tool, somehow.
I found one solution on
http://www.postgresql.org/message-id/1184245756.24101.178.ca...@coppola.muc.ecircle.de,
but I can not
On 12/06/2015 01:59 PM, Blake McBride wrote:
On Sun, Dec 6, 2015 at 3:47 PM, Rob Sargent mailto:robjsarg...@gmail.com>> wrote:
> On Dec 6, 2015, at 2:30 PM, Blake McBride mailto:blake1...@gmail.com>> wrote:
>
> Greetings,
>
> I need an XML specification for my exiting s
On Sun, Dec 6, 2015 at 3:47 PM, Rob Sargent wrote:
>
> > On Dec 6, 2015, at 2:30 PM, Blake McBride wrote:
> >
> > Greetings,
> >
> > I need an XML specification for my exiting schema - an XSD file.
> Reading the docs I see schema_to_xml but I do not understand:
> >
> > A. Will that produce the
> On Dec 6, 2015, at 2:30 PM, Blake McBride wrote:
>
> Greetings,
>
> I need an XML specification for my exiting schema - an XSD file. Reading the
> docs I see schema_to_xml but I do not understand:
>
> A. Will that produce the XSD file I seek?
>
> B. I do not understand the documentation
Greetings,
I need an XML specification for my exiting schema - an XSD file. Reading
the docs I see schema_to_xml but I do not understand:
A. Will that produce the XSD file I seek?
B. I do not understand the documentation. Can I do this through psql? I
need an exact example if possible.
Tha
Michael Paquier wrote:
> On Sat, Dec 5, 2015 at 2:35 AM, Andreas Kretschmer
> wrote:
> > imagine a streaming replication using physical replication slots. And
> > sometime a
> > fail over. All okay. I take a basebackup and rebuild the old master as
> > slave.
> >
> > Is there a risk that the n
On Sat, Dec 5, 2015 at 2:35 AM, Andreas Kretschmer
wrote:
> imagine a streaming replication using physical replication slots. And
> sometime a
> fail over. All okay. I take a basebackup and rebuild the old master as slave.
>
> Is there a risk that the new slave contains active replication slots b
Did you try this :
https://github.com/2ndQuadrant/bdr/issues/127 :
<<<
BEGIN;
SET LOCAL bdr.skip_ddl_locking = on;
SET LOCAL bdr.permit_unsafe_ddl_commands = on;
SET LOCAL bdr.skip_ddl_replication = on;
SECURITY LABEL FOR bdr ON DATABASE mydb IS NULL;
DELETE FROM bdr.bdr_connections;
DELETE FROM
12 matches
Mail list logo
