[GENERAL] Re: [BUGS] about test_parser installation failure problem(PostgreSQL in 9.5.0)？

2016-01-15 Thread Michael Paquier
On Sat, Jan 16, 2016 at 2:03 AM, Tom Lane wrote: > "=?utf-8?B?6Zas6Zas44Kk44G1?=" writes: >> test_parser install is ok (postgresql 9.2.4) >> but at (postgresql 9.5.0) failure？ > > Yes, we moved test_parser and some other only-useful-for-testing modules > from contrib to src/test/modules,

Re: [GENERAL] Unable to build python extension with PGXS

2016-01-15 Thread Jim Nasby
On 1/13/16 3:11 PM, Jim Nasby wrote: On 1/12/16 10:04 PM, Jim Nasby wrote: Attempting to build a python extension, I'm getting: Undefined symbols for architecture x86_64: "_PyErr_Clear", referenced from: _PLyNdarray_FromDatum in pg_ndarray.o _PLyObject_To_ndarray in pg_ndarray.

[GENERAL] Adding node to bdr group

2016-01-15 Thread Cj B
Hi there, I want to add another node to my BDR group and was wondering what the best practice is. My database is about 4gb. Current servers on west coast and new server is on east coast. Can I just do a bdr.bdr_group_join

Re: [GENERAL] WIP: CoC V7

2016-01-15 Thread Joshua D. Drake
On 01/15/2016 09:03 AM, FarjadFarid(ChkNet) wrote: Joshua and all, Because of the current political environment we live in, even though I am neither a Muslim nor a Jew I am a Baha'i, I think we should not discuss religion or politics on this forum. All such topics can be discussed privately.

Re: [GENERAL] WIP: CoC V7

2016-01-15 Thread Vick Khera
On Fri, Jan 15, 2016 at 12:03 PM, FarjadFarid(ChkNet) wrote: > Because of the current political environment we live in, even though I am > neither a Muslim nor a Jew I am a Baha'i, I think we should not discuss > religion or politics on this forum. All such topics can be discussed > privately.

Re: [GENERAL] [BUGS] about test_parser installation failure problem(PostgreSQL in 9.5.0)？

2016-01-15 Thread Tom Lane
"=?utf-8?B?6Zas6Zas44Kk44G1?=" writes: > test_parser install is ok (postgresql 9.2.4) > but at (postgresql 9.5.0) failure？ Yes, we moved test_parser and some other only-useful-for-testing modules from contrib to src/test/modules, which means they won't get installed in standard install

Re: [GENERAL] WIP: CoC V7

2016-01-15 Thread FarjadFarid(ChkNet)
Joshua and all, Because of the current political environment we live in, even though I am neither a Muslim nor a Jew I am a Baha'i, I think we should not discuss religion or politics on this forum. All such topics can be discussed privately. Thanks for your efforts. Best Regards Farjad

Re: [GENERAL] WIP: CoC V7

2016-01-15 Thread Joshua D. Drake
On 01/15/2016 07:41 AM, Joshua D. Drake wrote: tl;dr; * Cleaned up first paragraph, making it more succint * Reworded last bullet a bit == PostgreSQL Community Code of Conduct (CoC) == This document provides community guidelines for a safe, respectful, productive, and collaborative place

[GENERAL] WIP: CoC V7

2016-01-15 Thread Joshua D. Drake
tl;dr; * Cleaned up first paragraph, making it more succint * Reworded last bullet a bit == PostgreSQL Community Code of Conduct (CoC) == This document provides community guidelines for a safe, respectful, productive, and collaborative place for any person who is willing to contribute to t

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

2016-01-15 Thread Andreas Joseph Krogh
På fredag 15. januar 2016 kl. 16:04:00, skrev Shulgin, Oleksandr < oleksandr.shul...@zalando.de >: On Fri, Jan 15, 2016 at 3:41 PM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: På fredag 15. januar 2016 kl. 14:33:24, skrev Shulgin, Oleksandr mailto:o

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

2016-01-15 Thread Shulgin, Oleksandr
On Fri, Jan 15, 2016 at 3:41 PM, Andreas Joseph Krogh wrote: > På fredag 15. januar 2016 kl. 14:33:24, skrev Shulgin, Oleksandr < > oleksandr.shul...@zalando.de>: > > On Fri, Jan 15, 2016 at 1:02 PM, Andreas Joseph Krogh > wrote: >> >> >> I see that wal_level = 'logical', and that is a problem f

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

2016-01-15 Thread Andreas Joseph Krogh
På fredag 15. januar 2016 kl. 14:33:24, skrev Shulgin, Oleksandr < oleksandr.shul...@zalando.de >: On Fri, Jan 15, 2016 at 1:02 PM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: På torsdag 14. januar 2016 kl. 00:34:51, skrev Jim Nasby mailto:jim.na...

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

2016-01-15 Thread Shulgin, Oleksandr
On Fri, Jan 15, 2016 at 1:02 PM, Andreas Joseph Krogh wrote: > På torsdag 14. januar 2016 kl. 00:34:51, skrev Jim Nasby < > jim.na...@bluetreble.com>: > > On 1/13/16 2:39 PM, Andreas Joseph Krogh wrote: > > Where can I find more info about how to use and configure pg_logical to > > replicate a 9.

Re: [GENERAL] Moving a large DB (> 500GB) to another DB with different locale

2016-01-15 Thread Andreas Joseph Krogh
På torsdag 14. januar 2016 kl. 00:34:51, skrev Jim Nasby < jim.na...@bluetreble.com >: On 1/13/16 2:39 PM, Andreas Joseph Krogh wrote: > Where can I find more info about how to use and configure pg_logical to > replicate a 9.4 DB to 9.5? http://2ndquadrant.com/e

[GENERAL] Re: [BDR] Best practice to automatically abort a DDL operation when one node is down

2016-01-15 Thread Sylvain MARECHAL
I am using BDR with two nodes 1 and 2. If I issue a DDL operation in node 1 when node 2 is down, for example: CREATE TABLE test (i int PRIMARY KEY); (1) all other transactions fail with the following error: Database is locked against DDL operations The problem is that the (1) DDL request w