位置: IT常识 - 正文

install PostgreSQL Community Ubuntu Documentation

编辑:rootadmin
PostgreSQL - Community Ubuntu DocumentationPostgreSQL 目录 Introduction Client Installation Installati PostgreSQL

目录

Introduction Client Installation Installation Dapper Hardy Karmic, Lucid, Intrepid and Maverick Administration Basic Server Setup Dapper Karmic, Lucid, Intrepid and Maverick Create database Install Server Instrumentation for Postgresql 8.4 Alternative Server Setup Using pgAdmin III GUI Managing the Server Managing users and rights restarting the server Further reading External Links Turnkey LinuxIntroduction

PostgreSQL is a powerful object-relational database management system, provided under a flexible BSD-style license.[1] PostgreSQL contains many advanced features, is very fast and standards compliant.

PostgreSQL has bindings for many programming languages such as C, C++, Python, Java, PHP, Ruby... It can be used to power anything from simple web applications to massive databases with millions of records.

Client Installation

If you only wish to connect to a PostgreSQL server, do not install the whole PostgreSQL package, but install the PostgreSQL client instead. To do this, use the following command

sudo apt-get install postgresql-client

you then connect to the server with the following command

psql -h server.domain.org database user

After you inserted the password you access PostgreSQL with line commands. You may for instance insert the following

SELECT * FROM table WHERE 1;

You exit the connection with

\qInstallationDapper

To install PostgreSQL 8.1 you may use the command line and type:

sudo apt-get install postgresql-8.1Hardy

Install the latest Postgresql 8.3 from the command line with the following command:

sudo apt-get install postgresqlKarmic, Lucid, Intrepid and Maverick

To install Postgresql 8.4 you may use the command line and type:

sudo apt-get install postgresqlAdministration

pgAdmin III is a handy GUI for PostgreSQL, it is essential to beginners. To install it, type at the command line:

sudo apt-get install pgadmin3

You may also use the Synaptic package manager from the System>Administration menu to install these packages.

Basic Server Setup

To start off, we need to change the PostgreSQL postgres user password; we will not be able to access the server otherwise. As the “postgres” Linux user, we will execute the psql command.

In a terminal, type:

Dappersudo -u postgres psql template1Karmic, Lucid, Intrepid and Mavericksudo -u postgres psql postgres

Set a password for the "postgres" database role using the command:

\password postgres

and give your password when prompted. The password text will be hidden from the console for security purposes.

Type Control+D to exit the posgreSQL prompt.

Create database

To create the first database, which we will call "mydb", simply type:

sudo -u postgres createdb mydbInstall Server Instrumentation for Postgresql 8.4

To install Server Instrumentation for Postgresql 8.4 you may use the command line and type:

sudo apt-get install postgresql-contrib

Run the adminpack.sql script, simply type:

sudo -u postgres psql < /usr/share/postgresql/8.4/contrib/adminpack.sqlAlternative Server Setup

If you don't intend to connect to the database from other machines, this alternative setup may be simpler.

By default in Ubuntu, Postgresql is configured to use 'ident sameuser' authentication for any connections from the same machine. Check out the excellent Postgresql documentation for more information, but essentially this means that if your Ubuntu username is 'foo' and you add 'foo' as a Postgresql user then you can connect to the database without requiring a password.

Since the only user who can connect to a fresh install is the postgres user, here is how to create yourself a database account (which is in this case also a database superuser) with the same name as your login name and then create a password for the user:

sudo -u postgres createuser --superuser $USER sudo -u postgres psql postgres=# \password $USER

Client programs, by default, connect to the local host using your Ubuntu login name and expect to find a database with that name too. So to make things REALLY easy, use your new superuser privileges granted above to create a database with the same name as your login name:

createdb $USER

Connecting to your own database to try out some SQL should now be as easy as:

psql

Creating additional database is just as easy, so for example, after running this:

create database amarokdb;

You can go right ahead and tell Amarok to use postgresql to store its music catalog. The database name would be amarokdb, the username would be your own login name, and you don't even need a password thanks to 'ident sameuser' so you can leave that blank.

Using pgAdmin III GUI

To get an idea of what PostgreSQL can do, you may start by firing up a graphical client. In a terminal type :

pgadmin3

You will be presented with the pgAdmin III interface. Click on the "Add a connection to a server" button (top left). In the new dialog, enter the address 127.0.0.1, a description of the server, the default database ("mydb" in the example above), your username ("postgres") and your password.

With this GUI you may start creating and managing databases, query the database, execute SQl etc.

Managing the ServerManaging users and rights

To manage users, you first have to edit /etc/postgresql/8.1/main/pg_hba.conf and modify the default configuration which is very protective. For example, if you want postgres to manage its own users (not linked with system users), you will add the following line:

8<-------------------------------------------# TYPE DATABASE USER IP-ADDRESS IP-MASK METHODhost all all 10.0.0.0 255.255.255.0 md58<-------------------------------------------

Which means that on your local network (10.0.0.0/24 - replace with your own local network !), postgres users can connect through the network to the database providing a classical couple user / password.

Besides allowing a user to connect over the network to the to a database on the server, you must enable postgre to listen across different networks. To do that, open up /etc/postgresql/8.3/main/postgresql.conf in your favourite editor and alter the listen_addresses as below:

listen_addresses = '10.0.0.1,localhost'

where 10.0.0.1 describes the server's IP address on the local network. Note that this setting is commented out by default.

To create a database with a user that have full rights on the database, use the following command:

sudo -u postgres createuser -D -A -P myusersudo -u postgres createdb -O myuser mydb

The first command line creates the user with no database creation rights (-D) with no add user rights -A) and will prompt you for entering a password (-P). The second command line create the database 'mydb with 'myuser' as owner.

This little example will probably suit most of your needs. For more details, please refer to the corresponding man pages or the online documentation.

restarting the server

After configuring the networking / users you may need to restart the server, here is a suggested command to do so.

sudo /etc/init.d/postgresql-8.3 restartFurther reading

If you are not familiar with SQL you may want to look into this powerful language, although some simple uses of PostgreSQL may not require this knowledge (such as a simple Django project).

The PostgreSQL website contains a wealth of information on using this database.

推荐整理分享install PostgreSQL Community Ubuntu Documentation,希望有所帮助,仅作参考,欢迎阅读内容。

install PostgreSQL  Community Ubuntu Documentation

文章相关热门搜索词:,内容如对您有帮助,希望把文章链接给更多的朋友!

[1] You do not have to pay in order to use PostgreSQL for some applications, such as commercial closed source software, contrary to other well known open source databases.

Note: this guide has been tested on Ubuntu 6.06 (Dapper) and Ubuntu 7.10 (Gutsy)

External Links

The following are unverified suggestions made by users.

Turnkey Linux

An Ubuntu-based PostgreSQL appliance is one of the easiest ways to get up and running with PostgreSQL on Ubuntu. It's part of a family of pre-integrated TurnKey Linux Software Appliances based on Ubuntu 10.04.1 (Lucid LTS).

=== Xubuntu ====

The postgres command does not exist in the postgres package under recent postgres packages, fun.

# cat /var/lib/dpkg/info/postgresql.list /. /usr /usr/share /usr/share/doc /usr/share/doc/postgresql /usr/share/doc/postgresql/README /usr/share/doc/postgresql/copyright /usr/share/doc/postgresql/changelog.Debian.gz

本文链接地址:https://www.jiuchutong.com/zhishi/304541.html 转载请保留说明!

上一篇:爱上源码,重学Spring IoC深入

下一篇:ubuntu日志的设置(ubuntu系统日志配置文件)

  • dxva2.dll是什么意思(dxgi.dll是什么)

    dxva2.dll是什么意思(dxgi.dll是什么)

  • 怎样防止微信被定位(怎样防止微信被别人登录)

    怎样防止微信被定位(怎样防止微信被别人登录)

  • 腾讯旗下的软件有哪些(快手极速版是不是腾讯旗下的软件)

    腾讯旗下的软件有哪些(快手极速版是不是腾讯旗下的软件)

  • 魅族小窗算切屏吗(魅族小窗模式可以拖动吗)

    魅族小窗算切屏吗(魅族小窗模式可以拖动吗)

  • 抖音为什么下载不了呢(抖音为什么下载不了视频)

    抖音为什么下载不了呢(抖音为什么下载不了视频)

  • 知乎复制不了的文字怎么办(知乎app不能复制)

    知乎复制不了的文字怎么办(知乎app不能复制)

  • 键盘104和108的差别(键盘104和108的区别)

    键盘104和108的差别(键盘104和108的区别)

  • 爱奇艺自制是什么意思(爱奇艺上面的自制是什么意思)

    爱奇艺自制是什么意思(爱奇艺上面的自制是什么意思)

  • 电脑c盘可以格式化吗(c 盘可以格式化吗)

    电脑c盘可以格式化吗(c 盘可以格式化吗)

  • 笔记本电脑看直播卡顿是什么原因(笔记本电脑看直播cpu温度高)

    笔记本电脑看直播卡顿是什么原因(笔记本电脑看直播cpu温度高)

  • 微信里怎样保留照片和视频(微信怎样保留一个人的聊天记录)

    微信里怎样保留照片和视频(微信怎样保留一个人的聊天记录)

  • ps怎么生成选区(ps怎么生成选区图案)

    ps怎么生成选区(ps怎么生成选区图案)

  • 微信没好友辅助怎么解封(微信没好友辅助怎么办)

    微信没好友辅助怎么解封(微信没好友辅助怎么办)

  • wps表格如何删除多余的列(wps表格如何删除重复项整行)

    wps表格如何删除多余的列(wps表格如何删除重复项整行)

  • 手机话费能开qq什么业务(手机话费能开公司发票吗)

    手机话费能开qq什么业务(手机话费能开公司发票吗)

  • 为什么抖音不能用qq登录(为什么抖音不能关注人了)

    为什么抖音不能用qq登录(为什么抖音不能关注人了)

  • 快手极速版怎么取消关注(快手极速版怎么样才能快速赚钱)

    快手极速版怎么取消关注(快手极速版怎么样才能快速赚钱)

  • oppok1怎么隐藏应用(oppok1如何设置隐藏)

    oppok1怎么隐藏应用(oppok1如何设置隐藏)

  • 苹果xr怎么录视频(苹果xr录视频怎么开闪光灯)

    苹果xr怎么录视频(苹果xr录视频怎么开闪光灯)

  • 期末前端web大作业——我的家乡陕西介绍网页制作源码HTML+CSS+JavaScript(web前端开发期末试题及答案)

    期末前端web大作业——我的家乡陕西介绍网页制作源码HTML+CSS+JavaScript(web前端开发期末试题及答案)

  • Vue实现角色权限动态路由详细教程,在vue-admin-template基础上修改,附免费完整项目代码(vue角色管理)

    Vue实现角色权限动态路由详细教程,在vue-admin-template基础上修改,附免费完整项目代码(vue角色管理)

  • lspci命令  显示当前设备PCI总线设备信息(lspci命令显示)

    lspci命令 显示当前设备PCI总线设备信息(lspci命令显示)

  • 企业办理纳税手续需要带什么材料
  • 金融业产值和金融业增加值有什么不同
  • 装修行业专票的税率是多少
  • 科研材料怎么买
  • 资产负债表里面的应收账款怎么算
  • 小规模纳税人未开票收入填在哪里
  • 大病医疗可以抵扣吗
  • 报销必须是公司吗
  • 居民企业应纳税所得额税率
  • 债券置换债务
  • 农产品为什么价格低
  • 公司收到虚开发票谁承担
  • 应收账款多记如何调账?
  • 折扣折让的销售方式有哪些
  • 报销发票只准报一部分怎么做账?
  • 咨询服务费怎么结转成本
  • 地税印花税税率是多少
  • 印刷专票税率是几个点
  • 税务局领普通发票需要多少钱
  • 政府补助怎么开票入账
  • 应收账款怎么样转入以前年度损益调整
  • 收入可以用收据入账吗
  • 一般纳税人增值税及附加税费申报表怎么填
  • 销售固定资产的收入计入什么科目
  • 开票的增值税与附加税
  • 设备器具一次性扣除会计分录
  • 个人取得经济补偿金个人所得税计算
  • 耳机插在电脑上有滋滋的声音
  • ppt文件打不开了怎么办
  • 受托加工物资的账务处理例题
  • 工程合同主要看什么
  • win11预览版更新界面
  • 差旅费报销需要提交的单据有
  • lsalss.exe
  • 个税代扣代缴手续费返还增值税税率
  • 虚拟机vm怎么用
  • 钉钉h5微应用
  • PHP:Memcached::decrementByKey()的用法_Memcached类
  • 工业企业会计核算的特点
  • 免施工许可证
  • 零售价是含税价还是不含税价
  • 境外服务费代扣代缴所得税计算
  • 非常经典的php文章
  • import vue from vue报错
  • 印花税不足一元需要缴纳吗
  • vue backbone
  • 如何做架构规划图
  • laravel enum
  • 报关单在哪里打出来
  • 简单设置w11
  • 不借助的英文
  • sql server 2005 win10
  • 公司减少注册资本的条件和程序
  • 其他非流动资产是会计科目吗
  • 汇算清缴职工教育经费
  • 自来水厂被收购,员工怎么办
  • 股权转让的会计处理怎么做
  • 赔付支出包括
  • 企业所得税汇算表
  • 事业单位服务收费标准
  • 先开发票后付款如何记账?
  • 主营业务成本如何做分录
  • 增值税对企业
  • 固定资产报废需要税务备案吗
  • 研发费用扣除75%
  • 单位购入车辆能抵扣吗
  • win7和winxp区别
  • Win2000/2003 Broadcom 网卡 teaming 配置手册
  • 如何重设路由器密码怎么办
  • windows 2000 server系统安装图解
  • linux tracker
  • linux中rwx
  • win10如何安装office
  • 导入项目出现这个问题
  • 网页css加载失败
  • node js 前端
  • jquery提供了三种删除节点的方法,分别是什么
  • 非房地产企业土增税扣除有哪些
  • 广东省国家税务局电子发票系统,网络设置
  • 国税网查发票真伪
  • 免责声明:网站部分图片文字素材来源于网络,如有侵权,请及时告知,我们会第一时间删除,谢谢! 邮箱:opceo@qq.com

    鄂ICP备2023003026号

    网站地图: 企业信息 工商信息 财税知识 网络常识 编程技术

    友情链接: 武汉网站建设