[Gnumed-devel] (no subject)

[David Grant]

I'm an experienced Linux user and I know Python, but I'm a total 
postgresql newbie (and a newbie to all databases for that matter).

I installed postgresql and created a user named "david" and I created a 
database as that user, called "gnumed".  The database and user exist, as 
confirmed by webmin.  When I try to run "gnumed.py", I get the following 
error:

[PANIC] 
(/home/david/cvs/gnumed/gnumed/client/python-common/gmPG.py::run_query:547): 
query >>>select name from distributed_db;<<< failed
[PANIC] 
(/home/david/cvs/gnumed/gnumed/client/python-common/gmPG.py::run_query:547): 
exception type : libpq.OperationalError
[PANIC] 
(/home/david/cvs/gnumed/gnumed/client/python-common/gmPG.py::run_query:547): 
exception value: ERROR:  Relation "distributed_db" does not exist

[PANIC] 
(/home/david/cvs/gnumed/gnumed/client/python-common/gmPG.py::run_query:547): 
Traceback (most recent call last):<#10-0x0A-lf>
[PANIC] 
(/home/david/cvs/gnumed/gnumed/client/python-common/gmPG.py::run_query:547): 
  File "/home/david/cvs/gnumed/gnumed/client/python-common/gmPG.py", 
line 545, in run_query<#10-0x0A-lf>    aCursor.execute(aCmd)<#10-0x0A-lf>
[PANIC] 
(/home/david/cvs/gnumed/gnumed/client/python-common/gmPG.py::run_query:547): 
  File "/usr/lib/python2.2/site-packages/pyPgSQL/PgSQL.py", line 2956, 
in execute<#10-0x0A-lf>    raise OperationalError, msg<#10-0x0A-lf>
[PANIC] 
(/home/david/cvs/gnumed/gnumed/client/python-common/gmPG.py::run_query:547): 
OperationalError: ERROR:  Relation "distributed_db" does not 
exist<#10-0x0A-lf><#10-0x0A-lf>

I think I recognize "select name from distributed_db;" as some sort of 
SQL query...  Is my database not initialized properly?  By the way, 
what's the best way to clear my database and start over.  Can I just 
delete the /var/lib/postgresql/data directory?  Thanks.

Please CC any replies to address@hidden

David Grant