ABSTRACT
PostgreSQL is an object-relational database system that has the features of traditional commercial database systems with enhancements to be found in next-generation DBMS systems. This blog entry documents the installation process of the PostgreSQL database on Ubuntu Linux.
sudo apt-get install postgresql
sudo apt-get install libpq-dev
INTRODUCTION
I have selected PostgreSQL 9.1 and Ubuntu Linux 12.10 32 bit. The installation process follows the apt-get install configure
pattern.
STEP 1: VERIFY THAT YOU DO NOT ALREADY HAVE POSTGRESQL INSTALLED ON YOUR SYSTEM
Run the following command in your console:
1
|
ps ax | grep postgres
|
If you get a response similar to the one below, then you have PostgreSQL installed.
1
2
3
4
|
Ss 0:00 postgres: writer process Ss 0:00 postgres: wal writer process Ss 0:00 postgres: autovacuum launcher process Ss 0:00 postgres: stats collector process |
STEP 2: INSTALL POSTGRESQL ON YOUR SYSTEM
Run the following commands in your console:
1
2
|
sudo apt-get update
sudo apt-get install postgresql-9.1
|
STEP 3: CONFIGURE YOUR POSTGRESQL PASSWORD
1
2
3
|
sudo -u postgres psql template1
ALTER USER postgres with encrypted password 'your_password' ;
Press ctrl-d |
STEP 4: CONFIGURE MD5 AUTHENTICATION
1
|
sudo nano /etc/postgresql/9 .1 /main/pg_hba .conf
|
Update the
1
|
local all postgres
|
entry to
1
|
local all postgres md5
|
STEP 5: ENABLE TCP/IP CONNECTIONS
1
|
sudo nano /etc/postgresql/9 .1 /main/postgresql .conf
|
Locate the line
1
|
#listen_addresses = 'localhost' |
and change it to:
1
|
listen_addresses = 'localhost'
|
To allow other computers to connect to your PostgreSQL server replace ‘localhost’ with the IP Address of your server, or alternatively to ’0.0.0.0′ to bind to all interfaces.
STEP 6: RESTART POSTGRES
1
|
sudo service postgresql restart
|
相关推荐
postgresql-11 Ubuntu22.04离线安装包,deb格式。 执行压缩包内 install.sh 可一键安装。 适用于无互联网环境。
导出PostgreSQL数据库中的数据: $ pg_dump -U postgres -d mydatabase -f mydatabase.sql 导入数据时首先创建数据库再用psql导入: $ createdb newdatabase $ psql -d newdatabase -U postgres -f mydatabase....
按顺序执行以下命令即可完整安装PostgreSQL所需Zlib和readline依赖: sudo dpkg -i zlib1g-dev_1.2.8.dfsg-1ubuntu1_amd64.deb sudo dpkg -i libtinfo-dev_5.9+20140118-1ubuntu1_amd64.deb sudo dpkg -i ...
Configure parameters and change default settings for a PostgreSQL server Leverage the logging mechanism to identify errors and suboptimal queries Use replication to scale horizontally Set up backup ...
*Install and configure PostgreSQL on Windows *Administer your database and manage data *Create VB.NET, Visual C++, and Java applications *Migrate from Microsoft Access to PostgreSQL
服务器处于没有外网的情况下,如何安装PostgreSQL,并且通过PGADMIN访问
支持ArcGIS10.2版本的PostgreSQL_DBMS_for_windows_922,ESRI官方原版资源。
dbExpress is a database-independent layer that defines common interface to provide fast access to PostgreSQL from Delphi and C++Builder on Windows and Mac OS X for both 32-bit and 64-bit platforms....
This PostgreSQL® Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow. Text content is released under Creative ...
Navicat for PostgreSQL是一套专为PostgreSQL设计的强大数据库管理及开发工具。它可以用于任何版本 7.5 或以上的 PostgreSQL 数据库服务器,并支持大部份 PostgreSQL最新版本的功能,包括触发器、函数、管理用户等。...
postgresql up and running pdf
postgresql管理和开发的一本很好的参考书籍
For all intents and purposes, it’s BSD-licensed. It has a long history, dating back to 1985. PostgreSQL has enterprise-class features such as SQL windowing functions, the ability to create aggregate...
navical For PostgreSQL 11 完美破解版navical For PostgreSQL 11 完美破解版navical For PostgreSQL 11 完美破解版navical For PostgreSQL 11 完美破解版 亲测有效
PostgreSQL.Up.and.Running.2nd.Edition.2014.12.pdf
PostgreSQL- Up and Running.pdf
PostgreSQL Up and Running(3rd)(EarlyRelease) 英文无水印pdf 第3版 pdf所有页面使用FoxitReader和PDF-XChangeViewer测试都可以打开 本资源转载自网络,如有侵权,请联系上传者或csdn删除 本资源转载自网络,...
PostgreSQL for Data Architects will teach you everything you need to learn in order to get a scalable and optimized PostgreSQL server up and running. The book starts with basic concepts (such as ...
PostgreSQL Up and Running(3rd) 英文epub 第3版 本资源转载自网络,如有侵权,请联系上传者或csdn删除 本资源转载自网络,如有侵权,请联系上传者或csdn删除
PostgreSQL在Ubuntu上安装指南,在线安装,以及简单常用指令