Re: create database ... template = ... does not copy configuration parameters values - Mailing list 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@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +