Hi Mark,
Did you recompile after changeing the config.h?
It looks like your dbmail is trying to connect through unix sockets in
stead of connecting through TCP/IP.
Eelco
Mark Mackay heeft op zaterdag, 10 aug 2002 om 05:01 (Europe/Amsterdam)
het volgende geschreven:
Hi there. I just hit the table limit of mysql (4G) so thought I'd try
postgresql first and see if it performs any better, etc. However I
can't
seem to get it going.
I've got two servers.
1) Dedicated postgresql
2) POP/IMAP Toaster
I can connect to the database using the psql command line utility from
the
toaster box, no problems. I've set up a simple trusted subnet, which
doesn't
require md5/ident authentication or anything.
pgsql -h dbmail-database -U dbmail dbmail
<works great>
However when I try using dbmail, it simply says can't connect see log.
Aug 10 15:00:07 dbmail-toaster1 dbmail/adduser[7409]: auth_connect():
PQconnectdb failed: could not connect to server: No such file or
directory ^IIs
the server running locally and accepting ^Iconnections on Unix domain
socket
"/tmp/.s.PGSQL.5432"?
I've changed the config.h to the relevant host, and can tcpdump and see
connections going there. I
I'm really new to postgres and don't know where to start looking
(though it
looks like a dbmail problem). I'd appreciate any help from anyone who
can
point me in the right direction.
Thanks in advance,
Mark.
PS. I've also got dbmail running with Mysql/Innodb and thought I'd try
postgres for comparison (debian ships with postgres, meaning I
wouldn't have
to worry about the upgrading the database software manually...).
Is there anyone who's tried both who can give recommendations?
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
__________________________
E.J.A. van Beek
ICT Manager
IC&S
T: +31 30 2322878
F: +31 30 2322305
PGP-key:
www.ic-s.nl/keys/eelco.txt
