Problems with PostgreSQL

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?

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

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@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

jesse reed vincent – root@eruditorum.orgjesse@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 :slight_smile:
–Richard Tibbetts

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

Latest version, downloaded last week. I built it. Not sure it’s set up
properly, should probably look into that.

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.

Unfortunately, the powers that be require postgres.

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,
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?)

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,
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@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users


jesse reed vincent – root@eruditorum.orgjesse@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 :slight_smile:
–Richard Tibbetts


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

jesse reed vincent – root@eruditorum.orgjesse@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