[Tutor] Python + PostGreSQL

[Srinivas Iyyer]

Thanks Bill, and wesley, 
Psycopg worked for me.  I had to use setup.cfg .
Regular setup.py did not work. 

AFA, pygresql I did used this some 2 years back. 
However, the install was pretty easy due to proper
redhat rpm updates. I felt more comfortable with
PyGreSQL. I liked it somehow. 

tar -xvf PyGreSQL.tar
cd PyGreSQL-3.8/
sudo python setup.py build
sh: pg_config: command not found
Traceback (most recent call last):
  File "setup.py", line 77, in ?
    pg_include_dir = pg_config('includedir')
  File "setup.py", line 47, in pg_config
    raise Exception, "pg_config tool is not
available."
Exception: pg_config tool is not available.

 

My pg_config is in : /usr/local/pgsql/bin/pg_config


thanks
Srini



--- w chun <wescpy at gmail.com> wrote:

> > >I tried to install pygresql: version: 3.8, it
> failed
> > >throwing exception : Exception: pg_config tool is
> not
> > >available.
> > >
> > >I gave another try on google and Postgres site
> and
> > >found Pypgsql, PoPy and psycopg1.
> >
> > I think that psycopg is generally considered the
> preferred
> > package.
> 
> 
> as bill has suggested, it does appear that psycopg
> is the preferred
> from what i've seen. popy is outdated and (i
> believe) merged with
> PyGreSQL which is the one that PostgreSQL has in
> their tree as it's
> been around the longest.
> 
> however rather than just talking about another
> adapter because your
> current one doesn't work, i'm more curious as to why
> you are having
> problems with PyGreSQL.  i've never had a problem
> with it... how did
> you do your installation?  (yes, we're lucky that
> PostgreSQL has
> multiple adapters available as other RDBMSs don't
> have these options.)
> 
> --wesley
> - - - - - - - - - - - - - - - - - - - - - - - - - -
> - - - -
> "Core Python Programming", Prentice Hall,
> (c)2007,2001
>     http://corepython.com
> 
> wesley.j.chun :: wescpy-at-gmail.com
> cyberweb.consulting : silicon valley, ca
> http://cyberwebconsulting.com
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com