Re: pg_dumpall

On Wed, 19 Feb 2003, Donald Fraser wrote:

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

I'd guess not, because the objects you copied from template1 when making
the database are part of the dumpall output. If you made it from
template1 after the backup you'd get anything that was in the new
template1 plus all of the old objects.