[rt-users] Problem Connecting to PostgreSQL

[Thompson, Jimi]

Hi,
 
I'm trying to configure this to use an existing PostgreSQL instance on
another machine.  I've completely blown out the pg_hba.conf on the
database server to allow the RT scripts to do basically anything even
without authentication.  This is the line I added to the pg_hba.conf
 
host    all         all         XXX.XXX.XXX.XXX    255.255.255.0
trust
 
I've hupped the Postgresql/postmaster process and verified that other
machines are able to connect to the same Postgresql instance via the
network.  Since everything else is connecting fine. I'm suspecting that
there is some other problem.
 
All is well until I run the make-initialize-database command.  

In order to create or update your RT database,this script needs to
connect to your Pg instance on server.somewhere.com as pgsql.
Please specify that user's database password below. If the user has no
database
password, just press return.
 
Password: 
Now creating a database for RT.
Creating Pg database rt-test.
DBD::Pg::db do failed: ERROR:  parser: parse error at or near "-" at
character 19
DBD::Pg::db do failed: ERROR:  parser: parse error at or near "-" at
character 19
ERROR:  parser: parse error at or near "-" at character 19
*** Error code 36

 
My question is this.  Can someone just supply me with the SQL script to
create the database?  I've seen where it's trying to connect (in
previous attempts) and is unable to do and it appears to be an
authentication issue.  I've even tried running the script as the
PostgreSQL user and am still getting the same error message.  If anyone
has ideas, I'd be happy to hear them.
 
Thanks,
 
Jimi
 
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20050302/6d9292c2/attachment.htm>