pg_dumpall

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.

Responses

Browse pgsql-admin by date

  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???