Postgres Pro
Downloads
Home   >   mailing lists

CREATE ROLE and pg_dump - Mailing list pgsql-novice

From kmh496
Subject CREATE ROLE and pg_dump
Date
Msg-id 1149858343.8864.6.camel@var.sirfsup.com
Whole thread Raw
Responses Re: CREATE ROLE and pg_dump  (Adam Witney <awitney@sgul.ac.uk>)
List pgsql-novice
Tree view 
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>.

pgsql-novice by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: Art of SQL - Sample Chapter
Next
From: Adam Witney
Date:
Subject: Re: CREATE ROLE and pg_dump