Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Upgrading from 7.4 to 8.1
- 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: Wed, 30 Aug 2006 23:26:26 -0400
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.
- Follow-Ups:
- Re: Upgrading from 7.4 to 8.1
- From: Tom Lane
- Re: Upgrading from 7.4 to 8.1
- References:
- Upgrading from 7.4 to 8.1
- From: Naomi Walker
- Upgrading from 7.4 to 8.1
- Prev by Date: Upgrading from 7.4 to 8.1
- Next by Date: Re: pg_dump: schema with OID 16396 does not exist
- Previous by thread: Upgrading from 7.4 to 8.1
- Next by thread: Re: Upgrading from 7.4 to 8.1
- Indexes: