Re: [GENERAL] question about replication slots

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

Re: [GENERAL] question about replication slots

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

Re: [GENERAL] bdr manual cleanup required

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

Re: [GENERAL] Table with invalid page blocks

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

Re: [GENERAL] FATAL: unable to read data from DB node 0

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

Re: [GENERAL] BDR: ALTER statement hanging

​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.

Re: [GENERAL] plperlu stored procedure seems to freeze for a minute

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

Re: [GENERAL] Convert from hex to string

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

Re: [GENERAL] Generating an XSD file from an existing database

> 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

Re: [GENERAL] Generating an XSD file from an existing database

On 12/06/2015 01:59 PM, Blake McBride wrote: On Sun, Dec 6, 2015 at 3:47 PM, Rob Sargent > wrote: > On Dec 6, 2015, at 2:30 PM, Blake McBride > wrote: > > Greetings, >

[GENERAL] Generating an XSD file from an existing database

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.

Re: [GENERAL] Generating an XSD file from an existing database

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