Re: pg_restore - hangs or check on progress
От | Birchall, Austen |
---|---|
Тема | Re: pg_restore - hangs or check on progress |
Дата | |
Msg-id | 4E154FB60786D74BB4DFDC97BF991CAC03A238@EXXCMPD1DAG2.cmpd1.metoffice.gov.uk обсуждение исходный текст |
Ответ на | Roles and passwds ("Birchall, Austen" <austen.birchall@metoffice.gov.uk>) |
Ответы |
Re: pg_restore - hangs or check on progress
(Tom Lane <tgl@sss.pgh.pa.us>)
|
Список | pgsql-novice |
OK 1. I found the -v option which I presume will show progress 2. I realised that I actually had to do a CREATE DATABASE for testdb before doing the restore. The restore completed very quickly but I got the following errors - this is a postgis database pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (db)] Error from TOC entry 4797; 0 31549 TABLE DATA a dmcntry_gl3m0ahcmp__st cor pg_restore: [archiver (db)] COPY failed for table "admcntry_gl3m0ahcmp__st" : ERROR: ESRI: error getting spatial references for srid = 13: CONTEXT: COPY admcntry_gl3m0ahcmp__st, line 1, column shape: "AA0400006400 0000080010000D00000092120000010000008DAC92EEF4C7B40D92FBFBC88BCAA511DDFDBEB 0E103DCBDCEE0..." pg_restore: [archiver (db)] Error from TOC entry 4787; 0 30856 TABLE DATA b igash_st cor pg_restore: [archiver (db)] COPY failed for table "bigash_st": ERROR: ESRI : error getting spatial references for srid = 31: CONTEXT: COPY bigash_st, line 1, column shape: "910300005C000000080118001F 000000B90D00000100000092C4F6A0AB199CE3C0DA931EB4BEC79101B59E92B001B4F8E512. .." pg_restore: [archiver (db)] Error from TOC entry 4789; 0 30997 TABLE DATA bigeuhtpoly_st cor pg_restore: [archiver (db)] COPY failed for table "bigeuhtpoly_st": ERROR: ESRI: error getting spatial references for srid= 32: CONTEXT: COPY bigeuhtpoly_st, line 1, column shape: "D0B84600D92D09000800100020000000B8E2B5040100000091B8F6F2D61B9DBBCE96BF1EE8D9E702BF9AAA03C7A0E508A893..." WARNING: errors ignored on restore: 3 -bash-4.1$ Anybody know what is happening here? Austen -----Original Message----- From: Birchall, Austen Sent: 16 April 2013 10:58 To: pgsql-novice@postgresql.org Subject: pg_restore - hangs or check on progress 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 Linuxfiles 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
В списке pgsql-novice по дате отправления: