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?
