From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Alexey Bashtanov <bashtanov(at)imap(dot)cc> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: create database ... template = ... does not copy configuration parameters values |
Date: | 2014-04-19 19:27:18 |
Message-ID: | 20140419192718.GD23526@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Mon, Feb 17, 2014 at 12:36:05PM +0400, Alexey Bashtanov wrote:
> Hello!
>
> There is a problem CREATE DATABASE does not copy configuration
> parameters values:
>
> [ACTIONS]
> ui_dev_12=# create database bash_test;
> CREATE DATABASE
> ui_dev_12=# alter database bash_test set log_min_messages TO 'debug5';
> ALTER DATABASE
> ui_dev_12=# create database bash_test2 template = bash_test;
> CREATE DATABASE
> ui_dev_12=# \q
> $ psql bash_test2
> psql (9.3.1)
> Type "help" for help.
>
> bash_test2=# show log_min_messages;
>
> [EXPECTED]
> log_min_messages
> ------------------
> debug5
> (1 row)
>
> [RECIEVED]
> log_min_messages
> ------------------
> warning
> (1 row)
>
> Please could you ether fix this behavior or at least describe
> current behavior in docs.
I have applied the attached patch to document this limitation.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
Attachment | Content-Type | Size |
---|---|---|
template.diff | text/x-diff | 740 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | ashafer01 | 2014-04-20 18:53:10 | BUG #10087: Invalid Apt GPG key |
Previous Message | Tom Lane | 2014-04-19 15:22:50 | Re: BUG #9186: CONTEXT log line still appears when turned off |