From: | "Donald Fraser" <demolish(at)cwgsy(dot)net> |
---|---|
To: | "[ADMIN]" <pgsql-admin(at)postgresql(dot)org> |
Subject: | pg_dumpall |
Date: | 2003-02-19 19:16:21 |
Message-ID: | 005401c2d84b$660fbf10$1664a8c0@DEMOLITION |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
PostgreSQL 7.3.1 on i686-pc-linux-gnu, compiled by GCC 2.96
I issue the following command:
CREATE DATABASE "CISX" WITH OWNER = postgres TEMPLATE = template1 ENCODING = 'SQL_ASCII';
When I do a backup from the database using pg_dumpall (with no command line options) it creates the following:
CREATE DATABASE "CISX" WITH OWNER = postgres TEMPLATE = template0 ENCODING = 'SQL_ASCII';
I don't know whether this is a bug or not as I can't find any hard documentation to say otherwise?
There seems to be some kind of indication that this is the case for pg_dump but it's not clear.
Can someone clarify this, am I missing something obvious here?
If this is the case will there be a possible fix for this in the future?
Regards Donald Fraser.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-02-19 19:17:43 | Re: How do I upgrade or coexist PostgreSQL on a Cobalt XTR system? |
Previous Message | Tom Lane | 2003-02-19 19:09:44 | Re: What is the datetime type equivalent from v7.0.2 to v7.3.1??? |