Heikki Linnakangas wrote: > Gary Chambers wrote: >> The following bug has been logged online: >> >> Bug reference: 3682 >> Logged by: Gary Chambers >> Email address: [EMAIL PROTECTED] >> PostgreSQL version: 8.3beta1 >> Operating system: Mac OS X 10.4.10 >> Description: Incomplete database restore >> Details: >> >> After dumping a database with pg_dump, then attempting to restore it, the >> restore fails with "invalid command \" error reports. >> >> Each individual database is dumped by: >> pg_dump --username=<owner> --file=<filename> > > We're going to need more details. How did you attempt to restore it? Can > you post the dump file?
(Gary sent me the dump off-list.) Ah, did you dump the database from an existing 8.2 installation? There's clauses in there to create Postgres 8.2 contrib/tsearch2 types and functions, which are no longer needed beacuse full-text search is now a core feature. I removed them by hand, and after that it works. We desperately need a migration guide for existing contrib/tsearch2 users... Andy and Tom just put together a script to help with that: http://archives.postgresql.org/pgsql-hackers/2007-10/msg00750.php Can you try that to see if it works? I also had to modify the two CREATE TABLE statements that contained a "public.tsvector" column; it's just "tsvector" now since it's now a built-in type. I'm not good at perl, but I believe the script doesn't do that yet. Note that you have to make a dump with pg_dump -Fc or -Ft option, the one you posted doesn't work with the script. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
