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(at)sss(dot)pgh(dot)pa(dot)us> a écrit :

> Vincent Lachenal <vincent(dot)lachenal(at)gmail(dot)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
>