Re: [GENERAL] SSL Compression - doesn't work?

2014-05-08 Thread Terence Ferraro
You mentioned you are using the Windows version; unless something has changed recently in their build process, the included openssl library is not linked against zlib and therefore compression is not possible unless you recompile the Windows version yourself. *Terence J. Ferraro* On Thu, May 8,

Re: [GENERAL] Timezone information

2014-02-19 Thread Terence Ferraro
Or, if you don't mind a little patching: http://pastebin.com/5AyaX2RF That restores the pre-9.1 functionality of determining the timezone on postmaster start. As has been pointed out, their new stuff is more useful if you're shipping instances to the farthest reaches of the planet (We've only got

Re: [GENERAL] configuring timezone

2013-02-06 Thread Terence Ferraro
t zlib (and the speed increase is quite significant). T.J. On Wed, Feb 6, 2013 at 3:23 PM, Igor Neyman wrote: > I am on Windows (both 32 and 64 bit) using 32-bit Postgres. > > So, your binaries are for 9.2.1, you aren’t planning to go to 9.2.2? > > ** ** > &g

Re: [GENERAL] configuring timezone

2013-02-06 Thread Terence Ferraro
ur thread (Dec, 2012) before posting my > question. > > But, recompile is not an option for me. Was hoping, that something > regarding this issue changed since… > > ** ** > > Igor Neyman > > ** ** > > *From:* Terence Ferraro [mailto:terencejferr...@gmail.c

Re: [GENERAL] configuring timezone

2013-02-06 Thread Terence Ferraro
See the archived thread here: http://www.postgresql.org/message-id/CAEghcWD8DXjroBYCZsdGrx+cHTCbCbW9es2uQ+o7a8NZ61JT=q...@mail.gmail.com Short version: Sorry, but you're going to need to recompile if you want that behavior. Here's a diff applied against 9.2.1 http://pastebin.com/5AyaX2RF. I've dep

Re: [GENERAL] Default timezone changes in 9.1

2012-12-16 Thread Terence Ferraro
On Sun, Dec 16, 2012 at 1:16 PM, Tom Lane wrote: > Andres Freund writes: > > On 2012-12-16 12:25:13 -0500, Tom Lane wrote: > >> I'm still not sure what > >> the OP actually wants to accomplish by moving the time of making the > >> choice. > > > I guess he wants - and I have seen that before - to

Re: [GENERAL] Default timezone changes in 9.1

2012-12-15 Thread Terence Ferraro
On Sat, Dec 15, 2012 at 11:54 PM, Gavin Flower < gavinflo...@archidevsys.co.nz> wrote: > Please do not top post, see end of email for rest of reply... > (Bottom posting is the convention here, so people can see the context > before reading your reply.) > > > > On 16/1

Re: [GENERAL] Default timezone changes in 9.1

2012-12-15 Thread Terence Ferraro
configuration option, in this case, *then* assumes GMT. In other words, it may be 2 AM NZST, but would you really want to walk around and have all of your clocks read 1 PM (GMT)? :) T.J. On Sat, Dec 15, 2012 at 10:35 PM, Gavin Flower < gavinflo...@archidevsys.co.nz> wrote: > On 16/12/12 16:07

[GENERAL] Default timezone changes in 9.1

2012-12-15 Thread Terence Ferraro
We recently began upgrading our clients' servers from 9.0 -> 9.2. After a few deployments and a little digging we noticed that 9.0 -> 9.1 broke the use of no timezone set within postgresql.conf. That is, not setting the option was now defaulting to GMT instead of the system timezone. Unfortunately,