Re: pg_dump --comment? - Mailing list pgsql-hackers

From Harald Fuchs
Subject Re: pg_dump --comment?
Date
Msg-id puoeo34s1t.fsf@srv.protecting.net
Whole thread Raw
In response to pg_dump --comment?  (Chris Campbell <chris@bignerdranch.com>)
List pgsql-hackers
In article <40BBBC40.3040804@bignerdranch.com>,
Chris Campbell <chris@bignerdranch.com> writes:

> Harald Fuchs wrote:
>> Why don't you just do
>> ( echo "-- This is my comment"
>> pg_dump whatever
>> ) > dumpfile
>> ?

> How could I dump using the custom format, and then use "dumpfile" with
> pg_restore to restore the dump? If I just prepend the comment to the
> file, then pg_restore will choke, since the file won't be in the
> proper custom format. I would have to remove the comment before
> sending the file to pg_restore. Is there an easy way to do that? That
> can be easily automated, and not take a huge amount of time given a 4
> gig dump file that must be modified?

Since pg_restore is able to read from standard input, that should not
be a problem: instead of
 pg_restore options dumpfile

just do
 sed 1d dumpfile | pg_restore options



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Fast index build vs. PITR
Next
From: Shridhar Daithankar
Date:
Subject: Re: Converting postgresql.conf parameters to kilobytes