Re: TCP Wrappers

2019-10-09 Thread Steve Crawford
On Wed, Oct 9, 2019 at 12:56 PM Timmy Siu wrote: > Dear all postgresql developers, > > I have tested postgres v11 against TCP Wrappers but it does not respond > to TCP wrappers port blocking. > > May I suggest the community to have postgres to work with TCP wrappers.?? > Its security will be bett

Re: CHAR vs NVARCHAR vs TEXT performance

2019-04-30 Thread Steve Crawford
> > > > On Tue, Apr 30, 2019 at 5:44 AM Tom Lane wrote: > >> FWIW, my recommendation for this sort of thing is almost always > >> to not use CHAR(n). The use-case for that datatype pretty much > >> disappeared with the last IBM Model 029 card punch. > ... > > > Perhaps the "tip" on the character

Re: PostgreSQL Limits and lack of documentation about them.

2018-11-28 Thread Steve Crawford
On Wed, Nov 28, 2018 at 10:06 AM Peter Eisentraut < peter.eisentr...@2ndquadrant.com> wrote: > That last sentence about the dropped columns is confusing to me: > > + > + Columns which have been dropped from the table also contribute to the > + maximum column limit, although the dropped

Re: date_trunc() in a specific time zone

2018-10-29 Thread Steve Crawford
On Mon, Oct 29, 2018 at 8:44 AM Vik Fearing wrote: > On 29/10/2018 16:26, Andreas Karlsson wrote: > > On 10/29/2018 04:18 PM, Vik Fearing wrote: > >> A use case that I see quite a lot of is needing to do reports and other > >> calculations on data per day/hour/etc but in the user's time zone. Th

Re: Postgres older version 8.3.7 on ubuntu 14

2018-10-23 Thread Steve Crawford
On Tue, Oct 23, 2018 at 10:08 AM Vaidyanathaswamy, Anandsaikrishnan < avaidyanathasw...@corelogic.com> wrote: > Good Morning, > > > > We have older version of postgres 8.3.7, I am trying to install postgres > on ubuntu 14.04 LTS under GCP instance, Im having difficulty in > installating the postg