Postgresql installation and common error handling I. Installation instructions recently, due to business needs, I abandoned the mysql database that I have been using and started to switch to the postgresql database. Why should I choose postgresql?
PostgreSQL is an open-source SQL database that supports standard SQL and allows users to connect to PostgreSQL via the JDBC driver for application development. The user extends the PostgreSQL function, allowing the developer to access the SEQUOIADB
Introduction of PostgreSQL
1, what is PostgreSQL
The PostgreSQL database is currently the most powerful open source database, supporting rich data types (such as JSON, JSONB type, array type), and custom types. And it provides a rich interface
PostgreSQL is an object-relational database (database management system) based on the BSD license. Because of the flexibility of the license, anyone can use, modify, and distribute PostgreSQL for free for any purpose. Simply put, even if you take it
(1) User PracticalityProgram:
Createdb creates a new PostgreSQL database (same as SQL statement: Create Database)
Createuser creates a new PostgreSQL user (same as SQL statement: create user)
Dropdb deletes a database
Dropuser: delete a user
The former is the management terminal installation package in windows, and the latter is the source code installation package of the database. (2) Copy postgresql-8.2.3.tar.gz to a temporary directory in Linux.
The former is the management terminal
apache|web| Data | Database sender: xiaoning (I want to fly), letter area: Linux
Title: Apache+php3+postgresql as a web-based database platform for Ann
Letter station: BBS Water Wood Tsinghua Station (Thu 20 16:00:28 2000)
The following describes
The following will illustrate the use of Apache+php3+postgresql as a web-based database platform for installation and configuration methods. More about Apache, PHP3, and PostgreSQL can be found in the software's accompanying documentation, Linux
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.