Can I pause the pg_dump or pg_restore

From: "arunpadule(at)gmail(dot)com" <arunpadule(at)gmail(dot)com>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: Can I pause the pg_dump or pg_restore
Date: 2012-10-30 07:16:23
Message-ID: 1351581383895-5730013.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2012-10-31 09:44:23 Re: pg_scanner - patch no.1
Previous Message Dave Page 2012-10-27 13:36:40 Re: Fixed duplicate name issue on DDL report dialog