PostgreSQL & RT2

Hi guys… I’m building a box with PostgreSQL and want to run RT on it… (I
have succesfully made & upgraded RT on a MySQL platform, so I figured my
life didn’t have enough drama, and I’d like to see how Postgres worked ;))

Anywho… I’ve installed postgresql, I have a user called “postgres” both in
my /etc/passwd and in the pg_passwd table “passwords” which is in use in
the pg_hba.conf file.

I make a testdeps, and everything says “Yay–you have it all!”

So when I do a make install:

su-2.05a$ make install
mkdir -p //sw/rt/bin
mkdir -p //sw/rt/WebRT/data
mkdir -p //sw/rt/WebRT/sessiondata
mkdir -p //sw/rt/etc
mkdir -p //sw/rt/lib
mkdir -p //sw/rt/WebRT/html
mkdir -p //sw/rt/local/WebRT/html
/usr/bin/perl tools/initdb ‘Pg’ ‘/usr’ ‘localhost’ ‘’ ‘postgres’ ‘rt2’ create
Now creating a database for RT.
Enter the Pg password for postgres:
Creating Pg database rt2.
DBI->connect(dbname=template1;host=localhost) failed: FATAL 1: user
“postgres” does not exist at
/usr/local/lib/perl5/site_perl/5.005/DBIx/DataSource/Driver.pm line 74
FATAL 1: user “postgres” does not exist at
/usr/local/lib/perl5/site_perl/5.005/DBIx/DataSource/Driver.pm line 74,
line 1.
*** Error code 255

I’ve searched the web, and the archives, to no avail. Is anyone else here
running postgres who can give me a hint as to what I’m doing wrong here? :frowning:

Thanks,
Glenn

Glenn E. Sieb See us at NetSec! June 18-19
System Administrator Hyatt Embarcadero, San Francisco
Lumeta Corporation FireMon Asset Manager | Cloud Visibility & Network Security Risk Management
+1 732 357-3514 (V)
+1 732 564-0731 (Fax)

postgres" does not exist at
/usr/local/lib/perl5/site_perl/5.005/DBIx/DataSource/Driver.pm line 74
FATAL 1: user “postgres” does not exist at
/usr/local/lib/perl5/site_perl/5.005/DBIx/DataSource/Driver.pm line 74,
line 1.
*** Error code 255

I’ve searched the web, and the archives, to no avail. Is anyone else here
running postgres who can give me a hint as to what I’m doing wrong here? :frowning:

Wild guess here but it seems its trying to log into your DB as the user
postgress. It needs to login as the root user (what ever postgress uses
for that account) in order to create the rt2 user and DB’s.

D’oh! My bad. Thanks for the pointer–I had the user created, and it
should have been able to do everything, but changing the user to the
postgres default user worked.

Thanks! :slight_smile:
Glenn

Glenn E. Sieb See us at NetSec! June 18-19
System Administrator Hyatt Embarcadero, San Francisco
Lumeta Corporation http://www.lumeta.com/Events/events.html
+1 732 357-3514 (V)
+1 732 564-0731 (Fax)

|+ I’ve searched the web, and the archives, to no avail. Is anyone else here
|+ running postgres who can give me a hint as to what I’m doing wrong here? :frowning:

What happens when you just trying doing psql -U postgres

-darrin