Re: Looking for PostgreSQL Tuning Workshop Presenter

2023-08-18 Thread Dave Cramer
Hi Rumpi,

We do have a Speaker Bureau - PostgreSQL wiki
 you can try there.

Also if your group qualifies it's possible to get funding for your meetup
group if you have one.


Dave Cramer


On Thu, 17 Aug 2023 at 10:03, Rumpi Gravenstein  wrote:

> Hi,
>
> I am the coordinator for a Cleveland Ohio user group interested in
> bringing in a presenter to do a deep dive on PostgreSQL plans and tuning.
> I'm relatively new to the community so don't know who to ask or who might
> be interested. If you know of someone that has deep experience and would be
> willing to come to Cleveland, I'd be interested in discussing this
> opportunity with them.
>
> Best Regards,
>
> --
> Rumpi Gravenstein
>


Re: Bryn is retiring. Last day at work Friday 18-Aug-2023

2023-08-18 Thread Adrian Klaver

On 8/17/23 22:53, Bryn Llewellyn wrote:

I’m about to hang up my working boots. My last day of employment at Yugabyte, 
Inc (or anywhere at all) is imminent. My bryn-at-yugabyte-dot-com email address 
will stop working at 17:00 US/Pacific, Friday 18-Aug-2023. I’ll unsubscribe  
from this and all other postgresql-dot-org lists a few hours before that 
cut-off time.


Best wishes for your retirement.



Thanks very much to everybody who’s answered my questions. I know that I’ve 
annoyed many of you. But, from my side, the exchanges have been enormously 
helpful. It would have been so nice to have been able to ask my questions 
face-to-face so the whomever I talked to could see at a glance why I just 
didn’t get something that they said and thought was obvious. But those days are 
long gone now. The Brave New World has totally and irrevocably replaced that 
old regime—albeit somewhat later than Huxley forecast way back in 1931.


Yeah, in person conversations are easier to navigate. Then again 
electronic communication has enabled connections that would not 
otherwise have existed.




Who knows… I might re-subscribe presently using my private email address.


Sure keep the mind active.



Regards, Bryn Llewellyn



--
Adrian Klaver
adrian.kla...@aklaver.com





PG minor version in data directory?

2023-08-18 Thread Justin Clift

Hiyas,

Anyone know if there's a good way to tell what *minor* version
of PostgreSQL a data directory has been run with?

  eg 15.3 vs 15.4

Am working on some "automatic upgrade" stuff, and I'm only aware
of the major version being tracked in PGDATA/PG_VERSION.

If the minor version is already tracked somewhere as well, that
would be extremely useful for my use case.

Otherwise, I'll have to start manually adding info to track it.

Regards and best wishes,

Justin Clift




Re: PG minor version in data directory?

2023-08-18 Thread David G. Johnston
On Fri, Aug 18, 2023 at 6:36 PM Justin Clift  wrote:

> If the minor version is already tracked somewhere as well, that
> would be extremely useful for my use case.
>
>
The data directory doesn't have a concept of "minor version".  Only the
installed libraries and binaries do.

David J.


Re: PG minor version in data directory?

2023-08-18 Thread Justin Clift

On 2023-08-19 14:10, David G. Johnston wrote:
On Fri, Aug 18, 2023 at 6:36 PM Justin Clift  
wrote:



If the minor version is already tracked somewhere as well, that
would be extremely useful for my use case.



The data directory doesn't have a concept of "minor version".  Only the
installed libraries and binaries do.


Thanks, that's what I figured.  I'll have to keep state in a 
PG_VERSION_MINOR

there or something. :)

Regards and best wishes,

Justin Clift