Dne 26.4.2011 14:41, Phoenix Kiula napsal(a): > On Tue, Apr 26, 2011 at 3:24 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: >> Are you sure you're getting all the data out of the source (broken) >> database you think you are? Are you sure those rows are in the dump? > > > > Actually I am not. Some rows are missing. > > Will a COUNT(*) on the two databases -- old and new -- be sufficient > and reliable information about the number of rows that went AWOL? That should give us at least some idea if the copy worked. Have you checked the postmaster.log (and kernel log in /var/log/messages) why the new DB crashed when you do "SELECT * FROM mytable LIMIT 1" (as TL recommended yesterday)? Tomas -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
