[rt-users] Problems with PostgreSQL

[Jesse]

If I recall correctly, DBD::Pg will always try TCP if host= is in the DSN.
if you leave it out, it should use unix sockets.



On Wed, Jun 20, 2001 at 12:07:07PM -0400, Damian Gerow wrote:
> > 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
> >
> 
> 
> _______________________________________________
> 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

I have images of Marc in well worn combat fatigues, covered in mud, 
sweat and blood, knife in one hand and PSION int he other, being 
restrained by several other people, screaming "Let me at it! 
Just let me at it!"  Eichin standing calmly by with something 
automated, milspec, and likely recoilless.
				-xiphmont on opensource peer review