| From: | "Birchall, Austen" <austen(dot)birchall(at)metoffice(dot)gov(dot)uk> |
|---|---|
| To: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | pg_restore - hangs or check on progress |
| Date: | 2013-04-16 09:58:09 |
| Message-ID: | 4E154FB60786D74BB4DFDC97BF991CAC03A15D@EXXCMPD1DAG2.cmpd1.metoffice.gov.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
8.4.13 on Red Hat 6
I am doing a backup/restore test of a 'quite large' database
I ran the following backup
pg_dump -Fc testdb -U postgres > /var/lib/pgsql/backups/pg_testdb_backups/testdb_dev_backup$date_of_backup
then I connected to postgres db and did
drop dbtest
I then attempted to do a restore:
pg_restore -d testdb -j testdb_dev_backup201304141900
starting yesterday afternoon but then I came in this morning it is still running and as far as I can tell no data or Linux files have been written
1. Is pg_restore hanging and/or have I done something wrong?
2. Is there a way to check on the progress (% completed) for the pg_restore procedure?
Thanks
Austen Birchall
Senior DBA
Met Office
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Birchall, Austen | 2013-04-16 10:59:31 | Re: pg_restore - hangs or check on progress |
| Previous Message | Tanstaafl | 2013-04-15 21:36:29 | Re: Reliably backing up a live database |