Reynard Hilman wrote:
> Hi,
>
> I'm trying to restore a dump file that I created using:
> pg_dump -CD dbname > dump.sql
>
> the dump file size is about 87 Mb.
>
> so I did this to restore:
> psql -f dump.sql -U user template1
>
> It takes almost an hour and a half to restore the database.
This there a reason you are using the 'D' option to dump the database
as INSERTs? A dump which uses COPY (the default) instead will reload
much more quickly.
Mike Mascari
mascarm(at)mascari(dot)com