windows & linux (centOS/ubuntu) 下 PostgreSQL安装 python php 连接 PostgreSQL

win :

下载：  psycopg2-2.4.2.win-amd64-py2.7-pg9.0.4-release.exe

下载地址 ：http://vdisk.weibo.com/s/Cd8pPaw56Ozys

或者

下载 psycopg2-2.5.2.win-amd64-py2.7-pg9.2.6-release.exe

可在 http://www.stickpeople.com/projects/python/win-psycopg/ 下选择版本

python连接

 try:
                            conn=psycopg2.connect(database=dbname, user=user, password=psw, host=host, port=dbport)
                            cur=conn.cursor()
                            sql = "INSERT INTO "+ tb +"(usrdata,source,last_modified) VALUES ('"+ message +"','twisted','"+ nowtime +"')"
                            cur.execute(sql)
                            conn.commit()
                            cur.close()
                            conn.close()
                        except psycopg2.Error,e:
                            print "Mysql Error %d: %s  %s" % (e.args[0], e.args[1],datetime.datetime.now() )

linux:(转自：http://riching.iteye.com/blog/1743940)

方法一：

$yum install python-psycopg2

方法二：

1、安装PG的client以及函数库：
     yum install postgresql  
     yum install postgresql-devel
2、安装Python的函数库：
     yum install python-devel
3、下载pscopg
    wget http://initd.org/psycopg/tarballs/PSYCOPG-2-4/psycopg2-2.4.5.tar.gz
4、解压后进入目录
    python setup.py build
    python setup.py install

ubuntu:

sudo apt-get install python-psycopg2

php

yum install php-pgsql
 find / -name *pdo_pgsql*
 cat /etc/php.d/pdo_pgsql.ini
 whereis php
cp /etc/php.ini /etc/php.ini_bak
vi /etc/php.ini

extension=pdo_pgsql.so

extension=pgsql.so
 service httpd restart