add automated backup functionality for PostgreSQL

CyberKate - March 31, 2006 - 07:01
Project:Database Administration
Version:4.6.x-1.x-dev
Component:PostgreSQL Support
Category:feature request
Priority:critical
Assigned:Unassigned
Status:active
Description

Hi !

I use Drupal 4.6.5 with PostgreSQL and I have installed this DBA module.

When an automatical backup is created, it's kinda weird because it misses fields and types of fields in all table structures.

I have for instance :

DROP TABLE IF EXISTS blocks;
CREATE TABLE blocks (
NOT NULL,
NOT NULL,
NOT NULL,
NOT NULL,
NOT NULL,
NOT NULL,
NOT NULL,
NOT NULL,
NOT NULL,
NOT NULL
) TYPE=MyISAM;

Any idea how it could generate a backup compatible with PostgreSQL ?

Thanks in advance.

#1

Jeremy - March 31, 2006 - 11:57
Category:support request» feature request

Sorry, the backup functionality was only created for MySQL. I'd be more than happy to merge a patch that adds the functionality for PostgreSQL too. Anyone up to the challenge?

#2

CyberKate - March 31, 2006 - 13:42

Thanks for the answer. :)

I'd love someone to do the patch, it would help a lot of people, including me ! ;)

#3

dww - November 19, 2006 - 19:27
Title:Backups misses fields and types of fields» add automated backup functionality for PostgreSQL
 
 

Drupal is a registered trademark of Dries Buytaert.