7.2.2 upgrade, pg_dumpall / reload problem

From: Adam Witney <awitney(at)sghms(dot)ac(dot)uk>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: 7.2.2 upgrade, pg_dumpall / reload problem
Date: 2002-09-10 08:08:57
Message-ID: B9A36729.75EE%a.witney@sghms.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I just upgraded from 7.2 to 7.2.2 using Mark Liyanage's prebuilt MacOSX 10.2
package

http://www.entropy.ch/software/macosx/postgresql/

I followed the instructions to first use pg_dumpall to dump all the data,
then upgraded and restarted the server. However when I try to reload the
data I get an error

[mrc1-003:/usr/local/pgsql] postgres% ./bin/psql -f /tmp/postgresql.dump
template1
You are now connected to database template1.
DELETE 0
CREATE USER
CREATE USER
DELETE 0
CREATE GROUP
ALTER GROUP
ALTER GROUP
You are now connected to database template1 as user admin.
CREATE DATABASE
FATAL 1: Database "bugasbase" does not exist in the system catalog.
psql:/tmp/postgresql.dump:21: \connect: FATAL 1: Database "bugasbase" does
not exist in the system catalog.

I have a database called BugasBase.... However this seems to be trying to
find bugasbase

Any help would be most appreciated

Thanks

adam

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alex Ott 2002-09-10 09:21:35 how can i get free space for database?
Previous Message Marc G. Fournier 2002-09-10 03:44:02 pgsql-performance mailing list / newsgroup created