[Chasers-general] Install Errors

[Joseph C. <jos...@gm...>]

I am trying to set this up on a development maching.
I tested the install of the web\database server setup with 2 different CMS's
and it does work.
WinXP sp2
apache 2.2
php5
activestate tcl 8.4.19.1
postgresql 8.3.7.1
phppgadmin 4.2

Following the instructions in Install.txt and install.db.sql, I manually
setup the database name (chaser), user (postgres) and password then i ran:

psql -U postgres chasers
entered password when it prompted
\i install.db.sql

the sql script ran for a few then it error'd out, with the following:

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrator>cd
C:\Webserver\htdocs\chasers\database\
pg\client


C:\Webserver\htdocs\chasers\database\pg\client>psql -U postgres chaser
Password for user postgres:
Welcome to psql 8.3.7, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

Warning: Console code page (437) differs from Windows code page (1252)
         8-bit characters might not work correctly. See psql reference
         page "Notes for Windows users" for details.

chaser=# \i install.db.sql
  oid
-------
 16386
(1 row)

  oid
-------
 16384
 16396
(2 rows)

psql:install.db.sql:45: ERROR:  function "plpgsql_call_handler" already
exists w
ith same argument types
psql:install.db.sql:46: ERROR:  language "plpgsql" already exists
  oid
-------
 16399
(1 row)

  oid
-------
 16398
 16397
(2 rows)

psql:install.db.sql:60: ERROR:  function "pltclu_call_handler" already
exists wi
th same argument types
psql:install.db.sql:61: ERROR:  language "pltclu" already exists
psql:install.db.sql:67: ERROR:  function "pgmail" already exists with same
argum
ent types
  oid
-------
 16403
(1 row)

  oid
-------
 16402
 16401
(2 rows)

psql:install.db.sql:72: ERROR:  function "pltcl_call_handler" already exists
wit
h same argument types
psql:install.db.sql:73: ERROR:  language "pltcl" already exists
SET
psql:install.db.sql:84: ERROR:  function "levenshtein" already exists with
same
argument types
psql:install.db.sql:89: ERROR:  function "metaphone" already exists with
same ar
gument types
psql:install.db.sql:93: ERROR:  function "soundex" already exists with same
argu
ment types
psql:install.db.sql:97: ERROR:  function "text_soundex" already exists with
same
 argument types
psql:install.db.sql:111: ERROR:  could not access file "$libdir/table_log":
No s
uch file or directory
psql:install.db.sql:114: ERROR:  could not access file "$libdir/table_log":
No s
uch file or directory
psql:install.db.sql:117: ERROR:  could not access file "$libdir/table_log":
No s
uch file or directory
psql:install.db.sql:120: ERROR:  could not access file "$libdir/table_log":
No s
uch file or directory
psql:install.db.sql:123: ERROR:  could not access file "$libdir/table_log":
No s
uch file or directory
chaser=#

_______________________________________________________________
It seems that only the last 5 errors are important, with the others being
warnings
about data that already exists.

(note: i had to install activestate tcl, due to the pltcl language not being
installed)

Now this is my 5th attempt installing this, with the other attempts i did
the same
steps except used "chasers" as the DB name. On each attempt I would drop the

database and create a new one.

I would normally install this on a debian lamps at home, my database
experience is with MySQL.
So the only extra box that i have running where I am at is a WinXP SP2 unit
that
I installed this on, at my current location I only have access to the
internet via
a data card (verizon) and i can not get to debian. But this should work
regardless of the
operating system. shouldn't it?

I have a feeling that this is a user (me) error since this is my first time
using postgresql.

I am wanting to just get it up and running and play with it and see what i
need to change
to suit my needs with a shelter that I am going to open up in central europe
and louisiana, in
which DESC line of work and mine (human trafficking) are very much the same.
Thanks for any help you can give.
-- 
Joseph S. Carr