[rt-users] Problems with PostgreSQL

[Damian Gerow]

> What version of postgres? Who built it? Are you sure it's set up properly?

I've re-installed postgres, (I built it), and I'm pretty sure it's built
properly.

The error I'm getting is (on a 'make install'):
	Now creating a database for RT.
	Enter the Pg password for postgres:
	Creating Pg database rt2.
	DBI->connect(dbname=template1;host=localhost) failed: connectDBStart() --
connect() failed: Connection refused at
/usr/lib/perl5/site_perl/5.6.1/DBIx/DataSource/Driver.pm line 74
	connectDBStart() -- connect() failed: Connection refused at
/usr/lib/perl5/site_perl/5.6.1/DBIx/DataSource/Driver.pm line 74, <STDIN>
line 1.


Which translates to:
	my $dbh = DBI->connect( $new_dsn, $user, $pass ) or die $DBI::errstr;
in that file.


The error occurs in tools/initdb, in sub create_db, on line 197:
	create_database( $dsn, $DB_DBA, $DB_DBA_PASSWORD ) or die
$DBIx::DataSource::errstr;

I _know_ it's a connection error, and I'm not using tcpip sockets, yet I've
got the Unix domain socket in /tmp (as per the default install).  Do I need
to enable network access to the machine?  Should I move the domain socket
somewhere else?

(And how exactly does perl know where to find the domain socket?)

>
>
> Postgres generally needs more care
> and feeding than mysql.  If you're a DB newbie, mysql will likely be less
> painful for you than postgres.
>
>
> On Tue, Jun 19, 2001 at 08:00:51PM -0400, Damian Gerow wrote:
> > I've got a small problem when installing RT-1-3-104 on a PostgreSQL
> > database.
> >
> > Just installing PostgreSQL (no config), I couldn't contact the database.
> > Fine.  Find the config file, tell PostgreSQL to use tcpip sockets.
> >
> > Now, when installing RT, it just hangs at "Creating Pg database
> for rt2.",
> > right after asking me for the postgres user password.  Has anyone come
> > across this?
> >
> > Note: when I installed DBD:Pg, it wanted the user "pg", and not
> "postgres".
> > I played for a half hour trying to get it to use postgres, but
> couldn't, so
> > just forced an install.  Could this have caused a problem?
> >
> >
> > _______________________________________________
> > rt-users mailing list
> > rt-users at lists.fsck.com
> > http://lists.fsck.com/mailman/listinfo/rt-users
> >
>
> --
> jesse reed vincent -- root at eruditorum.org -- jesse at fsck.com
> 70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90
>
> As I sit here alone looking at green text on a laptop in a mostly
> bare room listening
> to loud music wearing all black, I realize that that it is much
> less cool in real life :)
> 			--Richard Tibbetts
>
>
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
>