用户讨论:Jinzd:修订间差异
来自Ubuntu中文
跳到导航跳到搜索
第3行: | 第3行: | ||
For newest Ubuntu 16.04 postgresql is ready to install: | For newest Ubuntu 16.04 postgresql is ready to install: | ||
<pre> | <pre style="margin: 5px"> | ||
jinzd@ubuntu:~S sudo apt install postgresql-9.5 | jinzd@ubuntu:~S sudo apt install postgresql-9.5 | ||
</pre> | </pre> | ||
第9行: | 第9行: | ||
Get postgresql ready to use, set password is the first step: | Get postgresql ready to use, set password is the first step: | ||
<pre> | <pre style="margin: 5px"> | ||
jinzd@ubuntu:~S sudo -u postgres psql template1 | jinzd@ubuntu:~S sudo -u postgres psql template1 | ||
第23行: | 第23行: | ||
Create database: | Create database: | ||
<pre> | <pre style="margin: 5px"> | ||
jinzd@ubuntu:~S sudo -u postgres created JUniverse | jinzd@ubuntu:~S sudo -u postgres created JUniverse | ||
</pre> | </pre> |
2016年5月11日 (三) 14:07的版本
PostgreSQL
For newest Ubuntu 16.04 postgresql is ready to install:
jinzd@ubuntu:~S sudo apt install postgresql-9.5
Get postgresql ready to use, set password is the first step:
jinzd@ubuntu:~S sudo -u postgres psql template1 template1=# \password postgres; or jinzd@ubuntu:~S sudo -u postgres psql postgres postgres=# \password postgres;
Create database:
jinzd@ubuntu:~S sudo -u postgres created JUniverse