Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r7Had-004ppC-BM for pgsql-hackers@arkaria.postgresql.org; Sun, 26 Nov 2023 16:02:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1r7Hab-008f0B-NR for pgsql-hackers@arkaria.postgresql.org; Sun, 26 Nov 2023 16:02:33 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r7Hab-008f02-9j for pgsql-hackers@lists.postgresql.org; Sun, 26 Nov 2023 16:02:33 +0000 Received: from mail.postgrespro.ru ([93.174.131.139]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r7HaY-008dj6-Gi for pgsql-hackers@postgresql.org; Sun, 26 Nov 2023 16:02:32 +0000 Received: from [192.168.8.100] (unknown [178.176.72.249]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client did not present a certificate) (Authenticated sender: a.melnikov@postgrespro.ru) by mail.postgrespro.ru (Postfix/587) with ESMTPSA id CAE04E20E5B; Sun, 26 Nov 2023 19:02:28 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mx2023; t=1701014548; bh=Buwh87FUX+Hn56cfjyf73axLNAF04tbo7Ild2VJ8vUY=; h=Message-ID:Date:User-Agent:Subject:To:Cc:References:From: In-Reply-To:From; b=H/shFDFcfsh5vHr6rC9nsNtsMdZJKY/Ku2jAuYlVNfnQViIvofAKneep8ZMEG7vsu OhBZNyydKsqPLfV72lnlG68cOD5MtuSIUa/iaJ/aOc2cwkUd1PPZccKp8I5kK5Juyc 1z252ucCjoQI+Uh0btVyqCewum40w8xGFbazw/bWDdvLrhAiFWC0AuZetV42WD5j5Q pQQ9+Acqh0OuX+ahbOo01W6tx/AZ658NTyIQb59HizT/JobOESPVY48dK7EpP3Hi75 a8Ckj0TFFDxIDHHPmX6k1/UjOHYnk2J++ktnYe4Qa/Bqo/bksNsCmNs2reM+mZ9lvB LM0DWpY1y5Saw== Message-ID: <6ef65b1c-7ea9-4faf-8867-3fa801cb2dc5@postgrespro.ru> Date: Sun, 26 Nov 2023 19:02:28 +0300 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Should timezone be inherited from template database? Content-Language: en-US To: "David G. Johnston" Cc: PostgreSQL-development References: From: "Anton A. Melnikov" In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 26.11.2023 18:53, David G. Johnston wrote: > > https://www.postgresql.org/docs/current/sql-createdatabase.html > >  Database-level configuration parameters (set via ALTER DATABASE) and database-level permissions (set via GRANT) are not copied from the template database. > Clear. Thank you very much! With the best wishes, -- Anton A. Melnikov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company