From: | Jeff Davis <list-pgsql-general(at)dynworks(dot)com> |
---|---|
To: | Chris Lee <Chrislee(at)centurycity(dot)com(dot)hk> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: 7.2 Upgrade problems: Cannot restore from pg_dumpall |
Date: | 2002-02-08 07:15:37 |
Message-ID: | 200202080718.XAA25746@mail.ucsd.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> CREATE DATABASE
> psql:/tmp/pg_dump.bak:473: \connect: FATAL 1: Database "chinese" does not
> exist in the system catalog.
> copying template1 to template0... ok
>
> Here is the content of pg_dump.bak
>
> 471 \connect template1 postgres
> 472 CREATE DATABASE "Chinese" WITH TEMPLATE = template0 ENCODING =
> 'EUC_TW'; 473 \connect Chinese postgres
It looks like you're running into a problem with case sensitivity. I guess it
might also be a problem with pg_dump, since you used it directly. I think the
solution is to use quotation marks around the word "Chinese" in the connect
statement.
\connect Chinese postgres => \connect "Chinese" postgres
Hope it helps. I wonder what's up with pg_dump though... It seems like a bad
idea to use any capital letters for any identifiers in postgresql because
postgresql handles them so awkwardly.
Regards,
Jeff
From | Date | Subject | |
---|---|---|---|
Next Message | Arsalan Zaidi | 2002-02-08 07:27:26 | Re: Build problems with 7.2 |
Previous Message | Chris Lee | 2002-02-08 06:32:52 | 7.2 Upgrade problems: Cannot restore from pg_dumpall |