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
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,
>
> *
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?
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
star
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!
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 postgresq
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!
> 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 scr
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 /
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
NSION 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
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
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
On Mon, Apr 16, 2018 at 12:30 PM, Vick Khera 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 customers filling
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
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
s not have these values stored back then.
--
Keith Fiske
Senior Database Engineer
Crunchy Data - http://crunchydata.com
operly. I have not checked, but
> perhaps this is the kind of use cases where pg_partman
> (https://github.com/keithf4/pg_partman/) can become handy? Perhaps
> Keith, who maintains the tool, has some insight on the matter.
> --
> Michael
>
The method that Igor mentioned already in thi
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 link is pretty much
19 matches
Mail list logo
