Postgres for hadoop

2018-01-23 Thread Azimuddin Mohammed
Hello, Has anyone used postgres for hadoop. Of so what is the hardware configuration. Or can someone suggest a good hardware configuration or a way I can measure required hardware config for the db. Thanks in advance..

RE: Any community members in Phoenix, AZ?

2018-01-23 Thread Will LaShell
Josh, I'm out in the southeast valley (Chandler / Gilbert) as well. We can likely help with the facilities portion. Hit me up as well! (Probably should change my email address to my company email) Sincerely, Will LaShell -Original Message- From: Joshua D. Drake [mailto:j...@commandp

Re: Any community members in Phoenix, AZ?

2018-01-23 Thread Joshua D. Drake
On 01/23/2018 04:35 PM, David G. Johnston wrote: On Tue, Jan 23, 2018 at 4:14 PM, Joshua D. Drake >wrote: Folks, We have a Postgres meetup we have been trying to get off the ground in Phoenix: https://www.meetup.com/Phoenix-Postgres/

Re: Any community members in Phoenix, AZ?

2018-01-23 Thread David G. Johnston
On Tue, Jan 23, 2018 at 4:14 PM, Joshua D. Drake wrote: > Folks, > > We have a Postgres meetup we have been trying to get off the ground in > Phoenix: > > https://www.meetup.com/Phoenix-Postgres/ > > We could use some help with facilities and speakers. Do we have any locals > down there on this l

Re: Is it possible to sort strings in EBCDIC order in PostgreSQL server?

2018-01-23 Thread Jeremy Schneider
On 12/12/17 10:21, Peter Geoghegan wrote: > ICU supports creating custom collations that reorder upper and lower > case, or digits with scripts (e.g. Latin alphabet characters). See the > documentation -- "23.2.2.3.2. ICU collations". Advanced customization > is possible. I just gave this a try an

Any community members in Phoenix, AZ?

2018-01-23 Thread Joshua D. Drake
Folks, We have a Postgres meetup we have been trying to get off the ground in Phoenix: https://www.meetup.com/Phoenix-Postgres/ We could use some help with facilities and speakers. Do we have any locals down there on this list? It would be great to get a team together to help with this newe

Re: FW: Setting up streaming replication problems

2018-01-23 Thread Martin Goodson
On 23/01/2018 18:08, Pavan Teja wrote: On Jan 23, 2018 11:34 PM, "Martin Goodson" > wrote: On 23/01/2018 07:36, Thiemo Kellner, NHC Barhufpflege wrote: 1) I am not sure whether to put the md5 value of the repuser password

Re: Hardware advice

2018-01-23 Thread Tomas Vondra
Hi, On 01/22/2018 09:46 PM, Alban Hertroys wrote: > Hi all, > > At work we are in the process of setting up a data-warehouse using PG > 10. I'm looking for a suitable server, but I hardly know anything > about server-grade hardware. > > Hence, we're looking for some advice, preferably with some

Re: FW: Setting up streaming replication problems

2018-01-23 Thread Pavan Teja
On Jan 23, 2018 11:34 PM, "Martin Goodson" wrote: On 23/01/2018 07:36, Thiemo Kellner, NHC Barhufpflege wrote: > 1) I am not sure whether to put the md5 value of the repuser password > >> into primary conninfo or the plain one. I don't feel the documentation >>> or the book is clear on that. >

Re: FW: Setting up streaming replication problems

2018-01-23 Thread Martin Goodson
On 23/01/2018 07:36, Thiemo Kellner, NHC Barhufpflege wrote: 1) I am not sure whether to put the md5 value of the repuser password into primary conninfo or the plain one. I don't feel the documentation or the book is clear on that. Anyone two dimes on that? Password, not an md5. Or, at leas

Re: FW: Setting up streaming replication problems

2018-01-23 Thread Thiemo Kellner, NHC Barhufpflege
Andreas, thanks for your reply. I try to set up synchronous streaming replication as try-out. I use my laptop with Debian 9 and PostgreSQL package 10+189.pgdg90+1. And of this PostgreSQL installation I have two clusters main (master) and main2 (hot standby). I tried with Rigg's book and the Post

Re: Changing locale/charset

2018-01-23 Thread Adrian Klaver
On 01/22/2018 01:18 PM, Martin Moore wrote: I created a 10.1 cluster on Debian using UTF8. I’d like to convert it to LATIN1, but am having various issues. So, it’s probably easiest to start again (I have a dump of the DB). To ensure I get it right, what is the correct way to create a cluster wi

Re: Using random() in update produces same random value for all

2018-01-23 Thread Olleg Samoylov
On 2018-01-22 23:15, Tom Lane wrote: > > It is honored as volatile: it will be re-evaluated every time the > sub-select is re-evaluated. It's just that there's no cause to > re-evaluate the sub-select. > > I poked through the SQL standard to see if it spells out the semantics > of uncorrelated sub