| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Naomi Walker <nwalker(at)eldocomp(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>, William Bloom <wbloom(at)eldocomp(dot)com> |
| Subject: | Re: Upgrading from 7.4 to 8.1 |
| Date: | 2006-08-31 03:26:26 |
| Message-ID: | 20060831032626.GM22618@alvh.no-ip.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Naomi Walker wrote:
> We are preparing to upgrade to 8.1 from 7.4 Postrgres. In this case, it is a Red Hat
> Linux server. Using the 8.1.4 pg_dumpall, pointed at the 7.4 instance, we get the
> following errors.
What are the exact options? I tried to reproduce it here, using a 8.1
and 8.2 pg_dumpall, and a 7.4 server, and couldn't.
> CREATE ROLE "";
> ALTER ROLE "" WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
This is weird anyway -- do you really have a role named "" (empty
string)?
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | RW | 2006-08-31 08:25:44 | Re: pg_dump: schema with OID 16396 does not exist |
| Previous Message | Naomi Walker | 2006-08-30 23:44:32 | Upgrading from 7.4 to 8.1 |