Installation of postgre sql on cygwin

最新推荐文章于 2024-10-09 22:03:16 发布

superben

最新推荐文章于 2024-10-09 22:03:16 发布

阅读量978

点赞数

分类专栏： Linux 文章标签： sql sql server download database windows server

本文链接：https://blog.csdn.net/superben/article/details/601977

版权

Linux 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

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.