Re: pg_xlog piling

Поиск
Список
Период
Сортировка
От Venkata B Nagothi
Тема Re: pg_xlog piling
Дата
Msg-id CAEyp7J80SgSBXJ6SUDmLUQSZ0f4-WN4frVF-g=N9dkpqfgDL4Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_xlog piling  (chris <chrisk@pgsqlrocket.com>)
Ответы RE: pg_xlog piling  (Paula Price <paula.price@recondotech.com>)
Список pgsql-admin

On Wed, 31 Jan 2018 at 8:32 am, chris <chrisk@pgsqlrocket.com> wrote:
postgres=# select * from pg_stat_replication;pid  | usesysid | usename  | application_name |  client_addr   |
client_hostname | client_port |         backend_start         |   state   |
sent_location | write_location | flush_location | replay_locatio
n | sync_priority | sync_state 
------+----------+----------+------------------+----------------+-----------------+-------------+-------------------------------+-----------+---------------+----------------+----------------+---------------
--+---------------+------------5303 |       10 | postgres | walreceiver      | 198.161.184.74 |               |       57049 | 2017-12-14 11:13:16.339948-07 | streaming | 2FD3/41A38140 |
2FD3/41A38140  | 2FD3/41A38140  | 2F47/7015D490  |             0 | async
(1 row)

postgres=# 


# - Archiving -

archive_mode = on        # allows archiving to be done

archive_command = 'cp %p /ComplianceDB/pitr/walstage/%f; mv /ComplianceDB/pitr/walstage/%f /ComplianceDB/pitr/wal/%f'                # (change requires restart)
#archive_command = ''        # command to use to archive a logfile segment
                # placeholders: %p = path of file to archive
                #               %f = file name only
                # e.g. 'test ! -f /mnt/server/archivedir/%f && cp %p /mnt/server/archivedir/%f'
#archive_timeout = 0        # force a logfile segment switch after this
                # number of seconds; 0 disables
Thanks

 
Interesting. Do you see any files called *.ready in pg_xlog/archive_status directory ? Normally pg_xlog fills up when archive_command is not successful.

Do you have parameter wal_keep_segments configured to higher value ? 

Regards,
Venkata B
--

Regards,

Venkata B N
Database Consultant
 

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

Предыдущее
От: chris
Дата:
Сообщение: Re: pg_xlog piling
Следующее
От: Paula Price
Дата:
Сообщение: RE: pg_xlog piling