Re: BUG #14897: Segfault on statitics SQL request

The request returns this result on this database :
select name,setting,source from pg_settings where source != 'default';
           name            |      setting      |        source
----------------------------+-------------------+----------------------
application_name           | psql              | client
client_encoding            | UTF8              | client
data_checksums             | off               | override
DateStyle                  | ISO, DMY          | configuration file
default_text_search_config | pg_catalog.french | configuration file
dynamic_shared_memory_type | posix             | configuration file
lc_collate                 | fr_FR.utf8        | override
lc_ctype                   | fr_FR.utf8        | override
lc_messages                | fr_FR.utf8        | configuration file
lc_monetary                | fr_FR.utf8        | configuration file
lc_numeric                 | fr_FR.utf8        | configuration file
lc_time                    | fr_FR.utf8        | configuration file
log_timezone               | Europe/Paris      | configuration file
max_connections            | 100               | configuration file
max_stack_depth            | 2048              | environment variable
server_encoding            | UTF8              | override
shared_buffers             | 16384             | configuration file
TimeZone                   | Europe/Paris      | configuration file
transaction_deferrable     | off               | override
transaction_isolation      | read committed    | override
transaction_read_only      | off               | override
wal_buffers                | 512               | override

On postgres database, it returns :
select name,setting,source from pg_settings where source != 'default';
           name            |                setting                 |
       source
----------------------------+----------------------------------------+----------------------

application_name           | psql                                   |
client
client_encoding            | UTF8                                   |
client
config_file                | /var/lib/postgres/data/postgresql.conf |
override
data_checksums             | off                                    |
override
data_directory             | /var/lib/postgres/data                 |
override
DateStyle                  | ISO, DMY                               |
configuration file
default_text_search_config | pg_catalog.french                      |
configuration file
dynamic_shared_memory_type | posix                                  |
configuration file
hba_file                   | /var/lib/postgres/data/pg_hba.conf     |
override
ident_file                 | /var/lib/postgres/data/pg_ident.conf   |
override
lc_collate                 | fr_FR.utf8                             |
override
lc_ctype                   | fr_FR.utf8                             |
override
lc_messages                | fr_FR.utf8                             |
configuration file
lc_monetary                | fr_FR.utf8                             |
configuration file
lc_numeric                 | fr_FR.utf8                             |
configuration file
lc_time                    | fr_FR.utf8                             |
configuration file
log_timezone               | Europe/Paris                           |
configuration file
max_connections            | 100                                    |
configuration file
max_stack_depth            | 2048                                   |
environment variable
server_encoding            | UTF8                                   |
override
shared_buffers             | 16384                                  |
configuration file
TimeZone                   | Europe/Paris                           |
configuration file
transaction_deferrable     | off                                    |
override
transaction_isolation      | read committed                         |
override
transaction_read_only      | off                                    |
override
wal_buffers                | 512                                    |
override

Regards.

Vincent

Le ven. 10 nov. 2017 à 21:12, Tom Lane <tgl@sss.pgh.pa.us> a écrit :

> Vincent Lachenal <vincent.lachenal@gmail.com> writes:
> > Sorry. I didn't find the way to create an attachment in the interface.
> > You can find the database dump as attachment.
>
> Thanks for sending the data!  However, the given query doesn't crash for
> me, so there must be something non-default about your parameter settings.
> Could you send the result of
>
> select name,setting,source from pg_settings where source != 'default';
>
>                         regards, tom lane
>