pg_dump and indexes - Mailing list 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