Re: here does postgres take its timezone information from?

Palle Girgensohn writes: > 16 nov. 2019 kl. 23:06 skrev Thomas Munro : >> Perhaps the best thing would be to revert this for the older >> PostgreSQL releases so that people doing minor version upgrades are >> inconvenienced by a system that can't start up after "pkg upgrade", >> but do it for 12

Re: here does postgres take its timezone information from?

> "Tom" == Tom Lane writes: Tom> Andrew Gierth writes: Tom> I think the "official" name of that zone is America/Los_Angeles. Tom> But initdb might seize on the US/Pacific alias, if available, >> And now you know why I have been saying for so many years that initdb >> should use the

Re: here does postgres take its timezone information from?

Andrew Gierth writes: > Tom> I think the "official" name of that zone is America/Los_Angeles. > Tom> But initdb might seize on the US/Pacific alias, if available, > And now you know why I have been saying for so many years that initdb > should use the official names! [ shrug... ] The

Re: here does postgres take its timezone information from?

> "Tom" == Tom Lane writes: >>> Ugh. It doesn't have the old backward compatibility names like >>> US/Pacific installed by default, which is a problem if that's what >>> initdb picked for your cluster (or you've stored references to any >>> of those names in other ways). >> One quick

Re: here does postgres take its timezone information from?

> 16 nov. 2019 kl. 23:06 skrev Thomas Munro : > > On Sat, Nov 16, 2019 at 7:13 PM Tom Lane > wrote: >> Palle Girgensohn writes: >>> 15 nov. 2019 kl. 21:32 skrev Thomas Munro : Ugh. It doesn't have the old backward compatibility names like US/Pacific

Re: here does postgres take its timezone information from?

On Sat, Nov 16, 2019 at 7:13 PM Tom Lane wrote: > Palle Girgensohn writes: > > 15 nov. 2019 kl. 21:32 skrev Thomas Munro : > >> Ugh. It doesn't have the old backward compatibility names like > >> US/Pacific installed by default, which is a problem if that's what > >> initdb picked for your

Re: here does postgres take its timezone information from?

> 15 nov. 2019 kl. 21:32 skrev Thomas Munro : > > On Sat, Nov 16, 2019 at 8:38 AM Tom Lane > wrote: >> Palle Girgensohn writes: 6 nov. 2019 kl. 03:03 skrev Thomas Munro : > *It looks like FreeBSD's port uses the copy of tzdata from the > PostgreSQL

Re: here does postgres take its timezone information from?

On Sat, Nov 16, 2019 at 8:38 AM Tom Lane wrote: > Palle Girgensohn writes: > >> 6 nov. 2019 kl. 03:03 skrev Thomas Munro : > >>> *It looks like FreeBSD's port uses the copy of tzdata from the > >>> PostgreSQL source tree by default and thus that is what you get if you > >>> install PostgreSQL

Re: here does postgres take its timezone information from?

Palle Girgensohn writes: >> 6 nov. 2019 kl. 03:03 skrev Thomas Munro : >>> *It looks like FreeBSD's port uses the copy of tzdata from the >>> PostgreSQL source tree by default and thus that is what you get if you >>> install PostgreSQL with "pkg". That's not a great default IMHO and >>> should

Re: here does postgres take its timezone information from?

Thomas Munro writes: > FreeBSD users already have the choice between zoneinfo from base or > the misc/zoneinfo port if for some reason they want to control tzdata > updates separately. PostgreSQL and FreeBSD both track tzdata closely, > and both pushed a commit for version 2019c into their

Re: here does postgres take its timezone information from?

On Wed, Nov 13, 2019 at 3:40 AM Palle Girgensohn wrote: > The decision to use postgresql's tzdata is quite old. It was based on the > assumption that postgres is updated more frequently than the operating > system, and that for that reason it was better to use postgresql's tzdata, > since it

Re: here does postgres take its timezone information from?

> 6 nov. 2019 kl. 03:03 skrev Thomas Munro : > > On Wed, Nov 6, 2019 at 2:20 PM Tom Lane wrote: >> Thomas Munro writes: >>> On Wed, Nov 6, 2019 at 12:02 PM Adrian Klaver >>> wrote: On 11/5/19 3:00 PM, Chris Withers wrote: > Hmm. Is there any option to use the system timezone

Re: here does postgres take its timezone information from?

On Wed, Nov 6, 2019 at 2:20 PM Tom Lane wrote: > Thomas Munro writes: > > On Wed, Nov 6, 2019 at 12:02 PM Adrian Klaver > > wrote: > >> On 11/5/19 3:00 PM, Chris Withers wrote: > >>> Hmm. Is there any option to use the system timezone packages? > > >> --with-system-tzdata=DIRECTORY > > > I

Re: here does postgres take its timezone information from?

Thomas Munro writes: > On Wed, Nov 6, 2019 at 12:02 PM Adrian Klaver > wrote: >> On 11/5/19 3:00 PM, Chris Withers wrote: >>> Hmm. Is there any option to use the system timezone packages? >> --with-system-tzdata=DIRECTORY > I hope that most distributions do that*, because otherwise you >

Re: here does postgres take its timezone information from?

On Wed, Nov 6, 2019 at 12:02 PM Adrian Klaver wrote: > On 11/5/19 3:00 PM, Chris Withers wrote: > > Hmm. Is there any option to use the system timezone packages? > > https://www.postgresql.org/docs/11/install-procedure.html > > --with-system-tzdata=DIRECTORY By the way, you can see if your

Re: here does postgres take its timezone information from?

On 11/5/19 3:00 PM, Chris Withers wrote: On 05/11/2019 22:54, Adrian Klaver wrote: On 11/5/19 2:46 PM, Chris Withers wrote: Hi All, Brazil recently abolished daylight savings time, resulting in updates to system timezone information packages. Does postgres use these? If so, does it need a

Re: here does postgres take its timezone information from?

On 05/11/2019 22:54, Adrian Klaver wrote: On 11/5/19 2:46 PM, Chris Withers wrote: Hi All, Brazil recently abolished daylight savings time, resulting in updates to system timezone information packages. Does postgres use these? If so, does it need a reload or restart to see the updated zone

Re: here does postgres take its timezone information from?

On 11/5/19 2:46 PM, Chris Withers wrote: Hi All, Brazil recently abolished daylight savings time, resulting in updates to system timezone information packages. Does postgres use these? If so, does it need a reload or restart to see the updated zone info? If not, how does postgres

Re: here does postgres take its timezone information from?

On 11/5/19 2:46 PM, Chris Withers wrote: Hi All, Brazil recently abolished daylight savings time, resulting in updates to system timezone information packages. Does postgres use these? If so, does it need a reload or restart to see the updated zone info? If not, how does postgres

here does postgres take its timezone information from?

Hi All, Brazil recently abolished daylight savings time, resulting in updates to system timezone information packages. Does postgres use these? If so, does it need a reload or restart to see the updated zone info? If not, how does postgres store/obtain its timezone zone information and how