Обсуждение: : : ReplicationSlots: :

Поиск
Список
Период
Сортировка

: : ReplicationSlots: :

От
JD
Дата:
Hi team,

Is there any way to calculate WAL file mount location size ? If we use replactation slots or some one guide best method use them ?  That would great help .

Re: : : ReplicationSlots: :

От
Shreeyansh Dba
Дата:
Hi JD,

You can use the below query to get the WAL file size location.

PostgreSQL-9.x

select pg_size_pretty(sum(((pg_stat_file('pg_xlog/'||fname)).size))) as total_size from pg_ls_dir('pg_xlog') as t(fname);

PostgreSQL-10.x
select pg_size_pretty(sum(((pg_stat_file('pg_wal/'||fname)).size))) as total_size from pg_ls_dir('pg_wal') as t(fname);

Hope this helps.



On Mon, Jun 25, 2018 at 5:30 PM, JD <venkijd@gmail.com> wrote:
Hi team,

Is there any way to calculate WAL file mount location size ? If we use replactation slots or some one guide best method use them ?  That would great help .