From: | Les <nagylzs(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: invalid value for parameter "default_text_search_config": "public.pg" |
Date: | 2023-07-21 19:57:45 |
Message-ID: | CAKXe9UAJEc5viTV7FDtayQ6rH6bKFZnJCQa_muQh1-UjVyOf6w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>
> However, the parallel worker should just be absorbing the same
> configuration settings your main session is using. So what remains
> to be explained is why you aren't seeing the same complaint when
> starting a fresh session. It might be useful to look at the
> output of
>
> show default_text_search_config;
>
> and
>
> select * from pg_file_settings where name = 'default_text_search_config';
>
> psql (15.3 (Debian 15.3-1.pgdg110+1))
Type "help" for help.
mydatabase=# show default_text_search_config;
default_text_search_config
----------------------------
public.pg
(1 row)
mydatabase=# select * from pg_file_settings where name =
'default_text_search_config';
sourcefile | sourceline | seqno |
name | setting | applied | error
--------------------------------------------+------------+-------+----------------------------+-----------+---------+------------------------------
/opt/postgresql/data/conf.d/06_locale.conf | 17 | 24 |
default_text_search_config | public.pg | f | setting could not be
applied
(1 row)
mydatabase=#
I'm not sure what applied="public.pg", error="setting could not be applied"
means. I can change it in the config file, no problem. I just would like to
know if this is a simple configuration error, or a software installation
error. (Is public.pg a built-in config that should always exist?)
Regards,
Laszlo
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2023-07-21 21:09:15 | Re: invalid value for parameter "default_text_search_config": "public.pg" |
Previous Message | Tom Lane | 2023-07-21 19:31:53 | Re: invalid value for parameter "default_text_search_config": "public.pg" |