kmh496 wrote:
> 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?
I think you have to use pg_dumpall to dump users as well
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.