Re: postgres wal log configuration question
| От | Rui DeSousa |
|---|---|
| Тема | Re: postgres wal log configuration question |
| Дата | |
| Msg-id | 56496583-595D-4267-A5F3-7C1AA877345A@crazybean.net обсуждение исходный текст |
| Ответ на | Re: postgres wal log configuration question (Pavan Kumar <pavan.dba27@gmail.com>) |
| Ответы |
Re: postgres wal log configuration question
|
| Список | pgsql-admin |
On May 7, 2019, at 10:58 AM, Pavan Kumar <pavan.dba27@gmail.com> wrote:how do i understand the output ? Is this wal segment name ? If yes, when i look at wal log location i do see below output. how do i correlate query output with os command output ?postgres=# select pg_switch_wal();pg_switch_wal---------------C/E000158(1 row)
Use pg_walfile_name(); i.e.
enso=# select pg_switch_wal();
pg_switch_wal
---------------
29CF/4D14B48
(1 row)
enso=# select pg_walfile_name('29CF/4D14B48');
pg_walfile_name
--------------------------
00000001000029CF00000000
(1 row)
enso=# select pg_walfile_name(pg_switch_wal());
pg_walfile_name
--------------------------
00000001000029CF00000001
(1 row)
В списке pgsql-admin по дате отправления: