14 June 2011, 4:01

I was just checking through my backups before updating to 1.4 and noticed that my mahara mysql database is completely empty with no tables or records?

then I realised that I am using postgres!

Can anyone let me know how I can see or backup a postgres database as I am used to mysql!

I have it linked to my moodle site but surely I should have something?

Can anyone help?

thanks

14 June 2011, 7:44

I found the command to get to phppgadmin and that sorted me out!

14 June 2011, 7:50

Hi Reg,

Without knowing what Operating System you're using, or what access you have (e.g. cpanel), it's difficult to know what the best method is for you. That said, if you're running a Linux-based system, then your best option is to use pg_backup.

You should be able to do so relatively easily with a cron job, running as your postgres user (e.g postgres) and dumping to a file.

In Mahara, we far prefer Postgresql over MySQL for a whole host reasons.

14 June 2011, 8:36

Hi Andrew, I used pg_backup in the end and everything is happy now!

Thanks