Create a Foreign Table for PostgreSQL CSV Logs

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема Create a Foreign Table for PostgreSQL CSV Logs
Дата
Msg-id 159800192078.2886.10431506404995508950@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: Create a Foreign Table for PostgreSQL CSV Logs  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/12/runtime-config-logging.html
Description:

There is some imperfection  in PostgreSQL doc. There are two section in
documentation how to import PostgreSQL log into sql space and both not
complete. One of them is:
https://www.postgresql.org/docs/current/file-fdw.html
Example F.1. Create a Foreign Table for PostgreSQL CSV Logs
Here is described how to config file-fdw to get access to the PostgreSQL
logs, but there is not description or a link how to config PostgreSQL log
for this.

Other section is:
https://www.postgresql.org/docs/12/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-CSVLOG
19.8.4. Using CSV-Format Log Output
Here is described how to configure PostgreSQL log to import it into
previously created ordinary table by COPY command. May be this configuration
is compatible with "Example F.1. Create a Foreign Table for PostgreSQL CSV
Logs", but this method is not mentioned.

My idea to improve documentation by adding cross link: to section «Example
F.1. Create a Foreign Table for PostgreSQL CSV Logs» add link to «19.8.4.
Using CSV-Format Log Output» as example of log configuration and to section
«19.8.4. Using CSV-Format Log Output» add link to «Example F.1. Create a
Foreign Table for PostgreSQL CSV Logs» as one more example how PostgreSQL
logs can be imported inside PostgreSQL.

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

Предыдущее
От: Kasper Kondzielski
Дата:
Сообщение: Re: Request for further clarification on synchronous_commit
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Request for further clarification on synchronous_commit