I tried countless ways to try to restore data only for all tables using the -a switch. None seem to work. I was able to restore data only for specific tables using the -t switch, but I was expecting that I should be able to invoke a command with -a that checks all tables and restores all data appropriately. Here's the last thing I tried.
bash-2.03$ pg_restore -c -a -d [dbname] ../data/backups/[-Fc Archive] pg_restore: [archiver (db)] error returned by PQputline Any ideas?? Thanks, Gary ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly