Ubuntu16安装PostgreSQL

骑猪看日落 2023-06-24 09:26 11阅读 0赞

1.查看 ubuntu16 提供的 postgresql 版本：apt-cache show postgresql  
![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzI3NDA5Nw_size_16_color_FFFFFF_t_70][]  
2.安装命令：sudo apt-get install postgresql  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzI3NDA5Nw_size_16_color_FFFFFF_t_70 1]  
3.查看版本信息：psql --version  
![在这里插入图片描述][20191222160112237.png]  
4.安装postgrep数据库会默认创建一个用户 postgres 作为数据库的管理员，需要操作数据库需要切换到此用户：sudo su postgres  
![在这里插入图片描述][20191222161257821.png]  
5.查看postgresql已存在的数据库列表：psql -l![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzI3NDA5Nw_size_16_color_FFFFFF_t_70 2]  
6.创建一个名为demo的数据库：createdb demo ，然后重复步骤五

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzI3NDA5Nw_size_16_color_FFFFFF_t_70 3]  
到这里，新的数据库就已经建好啦。

7.进入demo数据库并且打开postgresql数据库的命令行：psql demo

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzI3NDA5Nw_size_16_color_FFFFFF_t_70 4]  
查看当前系统时间：select now(); \# now() 为postgresql提供的系统函数  
![在这里插入图片描述][20191222162358362.png]  
使用内置函数查看版本信息：select version();  
![在这里插入图片描述][20191222162603128.png]  
退出postgresql系统的命令行模式： \\q  
![在这里插入图片描述][20191222162810519.png]  
8.删除数据库 demo (非数据库命令行模式)： dropdb demo  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzI3NDA5Nw_size_16_color_FFFFFF_t_70 5]  
先到这里，后续有必要再更其它的。

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzI3NDA5Nw_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20191222155554668.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzI3NDA5Nw==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzI3NDA5Nw_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20191222160009227.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzI3NDA5Nw==,size_16,color_FFFFFF,t_70
[20191222160112237.png]: https://img-blog.csdnimg.cn/20191222160112237.png
[20191222161257821.png]: https://img-blog.csdnimg.cn/20191222161257821.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzI3NDA5Nw_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20191222161413672.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzI3NDA5Nw==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzI3NDA5Nw_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20191222161732867.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzI3NDA5Nw==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzI3NDA5Nw_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20191222162114558.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzI3NDA5Nw==,size_16,color_FFFFFF,t_70
[20191222162358362.png]: https://img-blog.csdnimg.cn/20191222162358362.png
[20191222162603128.png]: https://img-blog.csdnimg.cn/20191222162603128.png
[20191222162810519.png]: https://img-blog.csdnimg.cn/20191222162810519.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzI3NDA5Nw_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/20191222163140503.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzI3NDA5Nw==,size_16,color_FFFFFF,t_70