Re: Move cluster to new host, upgraded version

Поиск
Список
Период
Сортировка
От Ron
Тема Re: Move cluster to new host, upgraded version
Дата
Msg-id 0f099724-7b56-765e-7845-148f3aef7e34@gmail.com
обсуждение исходный текст
Ответ на Re: Move cluster to new host, upgraded version  (Rich Shepard <rshepard@appl-ecosys.com>)
Список pgsql-general
On 11/12/2018 07:55 AM, Rich Shepard wrote:
> On Sun, 11 Nov 2018, Ron wrote:
>
>> Unless your db is small, do a parallel dump. Even then, do a "-Fc" backup
>> instead. That's been the recommended method for many years.
>
> Ron,
>
>   I've several databases, none 'large.' When I've used pg_dumpall in the
> past it's always with the clean option (-c) and the output directed to a
> specified filename with the -f option. I don't find an -F option on the man
> page.

Hmm.  Apparently -F is only an option to pg_dump.  (I use multiple pg_dump 
statements + "pg_dumpall --globals-only".)

-- 
Angular momentum makes the world go 'round.


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

Предыдущее
От: Rich Shepard
Дата:
Сообщение: Re: Move cluster to new host, upgraded version
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Recommendation for upgrading from PostgreSQL 9.3