Next: Elephant on Windows, Previous: CL-SQL, Up: Installation
To set up a PostGres based back end, you should:
(defvar *testpg-path* '(:postgreql "localhost.localdomain" "test" "postgres" ""))
which means that connections must be allowed to the database test, user “postgres”, no password, connected from the same machine “localhost.localdomain”. (This would be changed to something more secure in a real application.) Typically you edit the file : pg_hba.conf to enable various kinds of connections in postgres.
psql -h 127.0.0.1 -U postgres test
before you attempt to connect with Elephant.
Furthermore, you must grant practically all creation/read/write privileges to the user postgres on this schema, so that it can construct the tables it needs.
Upon first opening a CL-SQL based store controller, the tables, indexes, sequences, and so on needed by the Elephant system will be created in the schema named “test” automatically.