Hi all!
I try dump and restore my database, but i got some trouble with
indexes.
I dumped my database with pg_dump:
pg_dump --format c --file=/home/postgres/bydump byenet
After this i try to restore the db:
pg_restore -c -d byprb /home/postgres/bydump
pg_restore: [archiver (db)] could not execute query: ERROR: index
"fhelyhist_fhszam_ind" does not exist
If i drop the index before the pg_dump, then the same hapens with
another index.
What i do wrong?
DAQ
Ps.: The TOC of the dump is atached.
;
; Archive created at Wed Jul 24 12:09:03 2002
; dbname: byenet
; TOC Entries: 179
; Compression: -1
; Dump Version: 1.5-7
; Format: CUSTOM
;
;
; Selected TOC Entries:
;
109; 36262 FUNCTION "plpgsql_call_handler" () postgres
110; 36263 PROCEDURAL LANGUAGE plpgsql
19; 76644 TABLE vizmero postgres
20; 76644 ACL vizmero
21; 109270 TABLE vmallas postgres
22; 109270 ACL vmallas
23; 1661533 TABLE cimfh postgres
24; 1661533 ACL cimfh
111; 1681204 FUNCTION "cimbeill" () postgres
25; 1681206 TABLE szlafej postgres
26; 1681206 ACL szlafej
27; 1681208 TABLE szlafh postgres
28; 1681208 ACL szlafh
29; 2355206 TABLE szlasor postgres
30; 2355206 ACL szlasor
31; 2948772 TABLE systables postgres
32; 2948772 ACL systables
113; 2948880 FUNCTION "adduser" (character varying,character varying) postgres
118; 2948892 FUNCTION "kickuser" (character varying) postgres
33; 3726943 TABLE tart daq
34; 3726943 ACL tart
35; 3945822 TABLE folyo daq
36; 3945822 ACL folyo
2; 4251571 SEQUENCE varos_varoskod_seq daq
4; 4251571 ACL varos_varoskod_seq
37; 4251573 TABLE varos daq
38; 4251573 ACL varos
39; 4252483 TABLE varosok1 daq
40; 4252483 ACL varosok1
41; 4252487 VIEW osszvar daq
42; 4252487 ACL osszvar
116; 4253393 FUNCTION "varososzt" () daq
43; 4253396 VIEW kulvaros daq
44; 4253396 ACL kulvaros
5; 4253725 SEQUENCE utca_seq daq
7; 4253725 ACL utca_seq
8; 4253732 SEQUENCE utca_utcakod_seq daq
10; 4253732 ACL utca_utcakod_seq
45; 4253734 TABLE utca daq
46; 4253734 ACL utca
121; 4253739 FUNCTION "cimfuz" (character varying) daq
47; 4254048 TABLE vegyenleg daq
48; 4254048 ACL vegyenleg
122; 4254051 FUNCTION "egyenleg" () daq
123; 4274717 FUNCTION "getegyenleg" (integer) daq
49; 4274719 TABLE tartkod daq
50; 4274719 ACL tartkod
124; 4274726 FUNCTION "gettarttip" (character varying) daq
51; 4274727 TABLE varosok daq
52; 4274727 ACL varosok
53; 4274731 VIEW osszvar1 daq
54; 4274731 ACL osszvar1
55; 4403468 TABLE cimvevo daq
56; 4403468 ACL cimvevo
119; 4424097 FUNCTION "cimbeillvevo" (integer) daq
57; 4424102 VIEW egyutca daq
58; 4424102 ACL egyutca
120; 4424104 FUNCTION "utcatolt" () daq
59; 4424489 TABLE kamattip daq
60; 4424489 ACL kamattip
125; 4424517 FUNCTION "kamatvevore" (integer) daq
61; 4424760 TABLE ingtip daq
62; 4424760 ACL ingtip
63; 4424762 TABLE inttip daq
64; 4424762 ACL inttip
65; 4424843 TABLE osszegkod daq
66; 4424843 ACL osszegkod
127; 4424861 FUNCTION "getosszkod" ("char") daq
67; 4424865 TABLE irattip daq
68; 4424865 ACL irattip
129; 4424875 FUNCTION "getirattip" (character varying) daq
126; 4424879 FUNCTION "getvaros" (integer) daq
128; 4424882 FUNCTION "getutca" (integer) daq
69; 4424981 TABLE fhelyhist daq
70; 4424981 ACL fhelyhist
11; 4444648 SEQUENCE fhely_fhseq_seq daq
13; 4444648 ACL fhely_fhseq_seq
71; 4444650 TABLE fhely daq
72; 4444650 ACL fhely
14; 4484986 SEQUENCE vevo_vseq_seq daq
16; 4484986 ACL vevo_vseq_seq
73; 4484988 TABLE vevo daq
74; 4484988 ACL vevo
75; 4505657 TABLE vevohist daq
76; 4505657 ACL vevohist
130; 4505666 FUNCTION "fhely_update" () daq
131; 4505675 FUNCTION "fhely_insert" () daq
132; 4505681 FUNCTION "kamat" (character varying,character varying,integer) daq
133; 4505682 FUNCTION "kegyenleg" (character varying,character varying,integer) daq
134; 4505683 FUNCTION "kegyenvevore" (integer) daq
136; 4505688 FUNCTION "getfunct" (oid) daq
137; 4505696 FUNCTION "dropfunct" (oid) daq
77; 4525372 VIEW userfunct daq
78; 4525372 ACL userfunct
79; 4525375 TABLE tarar daq
80; 4525375 ACL tarar
81; 4525397 TABLE tarifa daq
82; 4525397 ACL tarifa
83; 4525417 TABLE vingatlan daq
84; 4525417 ACL vingatlan
139; 4525425 FUNCTION "cimfuz" (bigint,bigint,character varying,character
varying,character varying) daq
112; 4525436 FUNCTION "vevo_update" () daq
114; 4525444 FUNCTION "vevo_insert" () daq
85; 4525537 TABLE ciming daq
86; 4525537 ACL ciming
135; 4533641 FUNCTION "grantall" () daq
138; 4533887 FUNCTION "cimingbeill" () daq
87; 4533903 TABLE cimint daq
88; 4533903 ACL cimint
89; 4534290 TABLE intezkedok daq
90; 4534290 ACL intezkedok
115; 4534427 FUNCTION "cimintbeill" () daq
117; 4534487 FUNCTION "varosintbeill" () daq
17; 4534532 SEQUENCE help_helpkod_seq daq
91; 4534534 TABLE help daq
92; 4534545 TABLE vvip daq
140; 4534564 FUNCTION "cimvevo" (integer) daq
141; 4534565 FUNCTION "cimfh" (character varying) daq
142; 4534566 FUNCTION "nevcimvevo" (integer) daq
143; 76644 TABLE DATA vizmero postgres
144; 109270 TABLE DATA vmallas postgres
145; 1661533 TABLE DATA cimfh postgres
146; 1681206 TABLE DATA szlafej postgres
147; 1681208 TABLE DATA szlafh postgres
148; 2355206 TABLE DATA szlasor postgres
149; 2948772 TABLE DATA systables postgres
150; 3726943 TABLE DATA tart daq
151; 3945822 TABLE DATA folyo daq
152; 4251573 TABLE DATA varos daq
153; 4252483 TABLE DATA varosok1 daq
154; 4253734 TABLE DATA utca daq
155; 4254048 TABLE DATA vegyenleg daq
156; 4274719 TABLE DATA tartkod daq
157; 4274727 TABLE DATA varosok daq
158; 4403468 TABLE DATA cimvevo daq
159; 4424489 TABLE DATA kamattip daq
160; 4424760 TABLE DATA ingtip daq
161; 4424762 TABLE DATA inttip daq
162; 4424843 TABLE DATA osszegkod daq
163; 4424865 TABLE DATA irattip daq
164; 4424981 TABLE DATA fhelyhist daq
165; 4444650 TABLE DATA fhely daq
166; 4484988 TABLE DATA vevo daq
167; 4505657 TABLE DATA vevohist daq
168; 4525375 TABLE DATA tarar daq
169; 4525397 TABLE DATA tarifa daq
170; 4525417 TABLE DATA vingatlan daq
171; 4525537 TABLE DATA ciming daq
172; 4533903 TABLE DATA cimint daq
173; 4534290 TABLE DATA intezkedok daq
174; 4534534 TABLE DATA help daq
175; 4534545 TABLE DATA vvip daq
94; 1681205 INDEX "cimfh_fszam" postgres
99; 4253736 INDEX "utca_utcakod_key" daq
101; 4262531 INDEX "folyo_vkod_key" daq
95; 4424095 INDEX "cimvevo_fszam_key" daq
96; 4444652 INDEX "fhely_fhseq_key" daq
98; 4484993 INDEX "vevo_vseq_key" daq
100; 4505662 INDEX "vevo_vkod_ind" daq
103; 4505663 INDEX "fhely_vkod_ind" daq
104; 4505664 INDEX "fhely_fhszam_ind" daq
105; 4505665 INDEX "fhely_fhtuln_ind" daq
93; 4505697 INDEX "fhely_fhtuln_fhszam_ind" daq
97; 4525366 INDEX "vevo_vnev1_ind" daq
102; 4525432 INDEX "probaindex" daq
106; 4534577 INDEX "vizmero_fhszam_ind" postgres
107; 4534578 INDEX "vevohist_vkod_ind" daq
108; 4534579 INDEX "fhelyhist_fhszam_ind" daq
176; 4505667 TRIGGER fhely_update daq
177; 4505676 TRIGGER fhely_insert daq
178; 4525437 TRIGGER vevo_update daq
179; 4525445 TRIGGER vevo_insert daq
3; 4251571 SEQUENCE SET varos_varoskod_seq
6; 4253725 SEQUENCE SET utca_seq
9; 4253732 SEQUENCE SET utca_utcakod_seq
12; 4444648 SEQUENCE SET fhely_fhseq_seq
15; 4484986 SEQUENCE SET vevo_vseq_seq
18; 4534532 SEQUENCE SET help_helpkod_seq
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
