| 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: | Whole Thread | Raw Message | 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 |