From: | Adam Witney <awitney(at)sgul(dot)ac(dot)uk> |
---|---|
To: | kmh496 <kmh496(at)kornet(dot)net> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: CREATE ROLE and pg_dump |
Date: | 2006-06-09 13:13:04 |
Message-ID: | 448973E0.2090705@sgul.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Allison | 2006-06-09 23:44:33 | iowait |
Previous Message | kmh496 | 2006-06-09 13:05:42 | CREATE ROLE and pg_dump |