pg_dump and indexes
От | John Liu |
---|---|
Тема | pg_dump and indexes |
Дата | |
Msg-id | NDBBKKKHILOHGHNKGOCEKEIEFAAA.johnl@emrx.com обсуждение исходный текст |
Ответ на | Re: pg_get_viewdef 7.4 et al (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-hackers |
On AIX4.3.2, 7.3.2 version, dump command - pg_dump dbname|gzip >db.gz restore - gunzip -c db.gz|psql dbname It looks like the dump is finished without errors, the size of dump file - -rw-rw-r-- 1 stiadmin apps 182445542 Apr 09 06:53 emrxdbs.gz many free space on the file system. after restore, only a few indexes remain on the tables, the rest of them are not restored, The record counts are correct, though. What's the cause of this losing indexes after restore? (I can always recreate them, but try to understand if this is normal/or expected behavior of pg_dump). Enclosed is the log info of this process (8:30am I issued psql to check if data loading finished or not, see the log) thanks for the help. johnl ================ 2003-04-09 07:05:58 NOTICE: CREATE TABLE will create implicit sequence 'provider_providerid_seq' for SERIAL column'provider.providerid' 2003-04-09 07:05:58 NOTICE: CREATE TABLE will create implicit sequence 'patient_patseq_seq' for SERIAL column 'pat ient.patseq' 2003-04-09 07:05:58 NOTICE: CREATE TABLE will create implicit sequence 'documenttype_doctypeid_seq' for SERIAL col umn 'documenttype.doctypeid' 2003-04-09 07:08:15 LOG: recycled transaction log file 0000000000000000 2003-04-09 07:08:15 LOG: recycled transaction log file 0000000000000001 2003-04-09 07:08:15 LOG: recycled transaction log file 0000000000000002 2003-04-09 07:09:25 LOG: recycled transaction log file 0000000000000003 2003-04-09 07:09:25 LOG: recycled transaction log file 0000000000000004 2003-04-09 07:09:25 LOG: recycled transaction log file 0000000000000005 2003-04-09 07:10:35 LOG: recycled transaction log file 0000000000000008 2003-04-09 07:10:35 LOG: recycled transaction log file 0000000000000006 2003-04-09 07:10:35 LOG: recycled transaction log file 0000000000000007 2003-04-09 07:11:45 LOG: recycled transaction log file 0000000000000009 2003-04-09 07:11:45 LOG: recycled transaction log file 000000000000000A 2003-04-09 07:11:45 LOG: recycled transaction log file 000000000000000B 2003-04-09 07:12:55 LOG: recycled transaction log file 000000000000000E 2003-04-09 07:12:55 LOG: recycled transaction log file 000000000000000C 2003-04-09 07:12:55 LOG: recycled transaction log file 000000000000000D 2003-04-09 07:14:07 LOG: recycled transaction log file 0000000000000011 2003-04-09 07:14:07 LOG: recycled transaction log file 000000000000000F 2003-04-09 07:14:07 LOG: recycled transaction log file 0000000000000010 2003-04-09 07:15:16 LOG: recycled transaction log file 0000000000000014 2003-04-09 07:15:16 LOG: recycled transaction log file 0000000000000012 2003-04-09 07:15:16 LOG: recycled transaction log file 0000000000000013 2003-04-09 07:16:27 LOG: recycled transaction log file 0000000000000017 2003-04-09 07:16:27 LOG: recycled transaction log file 0000000000000015 2003-04-09 07:16:27 LOG: recycled transaction log file 0000000000000016 2003-04-09 07:17:41 LOG: recycled transaction log file 000000000000001A 2003-04-09 07:17:41 LOG: recycled transaction log file 0000000000000018 2003-04-09 07:17:41 LOG: recycled transaction log file 0000000000000019 2003-04-09 07:18:58 LOG: recycled transaction log file 000000000000001D 2003-04-09 07:18:58 LOG: recycled transaction log file 000000000000001B 2003-04-09 07:18:58 LOG: recycled transaction log file 000000000000001C 2003-04-09 07:20:19 LOG: recycled transaction log file 0000000000000020 2003-04-09 07:20:19 LOG: recycled transaction log file 000000000000001E 2003-04-09 07:20:19 LOG: recycled transaction log file 000000000000001F 2003-04-09 07:21:39 LOG: recycled transaction log file 0000000000000023 2003-04-09 07:21:39 LOG: recycled transaction log file 0000000000000021 2003-04-09 07:21:39 LOG: recycled transaction log file 0000000000000022 2003-04-09 07:23:02 LOG: recycled transaction log file 0000000000000026 2003-04-09 07:23:02 LOG: recycled transaction log file 0000000000000024 2003-04-09 07:23:02 LOG: recycled transaction log file 0000000000000025 2003-04-09 07:24:23 LOG: recycled transaction log file 0000000000000029 2003-04-09 07:24:23 LOG: recycled transaction log file 0000000000000027 2003-04-09 07:24:23 LOG: recycled transaction log file 0000000000000028 2003-04-09 07:25:36 LOG: recycled transaction log file 000000000000002C 2003-04-09 07:25:36 LOG: recycled transaction log file 000000000000002A 2003-04-09 07:25:36 LOG: recycled transaction log file 000000000000002B 2003-04-09 07:26:56 LOG: recycled transaction log file 000000000000002F 2003-04-09 07:26:56 LOG: recycled transaction log file 000000000000002D 2003-04-09 07:26:56 LOG: recycled transaction log file 000000000000002E 2003-04-09 07:28:12 LOG: recycled transaction log file 0000000000000032 2003-04-09 07:28:12 LOG: recycled transaction log file 0000000000000030 2003-04-09 07:28:12 LOG: recycled transaction log file 0000000000000031 2003-04-09 07:29:30 LOG: recycled transaction log file 0000000000000035 2003-04-09 07:29:30 LOG: recycled transaction log file 0000000000000033 2003-04-09 07:29:30 LOG: recycled transaction log file 0000000000000034 2003-04-09 07:30:52 LOG: recycled transaction log file 0000000000000038 2003-04-09 07:30:52 LOG: recycled transaction log file 0000000000000036 2003-04-09 07:30:52 LOG: recycled transaction log file 0000000000000037 2003-04-09 07:32:07 LOG: recycled transaction log file 000000000000003B 2003-04-09 07:32:07 LOG: recycled transaction log file 0000000000000039 2003-04-09 07:32:07 LOG: recycled transaction log file 000000000000003A 2003-04-09 07:33:24 LOG: recycled transaction log file 000000000000003E 2003-04-09 07:33:24 LOG: recycled transaction log file 000000000000003C 2003-04-09 07:33:24 LOG: recycled transaction log file 000000000000003D 2003-04-09 07:34:41 LOG: recycled transaction log file 0000000000000041 2003-04-09 07:34:41 LOG: recycled transaction log file 000000000000003F 2003-04-09 07:34:41 LOG: recycled transaction log file 0000000000000040 2003-04-09 07:35:56 LOG: recycled transaction log file 0000000000000044 2003-04-09 07:35:56 LOG: recycled transaction log file 0000000000000042 2003-04-09 07:35:56 LOG: recycled transaction log file 0000000000000043 2003-04-09 07:37:15 LOG: recycled transaction log file 0000000000000047 2003-04-09 07:37:15 LOG: recycled transaction log file 0000000000000045 2003-04-09 07:37:15 LOG: recycled transaction log file 0000000000000046 2003-04-09 07:38:28 LOG: recycled transaction log file 000000000000004A 2003-04-09 07:38:28 LOG: recycled transaction log file 0000000000000048 2003-04-09 07:38:28 LOG: recycled transaction log file 0000000000000049 2003-04-09 07:39:37 LOG: recycled transaction log file 000000000000004D 2003-04-09 07:39:37 LOG: recycled transaction log file 000000000000004B 2003-04-09 07:39:37 LOG: recycled transaction log file 000000000000004C 2003-04-09 07:41:00 LOG: recycled transaction log file 0000000000000050 2003-04-09 07:41:00 LOG: recycled transaction log file 000000000000004E 2003-04-09 07:41:00 LOG: recycled transaction log file 000000000000004F 2003-04-09 07:42:18 LOG: recycled transaction log file 0000000000000053 2003-04-09 07:42:18 LOG: recycled transaction log file 0000000000000051 2003-04-09 07:42:18 LOG: recycled transaction log file 0000000000000052 2003-04-09 07:43:29 LOG: recycled transaction log file 0000000000000056 2003-04-09 07:43:29 LOG: recycled transaction log file 0000000000000054 2003-04-09 07:43:29 LOG: recycled transaction log file 0000000000000055 2003-04-09 07:44:39 LOG: recycled transaction log file 0000000000000059 2003-04-09 07:44:39 LOG: recycled transaction log file 0000000000000057 2003-04-09 07:44:39 LOG: recycled transaction log file 0000000000000058 2003-04-09 07:45:54 LOG: recycled transaction log file 000000000000005C 2003-04-09 07:45:54 LOG: recycled transaction log file 000000000000005A 2003-04-09 07:45:54 LOG: recycled transaction log file 000000000000005B 2003-04-09 07:47:04 LOG: recycled transaction log file 000000000000005F 2003-04-09 07:47:04 LOG: recycled transaction log file 000000000000005D 2003-04-09 07:47:04 LOG: recycled transaction log file 000000000000005E 2003-04-09 07:48:14 LOG: recycled transaction log file 0000000000000062 2003-04-09 07:48:14 LOG: recycled transaction log file 0000000000000060 2003-04-09 07:48:14 LOG: recycled transaction log file 0000000000000061 2003-04-09 07:49:27 LOG: recycled transaction log file 0000000000000065 2003-04-09 07:49:27 LOG: recycled transaction log file 0000000000000063 2003-04-09 07:49:27 LOG: recycled transaction log file 0000000000000064 2003-04-09 07:50:40 LOG: recycled transaction log file 0000000000000068 2003-04-09 07:50:40 LOG: recycled transaction log file 0000000000000066 2003-04-09 07:50:40 LOG: recycled transaction log file 0000000000000067 2003-04-09 07:51:51 LOG: recycled transaction log file 000000000000006B 2003-04-09 07:51:51 LOG: recycled transaction log file 0000000000000069 2003-04-09 07:51:51 LOG: recycled transaction log file 000000000000006A 2003-04-09 07:53:14 LOG: recycled transaction log file 000000000000006E 2003-04-09 07:53:14 LOG: recycled transaction log file 000000000000006C 2003-04-09 07:53:14 LOG: recycled transaction log file 000000000000006D 2003-04-09 07:54:31 LOG: recycled transaction log file 0000000000000071 2003-04-09 07:54:31 LOG: recycled transaction log file 000000000000006F 2003-04-09 07:54:31 LOG: recycled transaction log file 0000000000000070 2003-04-09 07:55:49 LOG: recycled transaction log file 0000000000000074 2003-04-09 07:55:49 LOG: recycled transaction log file 0000000000000072 2003-04-09 07:55:49 LOG: recycled transaction log file 0000000000000073 2003-04-09 07:57:00 LOG: recycled transaction log file 0000000000000077 2003-04-09 07:57:00 LOG: recycled transaction log file 0000000000000075 2003-04-09 07:57:00 LOG: recycled transaction log file 0000000000000076 2003-04-09 07:58:14 LOG: recycled transaction log file 000000000000007A 2003-04-09 07:58:14 LOG: recycled transaction log file 0000000000000078 2003-04-09 07:58:14 LOG: recycled transaction log file 0000000000000079 2003-04-09 07:59:31 LOG: recycled transaction log file 000000000000007D 2003-04-09 07:59:31 LOG: recycled transaction log file 000000000000007B 2003-04-09 07:59:31 LOG: recycled transaction log file 000000000000007C 2003-04-09 08:00:50 LOG: recycled transaction log file 0000000000000080 2003-04-09 08:00:50 LOG: recycled transaction log file 000000000000007E 2003-04-09 08:00:50 LOG: recycled transaction log file 000000000000007F 2003-04-09 08:02:10 LOG: recycled transaction log file 0000000000000083 2003-04-09 08:02:10 LOG: recycled transaction log file 0000000000000081 2003-04-09 08:02:10 LOG: recycled transaction log file 0000000000000082 2003-04-09 08:03:37 LOG: recycled transaction log file 0000000000000086 2003-04-09 08:03:37 LOG: recycled transaction log file 0000000000000084 2003-04-09 08:03:37 LOG: recycled transaction log file 0000000000000085 2003-04-09 08:04:51 LOG: recycled transaction log file 0000000000000089 2003-04-09 08:04:51 LOG: recycled transaction log file 0000000000000087 2003-04-09 08:04:51 LOG: recycled transaction log file 0000000000000088 2003-04-09 08:05:52 LOG: recycled transaction log file 000000000000008C 2003-04-09 08:05:52 LOG: recycled transaction log file 000000000000008A 2003-04-09 08:05:52 LOG: recycled transaction log file 000000000000008B 2003-04-09 08:06:55 LOG: recycled transaction log file 000000000000008F 2003-04-09 08:06:55 LOG: recycled transaction log file 000000000000008D 2003-04-09 08:06:55 LOG: recycled transaction log file 000000000000008E 2003-04-09 08:08:01 LOG: recycled transaction log file 0000000000000092 2003-04-09 08:08:01 LOG: recycled transaction log file 0000000000000090 2003-04-09 08:08:01 LOG: recycled transaction log file 0000000000000091 2003-04-09 08:13:15 LOG: recycled transaction log file 0000000000000095 2003-04-09 08:13:15 LOG: recycled transaction log file 0000000000000093 2003-04-09 08:13:15 LOG: recycled transaction log file 0000000000000094 2003-04-09 08:32:28 LOG: pq_flush: send() failed: Broken pipe 2003-04-09 08:32:28 LOG: pq_recvbuf: unexpected EOF on client connection 2003-04-09 08:33:29 LOG: recycled transaction log file 0000000000000096
В списке pgsql-hackers по дате отправления:
Предыдущее
От: Shridhar DaithankarДата:
Сообщение: [OT][Announce] Availability of OAS Server pakcages