CREATE ROLE and pg_dump

From: kmh496 <kmh496(at)kornet(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: CREATE ROLE and pg_dump
Date: 2006-06-09 13:05:42
Message-ID: 1149858343.8864.6.camel@var.sirfsup.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Adam Witney 2006-06-09 13:13:04 Re: CREATE ROLE and pg_dump
Previous Message Richard Broersma Jr 2006-06-08 17:19:22 Re: Art of SQL - Sample Chapter