Should timezone be inherited from template database?
От | Anton A. Melnikov |
---|---|
Тема | Should timezone be inherited from template database? |
Дата | |
Msg-id | e92a3992-4ed7-48c4-8262-81bdf8b957de@postgrespro.ru обсуждение исходный текст |
Ответы |
Re: Should timezone be inherited from template database?
|
Список | pgsql-hackers |
Hello! Found that if i set a specific time zone for a template database, it will not be inherited in the database created from that template. psql (17devel) Type "help" for help. postgres=# select now(); now ------------------------------- 2023-11-26 17:24:58.242086+03 (1 row) postgres=# ALTER DATABASE template1 SET TimeZone = 'UTC'; ALTER DATABASE postgres=# \c template1 You are now connected to database "template1" as user "postgres". template1=# select now(); now ------------------------------- 2023-11-26 14:26:09.291082+00 (1 row) template1=# CREATE DATABASE test; CREATE DATABASE template1=# \c test You are now connected to database "test" as user "postgres". test=# select now(); now ------------------------------- 2023-11-26 17:29:05.487984+03 (1 row) Could you clarify please. Is this normal, predictable behavior? Would be very grateful! -- Anton A. Melnikov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company
В списке pgsql-hackers по дате отправления: