Postgres Pro
Downloads
Home   >   mailing lists

pg_dumpall - Mailing list pgsql-admin

From Donald Fraser
Subject pg_dumpall
Date
Msg-id 005401c2d84b$660fbf10$1664a8c0@DEMOLITION
Whole thread Raw
Responses Re: pg_dumpall
Re: pg_dumpall
List pgsql-admin
Tree view
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.
 

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: What is the datetime type equivalent from v7.0.2 to v7.3.1???
Next
From: Tom Lane
Date:
Subject: Re: How do I upgrade or coexist PostgreSQL on a Cobalt XTR system?