From: Scott Abel <sabel@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: pg_dump --create --schema-only, how to suppress template1 functions ?
Date: Mon, 17 Dec 2007 10:50:18 -0800
Message-ID: <c51a85180712171050j4e4ced30sfec6d6f9eb2b4371@mail.gmail.com> (raw)
I was using pg_dump --create --schema-only (or so I thought) to
maintain source files for my database that I could check into my
revision control system. Now I just tried to recreate the source file
from an updated version of the DB, and I'm finding that it dumps all
the built-in stuff from template1 (not stuff I added, AFAIK).
The last file I checked in used template1 in the "CREATE DATABASE"
statement and only had CREATE statements for functions and tables that
I created in my database. All the stuff from template1 was then
created implicitly by the template1 clause in the CREATE DATABASE
statement. This is exactly the behavior I want.
Here's the exact command line I used for 8.2.4 pg_dump in both cases
(unless I'm mistaken and somehow I ran a different version of my
script before):
pg_dump -U postgres -H myhost --create --schema-only --encoding=UTF8
--file=myoutputfile mydbname
Now when I try to run it (still with 8.2.4), the CREATE DATABASE
statement generated uses template0 and then pg_dump regurgitates every
function in my database, including those that came from template1. I
don't use most of the functions and don't want them generated in the
schema file; I really would like to figure out how to get back the old
behavior of pg_dump generating a CREATE DATABASE statement that uses
template1 as the template and only generates DDL for my tables and
functions. How do I do this?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: sabel@yahoo.com
Subject: Re: pg_dump --create --schema-only, how to suppress template1 functions ?
In-Reply-To: <c51a85180712171050j4e4ced30sfec6d6f9eb2b4371@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox