PHP Classes

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

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 63%Total: 1,979 All time: 1,991 This week: 455Up
Version License PHP version Categories
pgbackuprestore 1.0.0Public Domain4.0Databases, Systems administration
Description 

Author

Michele Brodoloni

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: Ireland Ireland
Age: 39
All time rank: 2491 in Ireland Ireland
Week rank: 195 Up2 in Ireland Ireland Down

Level 1 Star

 Innovation award
Innovation award
Nominee: 3x

  Files folder image Files (3)  
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!

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloadpgbackuprestore-2007-11-30.zip 11KB
Downloadpgbackuprestore-2007-11-30.tar.gz 7KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:1,979
This week:0
All time:1,991
This week:455Up
User Ratings User Comments (3)
 All time
Utility:90%StarStarStarStarStar
Consistency:90%StarStarStarStarStar
Documentation:-
Examples:90%StarStarStarStarStar
Tests:-
Videos:-
Overall:63%StarStarStarStar
Rank:875
 
Excelent
8 years ago (jesus rodriguez)		70%StarStarStarStar
the sql file generated by backup class doesnt works to restor...
11 years ago (Alone Nascimento)		35%StarStar
very good and useful class.
15 years ago (Ji&#345;í)		65%StarStarStarStar
 

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.


  Pages that reference this package  
Phpclasses.org is the best one of my favorite sites...

Latest pages that reference packages Latest pages that reference packages