Feedback-ID: i76984098:Fastmail
Message-ID: <dddad51b-4f53-4baa-be88-822caab9f900@aklaver.com>
Date: Mon, 21 Oct 2024 08:53:07 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Timezone: resolve $TZDIR in runtime
To: zarkonesmall@gmail.com, Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-general@lists.postgresql.org
References: <CABvPt_xtYyvFfyupGn=TXNGnEAFd0m_ARPFpDUWBcn603aM84w@mail.gmail.com>
 <1554256.1729521467@sss.pgh.pa.us>
 <CABvPt_zjW7oVeYg9SMtYre0cG_Jm_mxPiErZMvf2Eco-hOcDxA@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CABvPt_zjW7oVeYg9SMtYre0cG_Jm_mxPiErZMvf2Eco-hOcDxA@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/dddad51b-4f53-4baa-be88-822caab9f900%40aklaver.com>
Precedence: bulk

On 10/21/24 08:03, Anatolii Smolianinov wrote:
> Hi Tom, thanks for your reply!
> 
> I understand your point, and also, the idea of embedding postgresql -- 
> it might be just not what postgresql is built for. I was just thinking 
> that respecting the standard TZDIR approach would add more flexibility.

https://wiki.postgresql.org/wiki/Not_Worth_Doing#Features_We_Do_Not_Want

"Embedded server
     While PostgreSQL clients runs fine in limited-resource 
environments, the server requires multiple processes and a stable pool 
of resources to run reliably and efficiently. Stripping down the 
PostgreSQL server to run in the same process address space as the client 
application would add too much complexity and failure cases. Besides, 
there are several very mature embedded SQL databases already available. "


-- 
Adrian Klaver
adrian.klaver@aklaver.com