ch I
> can't find that file.
>
> Can someone please help?
You can execute the query:
=# select setting from pg_settings where name = 'hba_file';
--
Arthur Zakirov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company
--
Sent via pgsql-general mailing list (pgsql-g
chieve this?
>
Did you try pgaudit extension?
https://github.com/pgaudit/pgaudit
--
Arthur Zakirov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
. I debug them using dbg, but you can do it also from QtCreator.
--
Arthur Zakirov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wed, Sep 13, 2017 at 02:42:18PM +, Troy Hardin wrote:
> Putting either of these two lines in the .conf file cause it to fail to start.
Can you show error messages from logs?
--
Arthur Zakirov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company
--
Sent via pg
tps://www.postgresql.org/docs/10/static/runtime-config-logging.html#guc-log-line-prefix
--
Arthur Zakirov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
h
W with the tri-grams so that there is no need to
> create them each time the query runs?
>
As far as I know you can't do it nowadays. You can't create an trigram
column, as you can do it for FTS, you can create an tsvector column.
--
Arthur Zakirov
Postgres Professional: http://www.postgrespr
n look at its
code [3].
1 - https://www.postgresql.org/docs/current/static/pgtrgm.html#idm4642863576
2 -
http://tsdemo.postgrespro.ru/search?pattern=Galaksy=rank_func=ts_rank
3 - https://github.com/postgrespro/apod_fts/blob/master/apod.py
--
Arthur Zakirov
Postgres Professional: http://www.postgrespro.com
o use operators instead. You can try <% operator and
pg_trgm.word_similarity_threshold variable:
=# SET pg_trgm.word_similarity_threshold TO 0.1;
=# SELECT name, popularity
FROM temp.items3_v
,(values ('some phrase'::text)) consts(input)
WHERE input <% name
ORDER BY 2, input <
n. pgaudit records this
> verbatim which runs afoul of our HIPAA requirement. Prepared statements are
> not an issue since pgaudit provides a way to suppress values.
>
I doubt that. But I'm not sure that I understood you correctly. What do
you mean by "mask"? Some additional examples m