Re: Upgrading from 7.4 to 8.1

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.