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/ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster