官网:http://www.enterprisedb.com
下载:http://get.enterprisedb.com/postgresql/postgresql-9.1.2-1-windows-binaries.zip
以上是免安装版的,需要手动初始化及注册服务,步骤如下:
1)解压到指定目录(用path表示)
2)在path下新建存放数据的目录myData
3)在bin目录运行以下命令
初始化数据库:initdb.exe -D path\myDate -E UTF8 --locale=C
(比如我的:initdb.exe -D D:\Development\pgsql-9.1.2-1-windows\myDate -E UTF8 --locale=C)
PG启动命令:pg_ctl -D "path/myDate" -l logfile start
(比如我的:pg_ctl -D "D:/Development/pgsql-9.1.2-1-windows/myDate" -l logfile start)
PG停止命令:pg_ctl stop -D "path/myDate" -m smart
(比如我的:pg_ctl stop -D "D:/Development/pgsql-9.1.2-1-windows/myDate" -m smart)
之后在使用中打开服务即可访问连接,可用Navicat等图形工具操作pgsql。
分享到:
相关推荐
postgresql.42.2.4.jar驱动包postgresql.42.2.4.jar驱动包postgresql.42.2.4.jar驱动包postgresql.42.2.4.jar驱动包postgresql.42.2.4.jar驱动包postgresql.42.2.4.jar驱动包
PostgreSQL.High.Availability.Cookbook.2nd.Edition.2017.2.pdf
windows下编译安装postgresql.docx windows下编译安装postgresql.docx windows下编译安装postgresql.docx
Postgresql 10.20.2 Windows 64位安装包Postgresql 10.20.2 Windows 64位安装包Postgresql 10.20.2 Windows 64位安装包Postgresql 10.20.2 Windows 64位安装包Postgresql 10.20.2 Windows 64位安装包Postgresql ...
EMS.PostgreSQL.Manager.v2.8.0.1.Pro.rarEMS.PostgreSQL.Manager.v2.8.0.1.Pro.rarEMS.PostgreSQL.Manager.v2.8.0.1.Pro.rar
navicate_for_postgresql.rar
database developers for programming database applications with PostgreSQL. It is targeted to database developers using PostgreSQL who have basic experience developing database applications with the ...
PostgreSQL.Up.and.Running.2nd.Edition.2014.12.pdf
PostgreSQL.官方文档 ,详细介绍PostgreSQL ,是很好的学习PostgreSQL的工具。
Packtpub.PostgreSQL.9.Admin.Cookbook.Oct.2010 pdf格式
This book is a comprehensive and pragmatic guide to developing databases in PostgreSQL. Beginning with a refresher of basic SQL skills, you will gradually be exposed to advanced concepts, such as ...
PostgreSql数据库驱动
java连接数据库
jar包,官方版本,自测可用
Packt.PostgreSQL.Cookbook.2015
Packt.PostgreSQL.9.6.High.Performance.2017
Addison.PostgreSQL.Introduction.and.Concepts
McGraw.Hill.PostgreSQL.8.for.Windows.Mar.2007.pdf
Packt.PostgreSQL.Developer's.Guide.2015
Packt.Mastering.PostgreSQL.15.5th.Edition.2023.1