Thread: CREATE ROLE and pg_dump

CREATE ROLE and pg_dump

From

kmh496

Date:

09 June 2006, 13:05:13

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>.

Re: CREATE ROLE and pg_dump

From

Adam Witney

Date:

09 June 2006, 13:12:54

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.