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
