postgresql安装在了\cygwin\usr\local\pgsql下,pgsql目录下没data目录,
我在cygwin下敲命令,
$ psqlpsql:could not connect to server:No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?是说我psql没开吗,该怎么开?
我在cygwin下敲命令,
$ psqlpsql:could not connect to server:No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?是说我psql没开吗,该怎么开?
解决方案 »
- help
- mysql如何多行插入?求语句
- 如何删除这样的行?
- 送上MySQL两本电子书(手册和认证),如有雷同,纯属巧合
- Mysql trigger 问题
- mysql c++ c linux 开发时,怎么设置查询超时和更新记录超时啊?
- 函数调用问题,谢谢
- ++++++++++++++期待高手帮我解决一个mysql 查询语句++++++++++
- 请高人指点:Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
- 请问这样的数据结构怎么做多条件查询?
- mysql字段接触发器
- mysql如何做出像ms-sql的计划备份的功能?
我在cygwin上
initdb --help
看看这个命令,之后再启动数据库,才可以连接
执行initdb,
也是返回
initdb:could not connect to server:No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"? 请大虾帮帮忙
root# chown postgres /usr/local/pgsql/data
root# su postgres
postgres$ initdb -D /usr/local/pgsql/data
首先要開啟postgresql服務器吧,也就是后台程序吧,