Problem in restoring 7.3.4 dump script to 7.4b3

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/

Browse pgsql-admin by date

  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