postgresql在windows(包括win7)下的安装配置.doc

postgresql在windows(包括win7)下的安装配置首先，以下是常用命令：initdb 初始化 数据库。pg_ctl start 启动数据库pg_ctl stop 停止数据库post_svc -install 建立windows nt 服务（需要设置系统环境变量）post_svc -remove 删除 windows nt 服务使用createdb 库名 新建数据库使用createuser 用户名创建数据库帐号使用psql -h localhost -d 库名- U 用户名进入数据库接着来讲解:一、下载postgresql for windows/products/pgbindownload.do免安装的，直接解压到硬盘的一个目录下。笔者在d:pgsql二、设置环境变量，可以把以下内容写成一个BATset PGHOME=d:pgsqlset PATH=%PGHOME%bin;%path%set PGHOST=localhostset PGLIB=%PGHOME%libset PGDATA=%PGHOME%data笔者把它们写成了inst.batD:pgsqlinstD:pgsqlset PGHOME=d:pgsqlD:pgsqlset PATH=d:pgsqlbin;d:pgsqlbin;d:pgsqlbin;C:Windowssystem32;C:Windows;C:WindowsSystem32Wbem;C:WindowsSystem32WindowsPowerShellv1.0;C:Program FilesCommon FilesThunder NetworkKanKanCodecs;C:Program FilesMicrosoft SQL Server90Toolsbinn;d:MATLAB7binwin32;D:pgsqlset PGHOST=localhostD:pgsqlset PGLIB=d:pgsqllibD:pgsqlset PGDATA=d:pgsqldata三、初始化数据库D:pgsqlinitdb -locale=CThe files belonging to this database system will be owned by user Administrator.This user must also own the server process.The database cluster will be initialized with locale C.The default database encoding has accordingly been set to SQL_ASCII.The default text search configuration will be set to english.fixing permissions on existing directory d:/pgsql/data . okcreating subdirectories . okselecting default max_connections . 100selecting default shared_buffers . 32MBcreating configuration files . okcreating template1 database in d:/pgsql/data/base/1 . okinitializing pg_authid . okinitializing dependencies . okcreating system views . okloading system objects descriptions . okcreating conversions . okcreating dictionaries . oksetting privileges on built-in objects . okcreating information schema . okvacuuming database template1 . okcopying template1 to template0 . okcopying template1 to postgres . okWARNING: enabling trust authentication for local connectionsYou can change this by editing pg_hba.conf or using the -A option thenext time you run initdb.Success. You can now start the database server using: postgres -D d:/pgsql/dataor pg_ctl -D d:/pgsql/data -l logfile start四、启动D:pgsqlpg_ctl start五、重新开一个MSDOS窗口创建数据库,以mydb为例D:pgsqlcreatedb -h mydb创建用户D:pgsqlcreateuser -h 1