国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 數據庫 > PostgreSQL > 正文

在windows下手動初始化PostgreSQL數據庫教程

2020-01-31 15:23:07
字體:
來源:轉載
供稿:網友

環境:win7 64 sp1
PG:9.3.5

1、創建用戶postgres,密碼同樣是postgres:

net user postgres postgres /add

2、在數據庫根目錄下建立data目錄:

C:/Program Files/PostgreSQL/9.3>md data

3、去掉administrator對data目錄的權限:

C:/Program Files/PostgreSQL/9.3>cacls data /e /t /r administrator

處理的目錄: C:/Program Files/PostgreSQL/9.3/data
4、將data目錄的權限賦給postgres用戶:

C:/Program Files/PostgreSQL/9.3>cacls data /e /t /g postgres:C

處理的目錄: C:/Program Files/PostgreSQL/9.3/data
5、用postgres用戶打開cmd

C:/Program Files/PostgreSQL/9.3>runas /user:postgres cmd.exe

輸入 postgres 的密碼:
試圖將 cmd.exe 作為用戶 "SURE-PC/postgres" 啟動...
6、進行初始化,初始化用戶為postgres,字符集為utf8,locale為C:

C:/Program Files/PostgreSQL/9.3/bin>initdb.exe -D ../data -E utf8 --locale C -U postgresThe files belonging to this database system will be owned by user "postgres".This user must also own the server process. The database cluster will be initialized with locale "C".The default text search configuration will be set to "english". Data page checksums are disabled. fixing permissions on existing directory ../data ... okcreating subdirectories ... okselecting default max_connections ... 100selecting default shared_buffers ... 128MBcreating configuration files ... okcreating template1 database in ../data/base/1 ... okinitializing pg_authid ... okinitializing dependencies ... okcreating system views ... okloading system objects' descriptions ... okcreating collations ... not supported on this platformcreating conversions ... okcreating dictionaries ... oksetting privileges on built-in objects ... okcreating information schema ... okloading PL/pgSQL server-side language ... okvacuuming database template1 ... okcopying template1 to template0 ... okcopying template1 to postgres ... oksyncing data to disk ... ok WARNING: enabling "trust" authentication for local connectionsYou can change this by editing pg_hba.conf or using the option -A, or--auth-local and --auth-host, the next time you run initdb. Success. You can now start the database server using:   "postgres" -D "../data"or  "pg_ctl" -D "../data" -l logfile start  C:/Program Files/PostgreSQL/9.3/bin>


7、啟動數據庫,進入客戶端:

C:/Program Files/PostgreSQL/9.3/bin>"pg_ctl" -D "../data" startserver starting C:/Program Files/PostgreSQL/9.3/bin>LOG: database system was shut down at 2014-09-18 10:19:54 HKTLOG: autovacuum launcher started C:/Program Files/PostgreSQL/9.3/bin>LOG: database system is ready to accept connections C:/Program Files/PostgreSQL/9.3/bin>psql.exepsql (9.3.5)Type "help" for help. postgres=#

發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表

圖片精選

主站蜘蛛池模板: 乌鲁木齐市| 门源| 垦利县| 东莞市| 麻城市| 梁河县| 菏泽市| 铜梁县| 广宁县| 周至县| 铁力市| 泰和县| 漳州市| 宁津县| 沂南县| 赤城县| 焉耆| 桃园市| 磐安县| 迁安市| 延川县| 烟台市| 滁州市| 临沂市| 天祝| 南漳县| 伊金霍洛旗| 蒙城县| 枞阳县| 南华县| 厦门市| 金川县| 清涧县| 宜良县| 金阳县| 南漳县| 定边县| 乐平市| 延庆县| 恩平市| 廊坊市|