Can I pause the pg_dump or pg_restore

Поиск
Список
Период
Сортировка
От arunpadule@gmail.com
Тема Can I pause the pg_dump or pg_restore
Дата
Msg-id 1351581383895-5730013.post@n5.nabble.com
обсуждение исходный текст
Список pgadmin-hackers

I have a 350 GB dump file of database. It takes 40 Hours to restore. Below
is my server processor properties.

model : 6 model name : AMD Athlon(tm) II X2 250 Processor stepping : 2 cpu
MHz : 3000.000 cache size : 1024 KB bogomips : 6027.81

When restore is in progress , the user accessing the another databases on
same server, feels slow performance. My requirement is to pause the restore
process in day time, when user's are accessing the server and resume the
process in night.

So can these be done.




--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Can-I-pause-the-pg-dump-or-pg-restore-tp5730013.html
Sent from the PostgreSQL - pgadmin hackers mailing list archive at Nabble.com.


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

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: Fixed duplicate name issue on DDL report dialog
Следующее
От: Dave Page
Дата:
Сообщение: Re: pg_scanner - patch no.1