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

Lists: Postg메이저 토토 사이트SQL : Postg메이저 토토 사이트SQL 메일 링리스트 : 2014-02-17 이후 PGSQL-BUGS.
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
Lists: Postg메이저 토토 사이트SQL : Postg메이저 토토 사이트SQL 메일 링리스트 : 2014-02-17 이후 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

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

sorry
affects v.9.3.1 linux

On 17.02.2014 12:36, 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.
>
> Regards,
> Alexey Bashtanov

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
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: Joe Van Dyk <joe(at)tanga(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Alexey Bashtanov <bashtanov(at)imap(dot)cc>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: create database ... template = ... does not copy configuration parameters values
Date: 2014-09-03 03:58:47
Message-ID: CACfv+pJvFBEGRkS1OytwxVpDCpO2-g7ZHupSeAwoNf-0k-OKfQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

On Sat, Apr 19, 2014 at 12:27 PM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:

> 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.

Is there a reason for this? I would love for these types of variables to be
copied into backups, restored from dumps, etc.