Problem in restoring 7.3.4 dump script to 7.4b3 - Mailing list pgsql-admin

From
Subject Problem in restoring 7.3.4 dump script to 7.4b3
Date
Msg-id 34631.203.145.130.142.1064201409.squirrel@mail.trade-india.com
Whole thread Raw
List 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/



pgsql-admin by date:

Previous
From: "yuanlin"
Date:
Subject: unsubsribe pgsql-admin
Next
From: shyamperi@davlin.co.in
Date:
Subject: error with functions