Re: Redirect RAISE NOTICE and errors to separate log file

Поиск
Список
Период
Сортировка
От Nikhil Ingale
Тема Re: Redirect RAISE NOTICE and errors to separate log file
Дата
Msg-id CALXkTpyM1cNwZjQn2WPTm9TkxGJ7nwAzHihUdNnzCEdcP+e3pw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Redirect RAISE NOTICE and errors to separate log file  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-admin
Дерево обсуждения
I'm able to achieve it now. Thank you for the hint David.

On Fri, Feb 17, 2023 at 10:29 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Fri, Feb 17, 2023 at 9:52 AM Nikhil Ingale <niks.bgm@gmail.com> wrote:
I need the non query output in the user defined log file.
How can I achieve that?

Learn shell scripting.

At its simplest, have the user replace "/dev/null" in my example with whatever path they want.

psql doesn't expose specifying a non-query output channel so you are forced to deal with this in a higher/wrapper layer where you can manipulate stderr.

David J.


В списке pgsql-admin по дате отправления:

Предыдущее
От: pradeep pandey
Дата:
Сообщение: Re: EOL of Pglogical replication support
Следующее
От: Hotmail
Дата:
Сообщение: Is it possible to log long running recursive/internal postgresql queries?