Nik wrote:
The reason I am running pg_dumpall is that I would like to create an
exact copy of my database on another server. I cannot use create
database with template command since there are connections to the
original database. The dumpall method seems somewhat cumbersome since
it generates on
PostgreSQL 8.1.3 on Windows 2003 Server.
I am running pg_dumpall on my cluster that is about 500Gb in size. The
dump started ok, but then it gets to a table that's about 160Mb in
size with a 100Mb of indexes and it seems stuck. The dump file is
getting larger, but the dump is not finishing this ta
