[GENERAL] PGpool question

2017-07-28 Thread Andrew Kerber
This may be the wrong list, but I am not sure where it needs to go. I am trying to set up pgpool, and I keeping on getting this message: NOTICE: add node from hostname:"xxx" port:9000 pgpool_port: rejected. Jul 28 22:11:49 xx pgpool[10768]: [172-2] 2017-07-28 22:11:49: pid 10768: DET

Re: [GENERAL] Huge Pages - setting the right value

2017-06-11 Thread Andrew Kerber
Possamai wrote: > > > 2017-06-12 9:52 GMT+12:00 Andrew Kerber : > >> Was that transparent hugepages or standard hugepages? databases commonly >> have problems dealing with transparent hugepages. >> >> > > > IN my case, it was the Transparent Hugepages..

Re: [GENERAL] Huge Pages - setting the right value

2017-06-11 Thread Andrew Kerber
Was that transparent hugepages or standard hugepages? databases commonly have problems dealing with transparent hugepages. On Sun, Jun 11, 2017 at 4:39 PM, Lucas Possamai wrote: > 2017-06-12 7:52 GMT+12:00 Andrew Kerber : > >> I am sure it does not. >> >> Sent from my

Re: [GENERAL] Huge Pages - setting the right value

2017-06-11 Thread Andrew Kerber
I am sure it does not. Sent from my iPhone > On Jun 11, 2017, at 10:50 AM, pinker wrote: > > Andrew Kerber wrote >> I can't give you an absolutely authoritative answer, but because of the >> way hugepages are implemented and allocated, I can't think how

Re: [GENERAL] Huge Pages - setting the right value

2017-06-11 Thread Andrew Kerber
I can't give you an absolutely authoritative answer, but because of the way hugepages are implemented and allocated, I can't think how they could be used for other processes. Linux hugepages are either 2m or 1g, far too large for any likely processes to require. They cannot be allocated in part

Re: [GENERAL] Error that shouldn't happen?

2017-05-18 Thread Andrew Kerber
It appears to me you might be making this a lot more difficult than necessary. Why not just pre-create the required partitions daily or weekly or monthly? Or do you have a requirement that a new partition only be created the first time it is required? On Thu, May 18, 2017 at 3:31 PM, David G. John

Re: [GENERAL] PostgreSQL Required Monitoring

2017-04-28 Thread Andrew Kerber
Yes, that was the first item on my list (disk space)... On Fri, Apr 28, 2017 at 11:56 AM, Scott Marlowe wrote: > On Fri, Apr 28, 2017 at 8:39 AM, Andrew Kerber > wrote: > > I am a fairly experienced Oracle DBA, and we are starting to move in to > the > > PostgreSQL world

Re: [GENERAL] PostgreSQL Required Monitoring

2017-04-28 Thread Andrew Kerber
a transaction even without any Insert/update/delete command, so I had to explain that to my developers. On Fri, Apr 28, 2017 at 11:04 AM, John R Pierce wrote: > On 4/28/2017 7:39 AM, Andrew Kerber wrote: > >> I am a fairly experienced Oracle DBA, and we are starting to move

[GENERAL] PostgreSQL Required Monitoring

2017-04-28 Thread Andrew Kerber
I am a fairly experienced Oracle DBA, and we are starting to move in to the PostgreSQL world. I would expect the standard monitoring items are required for mission critical postgres apps, Ie, disk space, wal log space, log monitoring, process counts,software running, connection available on the co

Re: [GENERAL] The Contractor Conundrum

2017-04-26 Thread Andrew Kerber
All I can say is welcome to the world of contracting. You have successfully described the nature of the business. On Wed, Apr 26, 2017 at 10:33 AM, Geoff Winkless wrote: > On 26 April 2017 at 15:45, Melvin Davidson wrote: > >> In summary, I can only advise that aspiring contractors find out as

Re: [GENERAL] Largepages in Windows

2017-01-17 Thread Andrew Kerber
Oh, I can answer that. The owner of the postgreSQL executable must have the privilege to lock pages in memory. On Tue, Jan 17, 2017 at 9:38 AM, Tom Lane wrote: > Andrew Kerber writes: > > Does PostgreSQL 9.4 support large pages in windows? The setting is there > > in the postg

Re: [GENERAL] Largepages in Windows

2017-01-17 Thread Andrew Kerber
Thats what I needed, thank you. Windows generally calls them large pages, AIX also calls them large pages, really they are typically only called hugepages on Linux. On Tue, Jan 17, 2017 at 9:28 AM, Adrian Klaver wrote: > On 01/17/2017 07:20 AM, Andrew Kerber wrote: > >> Does Po

[GENERAL] Largepages in Windows

2017-01-17 Thread Andrew Kerber
Does PostgreSQL 9.4 support large pages in windows? The setting is there in the postgresql.conf, but I cant tell if it is supported in windows? -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.'

[GENERAL] Looking for a good programming reference

2016-06-15 Thread Andrew Kerber
So, I am a decent oracle SQL and PL/SQL programmer looking to expand into PostgreSQL. Can someone point me to a decent programming book on the topic? I have looked Amazon and Apress and not found much, so I am not sure where to turn. Or perhaps I am looking the wrong places. -- Andrew W. Kerbe