Re: effects of nullifying bytea column on storage

2022-05-12 Thread Hugh Ranalli
On Wed, 11 May 2022 at 20:02, David Gauthier wrote: > I have a table with a bytea column which, of course, contains binary data. > After 60 days, I no longer need the binary data but want to retain the rest > of the record. Of course it's easy to just update the bytea column to null > for the

Re: Hunspell as filtering dictionary

2019-11-06 Thread Hugh Ranalli
On Tue, 5 Nov 2019 at 09:42, Bibi Mansione wrote: > Hi, > I am trying to create a ts_vector from a French text. Here are the > operations that seem logical to perform in that order: > > 1. remove stopwords > 2. use hunspell to find words roots > 3. unaccent > I can't speak to French, but we use

Re: Channel binding not supported using scram-sha-256 passwords

2019-02-18 Thread Hugh Ranalli
On Sun, 17 Feb 2019 at 20:06, Michael Paquier wrote: > Now, the error message "channel binding not supported by this build" > would show up by either the backend or the frontend if > X509_get_signature_nid() is not present in the version of OpenSSL your > version of libpq (for the frontend) or yo

Re: Channel binding not supported using scram-sha-256 passwords

2019-02-15 Thread Hugh Ranalli
On Fri, 15 Feb 2019 at 16:14, Bruce Momjian wrote: > The PG 11 release notes are clear that channel binding is not supported > in a usable way yet: > I did see that. However, I'm not *trying* to use it. I set up accounts with scram-sha-256 passwords, and when trying to connect I get this message

Channel binding not supported using scram-sha-256 passwords

2019-02-15 Thread Hugh Ranalli
global psqlrc ("\set scram_channel_binding"), with no success. We are not using SSL for the connections, and the documentation labels this as an SASL authentication mechanism. Is SSL required for using scram-sha-256 passwords? What am I missing? Thanks, Hugh -- Hugh Ranalli Principal Consultant White