create database ... template = ... does not copy configuration parameters values

From: Alexey Bashtanov <bashtanov(at)imap(dot)cc>
To: pgsql-bugs(at)postgresql(dot)org
Subject: create database ... template = ... does not copy configuration parameters values
Date: 2014-02-17 08:36:05
Message-ID: 5301C9F5.5010209@imap.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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.

Regards,
Alexey Bashtanov

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alexey Bashtanov 2014-02-17 08:37:07 Re: create database ... template = ... does not copy configuration parameters values
Previous Message Karl-Philipp Richter 2014-02-17 05:59:38 Re: BUG #9251: default values for fatal error logging in service