Hello, I'm trying to install phpScheduleIt (an on-line calendaring
application) on my system that has postgres 8.0.15 running. I have to
admit upfront that I have very little idea how postgres works; my
small-business accounting system uses it, but it's sort of like a black
box to me.
phpScheduleIt uses mySQL by default, but they claim is should work with
postgres. The setup uses a script that starts like this:
# phpScheduleIt 1.2.0 #
drop database if exists phpScheduleIt;
create database phpScheduleIt;
use phpScheduleIt;
The install docs say to do this, or the equivalent in the database
you're using:
mysql -u root -p < %path to directory%/install/setup.sql
First I did this:
su postgres
createuser -d scheduleit
That was fine. Then I tried to run the setup script, but with no
success:
$ psql -U scheduleit phpscheduleit < setup.sql
but got this message:
psql: FATAL: database "phpscheduleit" does not exist
I get the same message if I leave the name of the database out.
$ psql -c "create database phpScheduleIt;"
psql: FATAL: database "postgres" does not exist
$ psql -c "create database phpScheduleIt;" phpScheduleIt scheduleit
psql: FATAL: database "phpScheduleIt" does not exist
Pardon my ignorance, but I'd really appreciate it if someone could help
me out here.
--
Stuart Luppescu -=- slu .at. ccsr.uchicago.edu
University of Chicago -=- CCSR
才文と智奈美の父 -=- Kernel 2.6.25-gentoo-r7
Giles: (scoffs) Magic! Magic's all balderdash and
chicanery. I'm afraid we don't know a bloody
thing. (everyone looking at him) Except I seem to
be British, don't I? Uh, and a man. With ...
glasses. (removes glasses) Well, that narrows it
down considerably.