| 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: | Whole Thread | Raw Message | 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
| 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 |