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
Step 1: Install Postgresql in Ubuntu
Sudo apt-get install postgresql-8.4 postgresql-client-8.4 postgresql-contrib-8.4Run the preceding command to install psql on the server and command line client.
/Usr/lib/postgresql/8.4/Stores postgresql-related
Accustomed to MySQL, want to try to use the next PostgreSQL, it is said that this thing is also very strong, I searched the Internet related Chinese books, but the related books are far less than MySQL, but I found in the official translation by the
Backup and restore are most important when you are transporting a database. Today, we tested backup and restore using Pg_dumpall.
Backup Restore method: Pg_dump and Pg_restore, first carefully explain these two commands
Back up the database,
PostgreSQL tutorial (18): client commands (2), postgresql tutorial
VII. pg_dump:
Pg_dump is a tool used to back up PostgreSQL databases. It can even perform a full and consistent backup when the database is being used concurrently without blocking
I used MySQL and wanted to try PostgreSQL. It is said that it is also very powerful. I searched the internet for related Chinese books. Unfortunately, there are far fewer books than MySQL, however, I found documents translated by volunteers on the
This document describes how to install the PostgreSQL8.3.3 database using the source code on RedHatEnterpriseLinuxServer5 and install the database using the root user. 1. Download P
This article describes how to install the PostgreSQL8.3.3 database
This article describes how to install the PostgreSQL8.3.3 database with the source code on Red Hat Enterprise Linux Server 5 and install it with the root user.
1. Download the source code package corresponding to PostgreSQL8.3.3 on the Linux
Work of some content, this is China Mobile group's current Linux machine security compliance standards, find some time to classify it, and check out some information, what each configuration means, not only to know it, but also to know its why. A
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.