incomplete 7.1.3 update and phpPgAdmin

From: rcaban(at)ccc-cable(dot)net (roy cabaniss)
To: pgsql-general(at)postgresql(dot)org
Subject: incomplete 7.1.3 update and phpPgAdmin
Date: 2001-11-21 18:47:49
Message-ID: 3d76261.0111211047.511e15da@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I was using SuSE 7.2 with Postgresql 7.0.3. I had decided to upgrade
to 7.1.3 so I did a

pg_dumpall > db.out

to capture the old database files.

I went through the update procedure via the SuSe install (yast) and
things looked ok.

to get my data back I did a

psql -d template1 -f db.out

Now... it did restore my extant databases. And the forms I used for
data input work fine for putting data into those databases.

but when I try to create a database or use phpPgAdmin I get the
following error message.

Error - /usr/local/httpd/htdocs/phpPgAdmin/db_create.php

PostgreSQL said: ERROR: CREATE DATABASE: source database "template1"
is being accessed by other users

this occurs regardless of which account I log into phpPhAdmin as.

ideas?

Roy Cabaniss

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Randal L. Schwartz 2001-11-21 18:52:52 Re: Slightly OT: outer joins
Previous Message J Smith 2001-11-21 18:45:33 Re: PG vs MySQL