Re: Problems with sql-ledger/DBD-Pg installation

[Dr. R. J. M. <bo...@ho...>]

Andre,

Thank you for your response.  I hope that with the following and your
successful installation as reference you can help me solve my problem.

> Currently, sql-ledger only works with PostgreSQL (free open source also).
> DBD-Pg is an "interface" to PostgreSQL.

I am using PostgreSQL and DBD-Pg.

  ---- > rpm -qi postgres DBD-Pg | grep Version ----
Version : 6.5.1 Vendor: SuSE GmbH, Nuernberg, Germany
Version : 0.73  Vendor: (none)
  ---- > rpm -qi postgres DBD-Pg | grep Version ----

I created the ledgerdemo database for the sql-ledger installation.

  ---- > psql -l ----
datname   |datdba|encoding|datpath
----------+------+--------+----------
template1 |    26|       0|template1
ledgerdemo|    26|       0|ledgerdemo
(2 rows) 
  ---- > psql -l ----

  ---- > psql ledgerdemo ----
...
ledgerdemo=> select * from tax;
chart_id|rate|number
--------+----+------
   10067|0.07|
   10056|0.08|
(2 rows)
  ---- > psql ledgerdemo ----

I think that postgreSQL is listening, but I don't know the correct format.

  ---- > telnet localhost 5432 ----
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
SELECT * FROM tax;
Connection closed by foreign host.
  ---- > telnet localhost 5432 ----

Unfortunately, my reading of the data at http://www.postgresql.org/ has
not helped so far.

Thanks again in advance,
-- 
Dr. Robert J. Meier
Custom Tools
mailto:rob...@co...