I am upgrading from 8.0.3 to 8.1 and so i did a pg_dump -d dbname >
dump.sql then did a "cat dump.sql | psql -d dbname"
but there are errors such as this one:
ERROR: role "joe" does not exist
ERROR: role "joe" does not exist
ERROR: role "joe" does not exist
ERROR: role "joe" does not exist
ERROR: role "joe" does not exist
ERROR: role "joe" does not exist
ERROR: role "joe" does not exist
is there no flag to pg_dump to tell it to dump the create user
statements as well?
thanks.
is there a way to get users dumped as well?
--
<a href="http://openandout.com/~jcs/">who am I?</a>.