PHP Classes
elePHPant
Icontem

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    
Last Updated Ratings Unique User Downloads Download Rankings
2007-11-30 (9 years ago) RSS 2.0 feedStarStarStarStar 70%Total: 1,847 This week: 2All time: 2,084 This week: 395Up
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
  Performance   Level  
Name: Michele Brodoloni <contact>
Classes: 6 packages by
Country: Italy Italy
Age: 31
All time rank: 2548 in Italy Italy
Week rank: 244 Up8 in Italy Italy Equal
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,847
This week:2
All time:2,084
This week:395Up
User Ratings User Comments (3)
 All time
Utility:100%StarStarStarStarStarStar
Consistency:100%StarStarStarStarStarStar
Documentation:-
Examples:100%StarStarStarStarStarStar
Tests:-
Videos:-
Overall:70%StarStarStarStar
Rank:332
 
Excelent
8 months ago (jesus rodriguez)
70%StarStarStarStar
the sql file generated by backup class doesnt works to restor...
4 years ago (Alone Nascimento)
35%StarStar
very good and useful class.
8 years ago (Ji&#345;)
65%StarStarStarStar