How to install with Postgres

[pixbuf]

Hello, I want to install phpScheduleIt on a system that already has postgres installed. I tried using the automatic install, but it failed, saying it couldn't connect to the database. I'm going to try the manual install, but since the accounting system for our business also runs on the postgres server, I'm wary of trying anything that could wipe out the business. 

Can anyone give me some some concrete hints for a *safe* install?

Thanks.

(I'm running postgres 8.0.15 on a Gentoo Linux system with apache 2.2.9 and php 5.2.8 )

[Nick]

Running the manual install will create a new database called phpScheduleIt (by default), so there should be no impact to other databases on the server.  As always, I'd do a backup of existing data as a precaution.

If you can, I'd try a test run on an isolated Postgres server to work out any kinks.

[pixbuf]

I decided to take the plunge. I created a database user, scheduleit. I created the user with no password, so I put in config.php this line:
$conf['db']['dbPass'] = '';
Is that right?

Then I tried this:
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.

I'm stuck. It appears that the setup script creates the database. I don't know why it should complain like this. Help, please?

[pixbuf]

Since it keeps complaining that the database doesn't exist, I tried creating it:

$ 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

This is very frustrating.

[gerg]

Can't you just bypass the setup/install and run an sql query of the supplied sql and then adjust your config.php properly, load up the files and go from there?