PostgreSQL Backup and Restore: Backup and restore PostgreSQL databases with files

Recommend this page to a friend!
  Info   View files View files (3)   DownloadInstall with Composer Download .zip   Reputation   Support forum (3)   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 70%Total: 1,945 This week: 1All time: 2,005 This week: 259Up
Version License PHP version Categories
pgbackuprestore 1.0.0Public Domain4.0Databases, Systems administration
Description Author

This class can be used to generate backups of PostgreSQL.

It accesses a given database and generates SQL statements that can be used to recreate the database tables and the values stored on their rows. The generated SQL is stored in a given file.

The class can also restore a database from a previously generated backup by executing the SQL statements stored in a backup file.

Innovation Award
PHP Programming Innovation award nominee
September 2007
Number 9
PostgreSQL is a very popular Open Source database. It may not be as popular as MySQL, but it has many users that prefer PostgreSQL over MySQL.

There are plenty of tools and components that generate backup copies of MySQL databases by generating SQL statements to recreate the tables and contents of their records. However, for PostgreSQL the offer of similar tools is scarce.

This class addresses that gap by providing to PosgreSQL users a similar solution based only on pure PHP code.

Manuel Lemos
Picture of Michele Brodoloni
  Performance   Level  
Name: Michele Brodoloni <contact>
Classes: 6 packages by
Country: Italy Italy
Age: 35
All time rank: 2508 in Italy Italy
Week rank: 136 Up6 in Italy Italy Up
Innovation award
Innovation award
Nominee: 3x

  Files folder image Files  
File Role Description
Accessible without login Plain text file example.php Example Example
Plain text file pgBackupRestore.class.php Class Class file
Plain text file pgBackupRestore2.class.php Class New class file!

 Version Control Unique User Downloads Download Rankings  
 0%
Total:1,945
This week:1
All time:2,005
This week:259Up
User Ratings User Comments (3)
 All time
Utility:100%StarStarStarStarStarStar
Consistency:100%StarStarStarStarStarStar
Documentation:-
Examples:100%StarStarStarStarStarStar
Tests:-
Videos:-
Overall:70%StarStarStarStar
Rank:384
 
Excelent
3 years ago (jesus rodriguez)
70%StarStarStarStar
the sql file generated by backup class doesnt works to restor...
7 years ago (Alone Nascimento)
35%StarStar
very good and useful class.
11 years ago (Ji&#345;)
65%StarStarStarStar
 

For more information send a message to info at phpclasses dot org.