postgresql导出和导入（PostgreSQL export and import）.docVIP

postgresql导出和导入（PostgreSQL export and import） Export and import PostgreSQL 2008-05-03 statement 16:54:43| classification: database | Tags: | name and subscription. Using pg_dump, no object can database (text format) file name: pg_dump libname; A large object can also pg_dump -o -Ft -b libname: file name; Research on backup and recovery of Postgresql Preface： Like any thing that contains valuable data, the PostgreSQL database should also be backed up frequently. Although this process is fairly simple, we should still understand some of the techniques and assumptions used to do it. There are three completely different ways of backing up PostgreSQL data: 1.SQL dumps (similar to Oracles exp, imp,) 2. file system level backup (that is, Oracle cold backup). Down drop database. Then copy the files in the data directory 3. online backup (similar to Oracle Archive Mode backup). Each backup has its own advantages and disadvantages. Due to the limited time and space: the method of SQL dump is only focused on. This method is also the most commonly used and convenient method for logical backup and recovery. Ill focus on the SQL dump below The idea of the SQL dump method is to create a text file that contains the SQL command, which will be rebuilt and dumped when the file is fed back to the server Sample database. PostgreSQL provides the application tool pg_dump for this purpose. The basic use of this command is: Pg_dump dbname outfile As you can see, pg_dump outputs the results to standard output. As we can see below, what is the advantage of doing so?. Pg_dump is an ordinary PostgreSQL client application (albeit a rather smart one) This means that you can access the remote host from any database that you can access Backup work. Remember, however, that pg_dump does not run with any special privileges. Specifically, it must have the read permission of the table you want to backup, so, in fact, youre almost Always be a database super user. To declare which user the pg_dump shou