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?

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 > wrote: På torsdag 14. januar 2016 kl. 00:34:51, skrev Jim

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 > wrote: På fredag 15. januar 2016 kl. 14:33:24, skrev

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

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

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

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

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

[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

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] 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] 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

[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

[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