> Okay, I tried > >pg_dumpall > sync-up.db > Connected to template1... > Psql: FATAL 1: user "jcarlson" does not exist > > > I tried to use the -U option without success. How do I add a user ore > determine a user that will work for pg_dumpall I see, you are actually having a problem with pg_dumpall terminating unsuccessfully. You might want to forward this concern over to the pg_general mailing list. pgsql-general@xxxxxxxxxxxxxx There are more users on that list that will able to help you get around this problem. I am guessing that you may a record somewhere that may have been corrupted. It can be easy to correct with some help from more advanced Postgresql users. The help these users, turn on statement logging in your postgresql.conf and restart your server. email the list showing the issued command, error messages that result, and any logs snippets that were generated up to the failure. But just be prepared to for the first recommendation to move to postgresql 8.1 or eventually 8.2.
