Installing PostgreSQL using RPM packages in Linux
Postgresql and MySQL are currently popular and active open source relational database systems. Compared with high-end Oracle commercial products, Postgresql and MyQL have much room for improvement in
PostgreSQL-related software, libraries, tools, and resource collections.Backup
WAL-E-Simple continuous archiving for Postgres to S3, Azure, or Swift by Heroku
Barman-backup and Recovery Manager for Postgres by 2ndQuadrant
Gui
First, the environmentVM Virtual MachinesName="Ubuntu"VERSION="12.04.4 LTS, precise pangolin" Second, the process1. Install make and do not load now.Install Make Make--3.81 2006 for for I686-pc-linux-gnu2. Get the source codeBut now there is
I. Environment vmvm NAME = "Ubuntu" VERSION = "12.04.4LTS, PrecisePangolin" II. Process 1. Install make. Do not install make now. # Apt-getinstallmake # make -- versionGNUMake3.81Copyright (C) 2006 FreeSoftwareFoundation
I. Environment
Vmvm
NAME =
I. Environment vmvirtual machine NAMEUbuntuVERSION12.04.4LTS, PrecisePangolin II. Process 1. Install make. Do not install make now. # Apt-getin
I. Environment vmvirtual machine NAME = UbuntuVERSION = 12.04.4 LTS, Precise Pangolin II. Process 1.
This article mainly introduces how to install and use postgresql in ubuntu. if you need it, refer to the following tag: Ubuntu
Install components
Client installationSudo apt-get install postgresql-clientServer InstallationCopy codeThe code is as
After the previous text PostgreSQL compilation installation and debugging (a), continue to talk about the installation and debugging PostgreSQL.The previous article explained how to compile and install PostgreSQL on a Linux system, and this time
Postgresql has added the External table access function since 9.1. This function allows the database to directly read files other than the database, such as csv or text files. DML is not supported for the moment. Postgresql has various plug-ins that
1. Create a master tableCREATE TABLE Part_tab (c1 int, c2 int,name varchar) PARTITION by RANGE (C1);2. Create sub-partition tableCREATE TABLE part1 PARTITION of Part_tab for VALUES from (0) to (100);CREATE TABLE part2 PARTITION of Part_tab for
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.