| From: | "Thomas T(dot) Thai" <tom(at)minnesota(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Trouble Restore With Large Objects |
| Date: | 2002-12-21 17:45:07 |
| Message-ID: | 4417.63.226.186.156.1040492707.squirrel@mail.minnesota.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I'm moving from 7.2.3 to 7.3. I backed up everything and have restored
almost everything exept one database which has large objects.
The database with large objects was backed up using:
$ pg_dump -Ft -b phpads > phpads.pgsql.tar
I restored using:
$ pg_restore -d phpads phpads.pgsql.tar
pg_restore: NOTICE: TypeCreate: changing argument type of function
txtidx_in from OPAQUE to CSTRING
pg_restore: NOTICE: TypeCreate: changing argument type of function
txtidx_out from OPAQUE to txtidx
pg_restore: NOTICE: TypeCreate: changing return type of function
txtidx_in from OPAQUE to txtidx
pg_restore: NOTICE: TypeCreate: changing return type of function
txtidx_out from OPAQUE to CSTRING
pg_restore: NOTICE: TypeCreate: changing argument type of function
qtxt_in from OPAQUE to CSTRING
pg_restore: NOTICE: TypeCreate: changing argument type of function
qtxt_out from OPAQUE to query_txt
pg_restore: NOTICE: TypeCreate: changing return type of function qtxt_in
from OPAQUE to query_txt
pg_restore: NOTICE: TypeCreate: changing return type of function qtxt_out
from OPAQUE to CSTRING
pg_restore: NOTICE: TypeCreate: changing argument type of function
mqtxt_in from OPAQUE to CSTRING
pg_restore: [archiver (db)] could not execute query: ERROR: TypeCreate:
function qtxt_out(mquery_txt) does not exist
Function is from tsearch. At this point I've not loaded the tsearch.sql
functions into database phpads yet. So I drop phpads and start over:
$dropdb phpads
$psql phpads < /usr/local_install/postgresql-7.3/share/contrib/tsearch.sql
$pg_restore -d phpads phpads.pgsql.tar
pg_restore: [archiver (db)] could not execute query: ERROR: type txtidx
already exists
The trouble here is pg_dump should have just moved on with this type of
error instead of stop. That's what it does with a normal text restore.
Is there a way to restore this DB or back it up using an alternative
method and preserve the large objects?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-12-21 19:57:51 | Re: Unicode database + JDBC driver performance |
| Previous Message | Crercio O. Silva | 2002-12-21 17:20:57 | New DBManager Release |