relation tmp_pg_shadow already exists

Поиск
Список
Период
Сортировка
От Ben Kim
Тема relation tmp_pg_shadow already exists
Дата
Msg-id Pine.GSO.4.10.10501310958030.11750-100000@edsun.coe.tamu.edu
обсуждение исходный текст
Ответы Re: relation tmp_pg_shadow already exists  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Operating System: Fedora core 1
From: postgresql 7.2 database
To: postgresql 7.3 database

I'm trying to restore a tar dump of postgresql 7.2 databases into a 7.3
server. I have two databases (db1,db2) both containing binary data. The
tar was dumped with the following command:

    pg_dump -C -b -F t -i db1.tar db1

The first one was restored OK. But on the second one,

    pg_restore -d db2 db2.tar

gives me this error.
=======================
$ pg_restore -v -d db2 db2.tar
pg_restore: connecting to database for restore
pg_restore: creating TABLE tmp_pg_shadow
pg_restore: connecting to database db2 as user u2
pg_restore: [archiver (db)] could not execute query: ERROR:  Relation
'tmp_pg_shadow' already exists
pg_restore: *** aborted because of error

These are the lines containing this table name from restore.sql within the
dump tarball.
=======================
$grep tmp_pg restore.sql
DROP TABLE "".tmp_pg_shadow;
-- Name: tmp_pg_shadow; Type: TABLE; Schema: ; Owner: u2
CREATE TABLE tmp_pg_shadow (
    datdba integer
);
-- Name: tmp_pg_shadow; Type: TABLE DATA; Schema: ; Owner: u2
COPY tmp_pg_shadow (datdba) FROM stdin;
copy tmp_pg_shadow (datdba)  from '$$PATH$$/75.dat' ;


I found 2 questions regarding this problem from my google search, both of
them unanswered, but hope there's a way to circumvent this error, and
would appreciate any help.


Regards,

Ben Kim
Database Developer/Systems Administrator
434E Harrington Tower / College of Education
Texas A&M University



В списке pgsql-admin по дате отправления:

Предыдущее
От: Brandon Metcalf
Дата:
Сообщение: corrupt table
Следующее
От: Tom Lane
Дата:
Сообщение: Re: relation tmp_pg_shadow already exists