Hi everyone, I have successfully been doing text based backups and restores to a few servers for reporting and testing purposes for a few years now. Due to growth in the database I am switching to the native format backup and using pg_restore to restore the database. The problem I've run into is that at least one table is inaccessible after the restore finishes. Any queries to that table just hang. Other tables seem to work ok. I have no idea why. Here's my backup command: /usr/bin/pg_dump -U postgres rms-prod -F c -f $WALPATH/rms-prod.pgc Here's my restore command: pg_restore -v -U postgres -h $PGHOST --exit-on-error -d rms-prod $WALPATH/rms-prod.pgc However, when I do a text based backup and subsequent restore, everything works just fine. I'm currently running 8.3.7 on all my servers. Thanks for the help. Scot Kreienkamp skreien@xxxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
