麻豆小视频在线观看_中文黄色一级片_久久久成人精品_成片免费观看视频大全_午夜精品久久久久久久99热浪潮_成人一区二区三区四区

首頁 > 數(shù)據(jù)庫 > PostgreSQL > 正文

在windows下手動初始化PostgreSQL數(shù)據(jù)庫教程

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

環(huán)境:win7 64 sp1
PG:9.3.5

1、創(chuàng)建用戶postgres,密碼同樣是postgres:

net user postgres postgres /add

2、在數(shù)據(jù)庫根目錄下建立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、啟動數(shù)據(jù)庫,進入客戶端:

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=#

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

圖片精選

主站蜘蛛池模板: 免费毛片随便看 | 免费福利在线视频 | 99精品视频在线免费观看 | 在线免费日韩 | 在线日韩av电影 | 91精品国产91久久久久久丝袜 | 男女羞羞在线观看 | 日韩视频一区二区 | 国产91片 | 久久久免费 | 福利在线国产 | 亚洲性生活视频 | 国产午夜探花 | 国产精品久久久久久久久久尿 | av电影手机在线看 | 素人视频在线观看免费 | 久久网一区二区 | 日本娇小videos高潮 | 高清国产福利 | 91福利在线观看 | 外国一级黄色片 | 亚洲二区三区在线 | 日本在线视频一区二区三区 | 久久蜜桃香蕉精品一区二区三区 | 国产午夜精品在线 | 国产精品一区二区x88av | 国产精品成人亚洲一区二区 | 久久久日韩精品一区二区三区 | 黄色网址在线免费播放 | 国产噜噜噜 | 少妇一级淫片免费放正片 | www.成人免费| 日本成人一二三区 | 中午字幕无线码一区2020 | 国产一级不卡毛片 | 国产精品刺激对白麻豆99 | 中文字幕亚洲欧美 | 亚洲国产一区二区三区 | 日韩美香港a一级毛片 | 国产久草视频在线 | www日韩大片 |