用户讨论:Jinzd:修订间差异

来自Ubuntu中文
跳到导航跳到搜索
Jinzd留言 | 贡献
Jinzd留言 | 贡献
第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