Re: pg_dump.... pg_restore...how long does it take?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dump.... pg_restore...how long does it take?
Дата
Msg-id 1515.1188487886@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_dump.... pg_restore...how long does it take?  (rafikoko <rako@wapice.com>)
Список pgsql-general
rafikoko <rako@wapice.com> writes:
> Could you please suggest me other compination of parameters for pg_dump, so
> that it dumps complete database (inluding functions, triggers, procedures,
> operators, sequences, tables, views etc. and obviously data)?
> It doesn't have to be stored in .tar archive. Moreover I'd like to inform
> that I work in Windows environment.

If you don't have a very specific reason for using -Ft, don't --- the
-Fc and plain-sql-script alternatives are much more commonly used and
hence better debugged.  -Ft also has some other problems like a need
for extra temporary files.

            regards, tom lane

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

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: What kind of locks does vacuum process hold on the db?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Autovacuum not vacuuming pg_largeobject