Hello:
I'm having problems with restoring database. I'm using PostgreSQL 7.0.3 on
Solaris 2.6 on a Sparc machine.
The database contains large tables, the largest contains 1,5 million rows.
While pg_dump is quite quick, restore takes ages. Situation improves if I
split the dump file into smaller chunks, so no COPY command has more than
10000 lines of data following. Then restore is faster, it takes "only"
about 4 hours.
I also tried to restore the database on another machine (Pentium II)
with RedHat 7.0, and it took only about 5 minutes - without splitting the
file into smaller chunks.
Any ideas where the problem might be?
Thanks in advance,
Ales Pecnik