From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | <Martin_Hurst(at)dom(dot)com>, <pgsql-cygwin(at)postgresql(dot)org> |
Subject: | Re: PostgeSQL unable to restore database from previous version 7.2 to 7.3 |
Date: | 2002-12-18 22:59:26 |
Message-ID: | 03AF4E498C591348A42FC93DEA9661B8128DAE@mail.vale-housing.co.uk |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-cygwin |
> -----Original Message-----
> From: Martin_Hurst(at)dom(dot)com [mailto:Martin_Hurst(at)dom(dot)com]
> Sent: 18 December 2002 20:34
> To: pgsql-cygwin(at)postgresql(dot)org
> Subject: [CYGWIN] PostgeSQL unable to restore database from
> previous version 7.2 to 7.3
>
>
> I created the backup of the 7.2 database, removed the 7.2
> database, and installed the 7.3 database. When I try to
> restore into the new 7.3 version, I'm getting this message:
>
> ------------------------------------------------------
> $ psql < backup
> FATAL: Database "hurstm2" does not exist in the system catalog.
> psql: FATAL: Database "hurstm2" does not exist in the system catalog.
> ------------------------------------------------------
>
> The 7.3 Postgres was created in the eact same location as the
> 7.2 cluster. The user "hurstm2" issued the "initdb -D ..."
> command to created the cluster.
>
> So what would be causing this type of error message?
Your backup file is presumably a pg_dump of the hurstm2 database, rather
than a pg_dumpall dump of the whole cluster. This type of dump will not
contain the SQL to create the database. Try:
% createdb hurstm2
% psql -e hurstm2 < backup
Regards, Dave.
From | Date | Subject | |
---|---|---|---|
Next Message | King_Henree@yahoo.com | 2002-12-20 00:35:34 | How to separate data and index objects on different disks??? |
Previous Message | Martin_Hurst | 2002-12-18 20:44:11 | PostgeSQL unable to restore database from previous version 7.2 to 7.3 |