Re: Regarding use case of epoch to generate nanoseconds precision

n 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

Re: LDAP authorization with postgresql

Yes, authentication with gss is great. Just authorization story with postgresql is much harder. Should I even bother with LDAP? instead just do it manually? I want to avoid another component like pg-ldap-sync On Fri, Oct 8, 2021 at 3:08 PM Stephen Frost wrote: > > Greetings, > > *

LDAP authorization with postgresql

I use GSS for authentication. But I would like to setup LDAP based authorization, so a user can have access to a particular database/role/etc...I found documentation on how to setup LDAP but don't really see any examples for what I am trying to do. Any suggestions?

PostgreSQL starting with a corrupted database or other fatal issues

Assuming that PostgreSQL is started by systemd, and encounters fatal issues, how often does systemd attempt to re-start it before giving up? I'm not familiar with that interaction and if systemd stops after X attempts, or what. What does postgres do when it encounters fatal issues and cannot

Re: Customer unable to connect on port 5432, Postgres 10.7

Failed to copy pgsql-general, post repeated below: Adrian, I used your suggestions, fixed the column order, and it worked the first time for the customer this morning: hosttestpgdbpgusereee.fff.ggg.1/24password THANKS!

Customer unable to connect on port 5432, Postgres 10.7

Hello again Postgres friends, Customer is unable to log in to a PG database on 5432 using a Windows client. Output of my test sessions below, I think the problem may be lines 3 - 7 but no idea. Ideas greatly appreciated! Lines 1,2 PG Log entries Lines 3-7 pg_hba.conf entries Lines 8-10

See what options a Postgresql binary was compiled with

Planning to convert a Postgres 10 instance to systemd init. I understand it had to be compiled with systemd support to work that way. Thanks!

Re: Changing the data directory path before the initial configuration of PostgreSQL 10.7.1

> The easiest way is moving /var/lib/pgsql/data under /xyz directory > (when the db is not running) and create a symlink in the original > location: > > chown postgres: /xyz > su - postgres > mv /var/lib/pgsql/data /xyz/10-data > ln -s /xyz/10-data /var/lib/pgsql/data > > Then you can use setup

Changing the data directory path before the initial configuration of PostgreSQL 10.7.1

Hi Postgres friends, Using Postgres 10.7.1 on Fedora core 28. Admittedly not the latest but am helping a colleague with a production system who needs a PostgreSQL instance on this machine. The default /var/lib/pgsql/data directory needs to go on another partition with more space, let's call it

Re: Suggestion to Monitoring Tool

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

Linux Mint - cannot find auto_explain extension

auto_explain; ERROR:  could not open extension control file "/usr/share/postgresql/9.5/extension/auto_explain.control": No such file or directory postgres=# Does anyone have any idea what package I need to install to get the auto_explain extension please? TIA Keith Roberts

Re: client_encoding issue with SQL_ASCII on 8.3 to 10 upgrade

On Mon, Apr 16, 2018 at 2:26 PM, Adrian Klaver <adrian.kla...@aklaver.com> 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 > t...@sss.pgh.pa.us>> wrote: >> >

Re: client_encoding issue with SQL_ASCII on 8.3 to 10 upgrade

On Mon, Apr 16, 2018 at 12:30 PM, Vick Khera <vi...@khera.org> wrote: > Hi Keith, > > Not sure if this will help but a couple of years ago I migrated from an > SQL_ASCII encoding to UTF8. The data was primarily ASCII with some windows > garbage, and a little bit of UTF8 from

Re: client_encoding issue with SQL_ASCII on 8.3 to 10 upgrade

On Mon, Apr 16, 2018 at 12:21 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Keith Fiske <keith.fi...@crunchydata.com> writes: > > On Mon, Apr 16, 2018 at 12:09 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > >> This is not a great idea, no. You could be getting stra

Re: client_encoding issue with SQL_ASCII on 8.3 to 10 upgrade

On Mon, Apr 16, 2018 at 12:09 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Keith Fiske <keith.fi...@crunchydata.com> 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 min

Re: [MESSAGE PUBLICITAIRE- VIGILANCE] RE: Unsubscribe

The link to this simple form below is right at the top of the other link where it says "How to Subscribe or Unsubscribe, Fill out this form." https://www.postgresql.org/community/lists/subscribe/ On Mon, Nov 20, 2017 at 4:25 PM, Bennett Hitchcox-Lain wrote: > Yeah, that