Re: CREATE ROLE and pg_dump

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.