Re: [GENERAL] BDR replication slots

Hello, What do you see on each node's log after enablibg interfaces? Regards, Alvaro Aguayo Jefe de Operaciones Open Comb Systems E.I.R.L. Oficina: (+51-1) 3377813 | RPM: #034252 / (+51) 995540103  | RPC: (+51)  954183248 Website: www.ocs.pe Sent from my Sony Xperia™ smartphone Nikhil

[GENERAL] BDR replication slots

Hello, I have a 2 node BDR group and replication is happening properly. if i bring down one of the node's interface, after sometime the replication slots are becoming inactive (pg_replication_slots view). Then if i bring back interface slots are not turning active automatically and replication

Re: [GENERAL] Re: what's the exact command definition in read committed isolation level?

> Does that mean a VOLATILE function runs in a different transaction? No, all statements triggered by the outer statement is within the same transaction. If the trigger fails (without trapping the error), all affects including changes by outer statement would be rollback. > And does that mean it

Re: [GENERAL] How do BEGIN/COMMIT/ABORT operate in a nested SPI query?

On 4/18/2016 5:41 PM, da...@andl.org wrote: Are you sure you meant it like that? I already have BEGIN/COMMIT inside a function and it works perfectly. If it did not, then it would be impossible to use BEGIN/COMMIT in any language handler, since every call to a language handler is a call to a

Re: [GENERAL] How do BEGIN/COMMIT/ABORT operate in a nested SPI query?

> From: Albe Laurenz [mailto:laurenz.a...@wien.gv.at] > > > I am attempting to create a new language implementation. The language > > is Andl (andl.org), so the handler is plandl. > > This is a question about executing SPI queries from inside plandl. > > > > The documentation makes it clear that

Re: [GENERAL] $foo $bar is BAD

+1 We should be "open" to include various languages, dialect & colloquialisms in documentation... the measure is whether the meaning is clear - foobar has a long history, as do foo & bar, in the communication of ideas. That would mean no jargon, abbreviations, humour, sarcasm, acronyms, etc...

Re: [GENERAL] How to detoast a column of type BYTEAOID

OK, got it. I really wasn't expecting to have to deal with TOASTs in what looks like a rather ordinary query -- perhaps there might be a note in the documentation? But thanks, that works just fine. Problem solved. Regards David M Bennett FACS Andl - A New Database Language - andl.org >

[GENERAL] Partition table data not found in pg_dump

Partition tables are empty in backup while using pg_dump to take backup, but those tables having data in database. Below is the command i am using to take backup. ./pg_dump -i -h localhost -p 5432 -U postgres -F c -b -v -f /tmp/dump.sql db_mydb -- View this message in context:

[GENERAL] Re: what's the exact command definition in read committed isolation level?

Tom Lane schrieb am 18.04.2016 um 17:16: For trigger, e.g. written in pl/pgsql, each sql command within the function may see more new data beyond the (entry) snapshot of outer command. No it will not see "more data") It runs in the same _transaction_ as the "firing" command and thus sees

Re: [GENERAL] Re: what's the exact command definition in read committed isolation level?

Thomas Kellerer writes: > Jinhua Luo schrieb am 18.04.2016 um 16:47: >> For trigger, e.g. written in pl/pgsql, each sql command within the >> function may see more new data beyond the (entry) snapshot of outer >> command. > No it will not see "more data") > It runs in the

[GENERAL] Re: what's the exact command definition in read committed isolation level?

Jinhua Luo schrieb am 18.04.2016 um 16:47: > For trigger, e.g. written in pl/pgsql, each sql command within the > function may see more new data beyond the (entry) snapshot of outer > command. No it will not see "more data") It runs in the same _transaction_ as the "firing" command and thus sees

Re: [GENERAL] what's the exact command definition in read committed isolation level?

Let me clarify my question a bit more (I don't know why nobody raises such question): For trigger, e.g. written in pl/pgsql, each sql command within the function may see more new data beyond the (entry) snapshot of outer command. So if the "command" term in the read committed isolation level

Re: [GENERAL] How do BEGIN/COMMIT/ABORT operate in a nested SPI query?

da...@andl.org wrote: > I am attempting to create a new language implementation. The language is Andl > (andl.org), so the > handler is plandl. > This is a question about executing SPI queries from inside plandl. > > The documentation makes it clear that SPI allows nested queries; that in some

Re: [GENERAL] Enhancement request for pg_dump

On 04/17/2016 05:50 PM, Sergei Agalakov wrote: Nobody asks for pg_dump to be a schema comparison tool. As you tell yourself it is a most reliable schema capturing tool. All I am asking is that if pg_dump is executed on two databases with the identical schemas and security it should be able to

Re: [GENERAL] pg_basebackup: return value 1: reason?

On 04/17/2016 12:13 PM, Andrej Vanek wrote: Hello Adrian, I tried to use -U without "su"- launched directly by root: same behaviour. Finally I reverted my script to use standard backup (pg_start_backup; rsync; pg_stop_backup)- this works- the only downside is possible collisions with on-line

Re: [GENERAL] Enhancement request for pg_dump

On 04/17/2016 06:10 PM, Sergei Agalakov wrote: Thank you, I know this place. I just wanted to check that my request will have the peoples support. So far it doesn't. It looks like that or people never need to compare two PG databases to find the differences in the schemas or security, or happy

Re: [GENERAL] understanding postgres backend process memory usage

Hi Jony, First of all thank for considering the matter. Although the overall database has many tables, the relations/objects accessed by high RAM usage connections is rather limited. ( < 10 ) There are essentially a couple of “selects” (2-4) dependent on options that are enabled and then the

Re: [GENERAL] How to detoast a column of type BYTEAOID

OK, got it. I really wasn't expecting to have to deal with TOASTs in what looks like a rather ordinary query -- perhaps there might be a note in the documentation? But thanks, that works just fine. Problem solved. Regards David M Bennett FACS Andl - A New Database Language - andl.org >

Re: [GENERAL] How do BEGIN/COMMIT/ABORT operate in a nested SPI query?

I am attempting to create a new language implementation. The language is Andl (andl.org), so the handler is plandl. This is a question about executing SPI queries from inside plandl. The documentation makes it clear that SPI allows nested queries; that in some instances it will be necessary to

Re: [GENERAL] Multimaster

Hi, Thank you for your response. On 17.04.2016 15:30, Craig Ringer wrote: I intend to make the same split in pglogical its self - a receiver and apply worker split. Though my intent is to have them communicate via a shared memory segment until/unless the apply worker gets too far behind and

Re: [GENERAL] what's the exact command definition in read committed isolation level?

Jinhua Luo wrote: > The document said, "Read Committed mode starts each command with a new > snapshot that includes all transactions committed up to that instant". > > But what about the embedded commands within the outer command itself? > Do they share the same snapshot with the outer command? >

Re: [GENERAL] How to detoast a column of type BYTEAOID

da...@andl.org wrote: > I am attempting to create a new language implementation. The language is > Andl (andl.org), so the handler is plandl. > I am having a bit of trouble executing SPI queries from inside plandl. > > The particular problem arises after calling SPI_cursor_fetch() and then >