From: | <mallah(at)trade-india(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Problem in restoring 7.3.4 dump script to 7.4b3 |
Date: | 2003-09-22 03:30:09 |
Message-ID: | 34631.203.145.130.142.1064201409.squirrel@mail.trade-india.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi ,
I made an attempt to dump and reload my 7.3.4 into 7.4b3 following were
the issues i faced , some solved and some unsolved. I used the piped method
for the data transfer , so its not possible to manually edit the sql script.
7.4b3 pg_dumpall and 7.4b3 psql was used for dumping and restore.
1. SET search_path = archives, pg_catalog;
SET
CREATE INDEX site_search_gist ON site_search USING gist (keywordidx);
ERROR: data type public.txtidx has no default operator class for access method "gist"
HINT: You must specify an operator class for the index or define a default operator class for the
data type.
if search path were archives,pg_catalog , public i beleive the problem would not
have been there.
2. SET search_path = sms, pg_catalog;
SET
SELECT pg_catalog.setval ('email_sms_queue_uniq_id_seq', 2690, true);
setval
--------
2690
(1 row)
SELECT pg_catalog.setval ('email_sms_alert_pref_uniq_id', 177, true);
setval
--------
177
(1 row)
SELECT pg_catalog.setval ('email_sms_transactions_tid_seq', 667, true);
ERROR: relation "email_sms_transactions_tid_seq" does not exist
Although email_sms_transactions_tid_seq exists in sms namespance.
as confirmed by :
tradein_clients=# SET search_path = sms;
SET
tradein_clients=# \ds *tran*
List of relations
Schema | Name | Type | Owner
--------+--------------------------------+----------+---------
sms | email_sms_transactions_tid_seq | sequence | tradein
(1 row)
tradein_clients=#
Issues that could be solved,
1. Improper ordering of some views , dependent views were dumped prior.
Workaround: both the views were droped, will be created post restoration.
Regds
Mallah.
-----------------------------------------
Over 1,00,000 exporters are waiting for your order! Click below to get
in touch with leading Indian exporters listed in the premier
trade directory Exporters Yellow Pages.
http://www.trade-india.com/dyn/gdh/eyp/
From | Date | Subject | |
---|---|---|---|
Next Message | shyamperi | 2003-09-22 04:22:27 | error with functions |
Previous Message | yuanlin | 2003-09-21 08:45:10 | unsubsribe pgsql-admin |