client_encoding issue with SQL_ASCII on 8.3 to 10 upgrade

2018-04-16 Thread Keith Fiske
s not have these values stored back then. -- Keith Fiske Senior Database Engineer Crunchy Data - http://crunchydata.com

Re: client_encoding issue with SQL_ASCII on 8.3 to 10 upgrade

2018-04-16 Thread Keith Fiske
On Mon, Apr 16, 2018 at 12:09 PM, Tom Lane wrote: > Keith Fiske writes: > > Running into an issue with helping a client upgrade from 8.3 to 10 (yes, > I > > know, please keep the out of support comments to a minimum, thanks :). > > > The old database was in SQL_ASCI

Re: client_encoding issue with SQL_ASCII on 8.3 to 10 upgrade

2018-04-16 Thread Keith Fiske
On Mon, Apr 16, 2018 at 12:21 PM, Tom Lane wrote: > Keith Fiske writes: > > On Mon, Apr 16, 2018 at 12:09 PM, Tom Lane wrote: > >> This is not a great idea, no. You could be getting strange misbehaviors > >> in e.g. string comparison, because strcoll() will exp

Re: client_encoding issue with SQL_ASCII on 8.3 to 10 upgrade

2018-04-16 Thread Keith Fiske
ithub.com/khera/utf8-inline-cleaner > > On Mon, Apr 16, 2018 at 11:16 AM, Keith Fiske > wrote: > >> Running into an issue with helping a client upgrade from 8.3 to 10 (yes, >> I know, please keep the out of support comments to a minimum, thanks :). >> >> The ol

Re: client_encoding issue with SQL_ASCII on 8.3 to 10 upgrade

2018-04-16 Thread Keith Fiske
On Mon, Apr 16, 2018 at 12:21 PM, Tom Lane wrote: > Keith Fiske writes: > > On Mon, Apr 16, 2018 at 12:09 PM, Tom Lane wrote: > >> This is not a great idea, no. You could be getting strange misbehaviors > >> in e.g. string comparison, because strcoll() will exp

Re: client_encoding issue with SQL_ASCII on 8.3 to 10 upgrade

2018-04-16 Thread Keith Fiske
On Mon, Apr 16, 2018 at 2:26 PM, Adrian Klaver wrote: > On 04/16/2018 10:18 AM, Keith Fiske wrote: > >> >> >> On Mon, Apr 16, 2018 at 12:21 PM, Tom Lane > t...@sss.pgh.pa.us>> wrote: >> >> > >> So playing around with the "client_encodin

Re: Suggestion to Monitoring Tool

2020-06-01 Thread Keith Fiske
s://github.com/pgaudit/pgaudit So, there is not a single monitoring solution that provides all the items you're looking for, but there are solutions to each item available. -- Keith Fiske Senior Database Engineer Crunchy Data - http://crunchydata.com

Re: Regarding use case of epoch to generate nanoseconds precision

2024-05-22 Thread Keith Fiske
sted nanosecond precision. It was easy to add the option so I did it for them, and anyone else that may find it useful. How you actually implement that level of time precision in an epoch value in your environment is entirely up to you. -- Keith Fiske Senior Database Engineer Crunchy Data - http://crunchydata.com