<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.3.2">
</HEAD>
<BODY>
On Fri, 2007-03-23 at 10:28 +0100, Edi Weitz wrote:<BR>
<BLOCKQUOTE TYPE=CITE>
<TT><FONT COLOR="#000000">(DO-BACKEND-TESTS (QUOTE (:CLSQL (:POSTGRESQL NIL "elephant" NIL NIL))))</FONT></TT><BR>
<BR>
</BLOCKQUOTE>
<BR>
This doesn't look like a good connect string to me.<BR>
This may be an example where better documentation would help us.<BR>
<BR>
The best documentation on this right now is Ian's "INSTALL" file, which I condense here:<BR>
<BR>
if you are using CL-SQL, type:<BR>
(asdf:operate 'asdf:load-op :ele-clsql)<BR>
<BR>
(asdf:operate 'asdf:load-op :elephant-tests)<BR>
(in-package :ele-tests)<BR>
(setf *default-spec* *testpg-spec*)<BR>
<BR>
<BR>
Of course you don't have to use the default *testpg-spc*, which will change when building<BR>
an application, but it is probably the best way to test.<BR>
<BR>
Create a postgres database schema accessible by user "postgres" named "test".<BR>
Normally you just do this with:<BR>
<BR>
create_db test<BR>
<BR>
(I do this logged in as the Linux user "postgres", the user that is create specifically to <BR>
run the "postmaster".)<BR>
<BR>
Make sure user "postgres" can reach it by connecting with the psql command-lin interpreter:<BR>
<BR>
psql -h 127.0.0.1 -U postgres test<BR>
<BR>
Then a "spec" that looks like this should work:<BR>
<BR>
<BR>
'(:CLSQL (:POSTGRESQL "localhost.localdomain" "test" "postgres" ""))<BR>
<BR>
Let me know if that makes a difference!<BR>
<BR>
</BODY>
</HTML>