本文详细介绍了如何在Cygwin环境下安装并配置PostgreSQL数据库。步骤包括安装Cygwin及PostgreSQL软件包、设置环境变量、初始化数据库文件、启动服务等。对于从postgresql.org下载源码进行编译安装的情况也进行了说明。
1. Install cygwin with postgre sql 8.1.0
2. run /usr/bin/cygserver-config to run cygserver, set environment variable CYGWIN=server and make sure if cygserver is runing on services of Windows XP. cygrunsrv -S cygserver to start it.
3. initialize database data file: /usr/sbin/initdb -W -D /usr/local/pgsql/data
4. start postgre sql server : /usr/sbin/postmaster -D /usr/local/pgsql/data >logfile.log 2>&1 &
5. createdb test
6. psql test
It is quite easy to install postgre shipped with cygwin on cygwin. If you download postgre from postgresql.org, compile it and install it, you have to deal with ipc-daemon2. I cannot install postgre sql in this way.
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
