Re: [GENERAL] how to regenerate pg_control file ?

2016-04-01 Thread Adrian Klaver
On 04/01/2016 10:44 AM, Brahim EL ALLIOUI wrote: Hi, Following a power failure the database is corrupt. I found that the file "pg_control" missing. I executed the command "pg_resetxlog" and he gave me the message: What version of Postgres? Exactly what was the command you gave? In particular

[GENERAL] how to regenerate pg_control file ?

2016-04-01 Thread Brahim EL ALLIOUI
Hi, Following a power failure the database is corrupt. I found that the file "pg_control" missing. I executed the command "pg_resetxlog" and he gave me the message: run : touch global/pg_control Please, what should be done ? Thanks, *Brahim EL ALLIOUI* *General Manager* belalli...@e-acta.com

Re: [GENERAL] Multimaster

2016-04-01 Thread Moreno Andreo
Il 01/04/2016 17:22, Joshua D. Drake ha scritto: On 04/01/2016 04:50 AM, Konstantin Knizhnik wrote: There are also some minor technical issues which lead us to making few changes in pglogical code but we tried to do our best to keep original versions unchanged, so we can switch to public versio

[GENERAL] instead of triggers refreshing materialized views

2016-04-01 Thread kovert
Hi There, This is with postgresql 9.5. For a combination of compatibility/speed issues, I have an updatable view that selects from a bunch of tables, views and a materialized view. I would really like updates to the base table (or the updatabale view) to somehow trigger a refresh of the material

Re: [GENERAL] Please advise on this trigger function

2016-04-01 Thread Adrian Klaver
On 03/30/2016 01:09 PM, John Stewart wrote: Good day, I have two tables, table1 & table2 with two trigger functions set on table1, on before & after insert. table1 contains a foreign key reference to table2, called building_id. What are the actual schema definitions for the tables? when a r

[GENERAL] Please advise on this trigger function

2016-04-01 Thread John Stewart
Good day, I have two tables, table1 & table2 with two trigger functions set on table1, on before & after insert. table1 contains a foreign key reference to table2, called building_id. when a row is inserted into table1, building is in text format, I need the after-trigger to lookup this text valu

Re: [GENERAL] Multimaster

2016-04-01 Thread Joshua D. Drake
On 04/01/2016 04:50 AM, Konstantin Knizhnik wrote: There are also some minor technical issues which lead us to making few changes in pglogical code but we tried to do our best to keep original versions unchanged, so we can switch to public version in future. It seems the better solution for al

Re: [GENERAL] Query from two tables return error

2016-04-01 Thread arnaud gaboury
On Fri, Apr 1, 2016 at 4:04 PM, Adrian Klaver wrote: > On 04/01/2016 06:52 AM, arnaud gaboury wrote: > >> >> >> On Fri, Apr 1, 2016 at 3:33 PM, Sándor Daku > > > > >> One of many difficulties with computers that they do what you say >> them to do, not what you think or you think you are s

Re: [GENERAL] Query from two tables return error

2016-04-01 Thread Adrian Klaver
On 04/01/2016 06:52 AM, arnaud gaboury wrote: On Fri, Apr 1, 2016 at 3:33 PM, Sándor Daku One of many difficulties with computers that they do what you say them to do, not what you think or you think you are saying. :) Lets see: SELECT d.home_dir FROM email.mail_dir d,

Re: [GENERAL] Query from two tables return error

2016-04-01 Thread arnaud gaboury
On Fri, Apr 1, 2016 at 3:33 PM, Sándor Daku wrote: > > On 1 April 2016 at 11:33, arnaud gaboury wrote: > >> I have one table email.mail.mailusers : >> >>Table "email.mailusers" >>Column| Type | >> Modifiers

Re: [GENERAL] Query from two tables return error

2016-04-01 Thread Sándor Daku
On 1 April 2016 at 11:33, arnaud gaboury wrote: > I have one table email.mail.mailusers : > >Table "email.mailusers" >Column| Type | > Modifiers | Storage > | Stats target | Description > >

Re: [GENERAL] Multimaster

2016-04-01 Thread Konstantin Knizhnik
Hi Simon, Yes, we will distributed all our code under PostgreSQL license. Right now we are using copy of pglogical_output plugin + receiver part written based on BDR code (just because when we started work on multimaster pglogical plugin was not released). We have plans to eliminate copies of p

Re: [GENERAL] Multimaster

2016-04-01 Thread Simon Riggs
On 1 April 2016 at 11:33, Konstantin Knizhnik wrote: > Our company PostgresPRO is now developing multimaster for Postgres, some > analogue of MySQL Galera. > It is based on logical replication and pglogical plugin from 2ndQuandrant > and uses distributed transaction manager. > Hi Konstantin, I

[GENERAL] Multimaster

2016-04-01 Thread Konstantin Knizhnik
Hi, Our company PostgresPRO is now developing multimaster for Postgres, some analogue of MySQL Galera. It is based on logical replication and pglogical plugin from 2ndQuandrand and uses distributed transaction manager. The main differences of multimaster from standard PostgreSQL streaming repl

Re: [GENERAL] Query from two tables return error

2016-04-01 Thread arnaud gaboury
On Fri, Apr 1, 2016 at 11:33 AM, arnaud gaboury wrote: > I have one table email.mail.mailusers : > >Table "email.mailusers" >Column| Type | > Modifiers | Storage > | Stats target | Description > > -

[GENERAL] Query from two tables return error

2016-04-01 Thread arnaud gaboury
I have one table email.mail.mailusers : Table "email.mailusers" Column| Type | Modifiers | Storage | Stats target | Description -+--+