Re: Question about pg_upgrade from 9.2 to X.X

2019-03-03 Thread Perumal Raj
Thanks.Will decently try that option and keep you posted. Thanks again for redirecting to right group. Perumal Raju On Sun, Mar 3, 2019, 6:51 AM Justin Pryzby wrote: > Moving to -general list (-hackers is for development topics like proposed > patches and patch reviews and beta testing and cr

Re: Future Non-server Windows support???

2019-03-03 Thread Michael Paquier
On Sun, Mar 03, 2019 at 08:30:48AM +0100, Laurenz Albe wrote: > Speaking as a semi-ignorant, I had the impressions that all Windows versions > are pretty similar under the hood (with occasional annoying behavior changes), > and most of the differences are on the GUI level, while the C API is pretty

Re: support for JSON Web Token

2019-03-03 Thread Michel Pelletier
On Sat, Mar 2, 2019 at 4:09 PM Eugen Stan wrote: > Hi, > > I would like to advocate forJSON web token support in PostgreSQL. > > JWT tokens are used in a lot of web applications and I think there are > some very nice use cases for passing the token down to PostgreSQL. > pgjwt author here. While

Re: FDW and remote cursor_tuple_fraction

2019-03-03 Thread Jeff Janes
On Sun, Mar 3, 2019 at 12:38 PM auxsvr wrote: > Hi, > > One reason the remote plans via FDW are different than the plans of > queries running directly on the remote server is that a cursor is used, > which is optimized for low number of rows according to > cursor_tuple_fraction. Is there any way

FDW and remote cursor_tuple_fraction

2019-03-03 Thread auxsvr
Hi, One reason the remote plans via FDW are different than the plans of queries running directly on the remote server is that a cursor is used, which is optimized for low number of rows according to cursor_tuple_fraction. Is there any way to set parameters that affect the queries on the remote

Re: Future Non-server Windows support???

2019-03-03 Thread George Neuner
On Sun, 03 Mar 2019 08:30:48 +0100, Laurenz Albe wrote: >Bill Haught wrote: >> My main concern is that Microsoft has Enterprise versions of Windows and >> versions for everything else which makes me wonder if at some point >> Windows versions for desktop use may not have features needed by some

Re: Question about pg_upgrade from 9.2 to X.X

2019-03-03 Thread Justin Pryzby
Moving to -general list (-hackers is for development topics like proposed patches and patch reviews and beta testing and crash reports). On Thu, Feb 28, 2019 at 10:13:58AM -0800, Perumal Raj wrote: > could not load library "$libdir/pg_reorg": > ERROR: could not access file "$libdir/pg_reorg": No