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 table. I understand that it takes a long time to do that, and that the dump file will be larger than the table+index, but the file size seems a bit excessive for that table alone. The file is about 22Gb already and it keeps increasing. Is this normal? 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 only one file that is huge. Is there another way I could do this that would be faster, more reliable, and elegant? Could I start archiving the logs for the original database and then do the pitr on another machine using that backup and logs? Thank you.
