This is a creation in
Article, where the information may have evolved or changed.
Github.com/lib/pq
PG is a pure go write driver of the Postgres database. The author gave us a little joke, the PQ will always be habitually written PG there is no ...
In the work often to develop and test import and export some test database, so wrote a script for easy operation.The company is currently using the postgres9.3 database.#!/bin/bash# defines some variables and operation commands dbs= "DB1DB2DB3DB4"
I. Overview of DB-API
Python supports a number of different databases. Because different seller servers result in different network protocols for database communication. In earlier versions of Python, each database had its own Python module, all of
I. Overview of DB-APIPython supports a number of different databases. Because the different seller server causes the network protocol which communicates with the database to be different. In earlier versions of Python, each database had its own
Seven, Pg_dump:
Pg_dump is a tool for backing up the PostgreSQL database. It can even make a full, consistent backup when the database is being used concurrently, without blocking access to the database by other users. The dump format generated by
In Oracle, deleting a table or deleting a table record; There is a flashback feature that does not require a stop operation and can perfectly retrieve the record. There are, of course, some other recovery tools, such as ODU tools, Gdul tools. can
0. Preparation phaseNew PG account for initializing, starting, and shutting down the databasesudo groupadd postgressudo useradd-g postgres-m postgressudo passwd postgresTo specify sudo permissions for the Postgres user group:Ll/etc/sudoerssudo chmod
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
Sql. Open only creates the DB object, but dies not open any connections to the database. If you want to test your connections, you had to execute a query to force opening a connection. The common-on-a-to-call Ping () on your DB object.See
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.