Chinaunix首页 | 论坛 | 博客
  • 博客访问: 2455216
  • 博文数量: 245
  • 博客积分: 4125
  • 博客等级: 上校
  • 技术积分: 3113
  • 用 户 组: 普通用户
  • 注册时间: 2009-03-25 23:56
文章分类

全部博文(245)

文章存档

2015年(2)

2014年(26)

2013年(41)

2012年(40)

2011年(134)

2010年(2)

分类: 数据库开发技术

2012-05-17 10:38:53


postgres 9.1.3 下载地址:

windows下面安装postgres 9.1.3需要注意的几个地方:
·安装过程中需要设置密码,指定端口(默认5432),选择locale(使用Default locale)
·安装完成后,将bin目录添加到环境变量PATH后面(C:\PostgreSQL\9.1\bin)

设置完成后,在命令行下面,连接postgres测试是否正确安装。


  1. C:\Users\henrypoter>psql -Upostgres -p5432
  2. 用户 postgres 的口令:
  3. psql (9.1.3)
  4. ê?è? "help" à′??è?°??úD??¢.
  5. postgres=# select current_user;
  6. current_user
  7. --------------
  8. postgres
  9. (1 行记录)
  10. postgres=# select current_database();
  11. current_database
  12. ------------------
  13. postgres
  14. (1 行记录)
  15. postgres=# select inet_server_port();
  16. inet_server_port
  17. ------------------
  18. 5432
  19. (1 行记录)
  20. postgres=# select inet_server_addr();
  21. inet_server_addr
  22. ------------------
  23. ::1
  24. (1 行记录)
  25. postgres=# select version();
  26. version
  27. -------------------------------------------------------------
  28. PostgreSQL 9.1.3, compiled by Visual C++ build 1500, 64-bit
  29. (1 行记录)
  30. postgres=#

.adslot-overlay {position: absolute; font-family: arial, sans-serif; background-color: rgba(0,0,0,0.65); border: 2px solid rgba(0,0,0,0.65); color: white !important; margin: 0; z-index: 2147483647; text-decoration: none; box-sizing: border-box; text-align: left;}.adslot-overlay-iframed {top: 0; left: 0; right: 0; bottom: 0;}.slotname {position: absolute; top: 0; left: 0; right: 0; font-size: 13px; font-weight: bold; padding: 3px 0 3px 6px; vertical-align: middle; background-color: rgba(0,0,0,0.45); text-overflow: ellipsis; white-space: nowrap; overflow: hidden;}.slotname span {text-align: left; text-decoration: none; text-transform: capitalize;}.revenue {position: absolute; bottom: 0; left: 0; right: 0; font-size: 11px; padding: 3px 0 3px 6px; vertial-align: middle; text-align: left; background-color: rgba(0,0,0,0.45); font-weight: bold; text-overflow: ellipsis; overflow: hidden; white-space: nowrap;}.revenue .name {color: #ccc;}.revenue .horizontal .metric {display: inline-block; padding-right: 1.5em;}.revenue .horizontal .name {padding-right: 0.5em;}.revenue .vertical .metric {display: block; line-height: 1.5em; margin-bottom: 0.5em;}.revenue .vertical .name, .revenue .vertical .value {display: block;}.revenue .square .metric, .revenue .button .metric {display: table-row;}.revenue .square .metric {line-height: 1.5em;}.revenue .square .name, .revenue .square .value, .revenue .button .value {display: table-cell;}.revenue .square .name {padding-right: 1.5em;}.revenue .button .name {display: block; margin-right: 0.5em; width: 1em; overflow: hidden; text-overflow: clip;}.revenue .button .name:first-letter {margin-right: 1.5em;}a.adslot-overlay:hover {border: 2px solid rgba(58,106,173,0.9);}a.adslot-overlay:hover .slotname {border-bottom: 1px solid rgba(81,132,210,0.9); background-color: rgba(58,106,173,0.9);}a.adslot-overlay:hover .revenue {border-top: 1px solid rgba(81,132,210,0.9); background-color: rgba(58,106,173,0.9);}div.adslot-overlay:hover {cursor: not-allowed; border: 2px solid rgba(64,64,64,0.9);}div.adslot-overlay:hover .slotname {border-bottom: 1px solid rgba(128,128,128,0.9); background-color: rgba(64,64,64,0.9);}div.adslot-overlay:hover .revenue {border-top: 1px solid rgba(128,128,128,0.9); background-color: rgba(64,64,64,0.9);}
阅读(2035) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~