> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Tuesday, June 22, 2010 2:41 PM
> To: Igor Neyman
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] parallel option in pg_restore
>
> "Igor Neyman" <ineyman@perceptron.com> writes:
> > Attached is script that could be used to pre-create "parent" tables
> > (from which partitions were inherited).
>
> Thanks. Now that I dig into it, it looks like the actual
> trigger for the problem is that pg_dump, not pg_restore,
> couldn't seek while it was creating the dump file --- so it
> didn't seek back and update the file's table-of-contents with
> exact dump offsets. What command did you use to create the
> dump file, exactly?
>
> regards, tom lane
>
>
Here is the backup script to backup all partitions for specific month
(200907) in one backup file:
SETLOCAL
set PGPASSFILE=%PGINSTALL%\DB_scripts\postgres.pgpass
SET PGBACKUPDRIVE=%PGBACKUP%
pg_dump -U vec_dba -F c -f
%PGBACKUPDRIVE%\PartitionedBackup\CM_200907.bac -v -Z 9 -t *200907
vector 2>> %PGBACKUPDRIVE%\Backup\Log\DB_Backup.log
ENDLOCAL
This script is a part of "bigger" backup, which backs up other
non-partitioned tables as well.
Regards,
Igor Neyman