Re: pg_dump excluding tables content but not table schema

On 28/12/2009 20:20, Ivan Sergio Borgonovo wrote:
> On Mon, 28 Dec 2009 19:39:36 +0000
> Raymond O'Donnell <rod(at)iol(dot)ie> wrote:
>
>> On 28/12/2009 18:41, Ivan Sergio Borgonovo wrote:
>>
>>> I'd like to just dump the table schema without dumping the table
>>> contend.
>
>> pg_dump -s -t <table name> <db name>
>
> My fault. I was not clear enough.
> I'd like to make a "mostly" full backup, excluding from backup just
> the data of some tables but backing up the schema of those tables.
>
> mmm let me try if
>
> pg_dump -Fc -Z9 -s -t *.cache* -d mydb > schema_only.bak
> pg_dump -Fc -Z9 -T *.cache* -d mydb > nearly_full.bak
>
> cat nearly_full.bak schema_only.bak | pg_restore -1 -d mydb
>
> It seems it is working... I'll test if everything is there.

I don't think you can do it in one step with a single invocation of
pg_dump - I reckon what you've come up with there is the way to go.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie