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
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 |