"Guo, Yun" <YGuo@xxxxxxxxx> writes: > Is there a way to repair the database if it's corrupted? There's no evidence here that you've got any server-side corruption. pg_dump should be getting back the exact same results you got manually. (BTW, I assume you've ruled out the possibility that pg_dump is connecting to some other server or database than the one you're looking at manually...) regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin