Re: getting pg_basebackup to use remote destination

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: getting pg_basebackup to use remote destination
Дата
Msg-id CAMkU=1xNHs5hHapf1fNgJydeDOK-UqyXMR3Ho82E9KafbV+shQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: getting pg_basebackup to use remote destination  (Chuck Martin <clmartin@theombudsman.com>)
Ответы Re: getting pg_basebackup to use remote destination
Список pgsql-general
On Sun, Dec 30, 2018 at 6:17 PM Chuck Martin <clmartin@theombudsman.com> wrote:
Maybe I need to rethink ths and take Jeff's advice. I executed this:

pg_basebackup -h [main server's URL] -U postgres -P -v -X s -D /mnt/dbraid/data

8 hours ago, and it is now still at 1%. Should it be that slow? The database in question is about 750 GB, and both servers are on the same GB ethernet network.

Over gigabit ethernet, it should not be that slow.  Unless the network is saturated with other traffic or something.  Might be time to call in the network engineers.  Can you transfer static files at high speeds between those two hosts using scp or rsync?  (Or use some other technique to take PostgreSQL out of the loop and see if your network is performing as it should)

Are you seeing transfers at a constant slow rate, or are their long freezes or something?  Maybe the initial checkpoint was extremely slow?  Unfortunately -P option (even with -v) doesn't make this easy to figure out.  So alas it's back to old school stopwatch and a pen and paper (or spreadsheet).

Cheers,

Jeff

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

Предыдущее
От: Siegfried Bilstein
Дата:
Сообщение: Thoughts on row-level security for webapps?
Следующее
От: Chuck Martin
Дата:
Сообщение: Re: getting pg_basebackup to use remote destination