Re: [GENERAL] Postgresql Backups

2009-08-10 Thread sub_woofer
Hello all Thank you very much for your responses! I realised that the restores were not working as the databases were not being...backed up!...oops! After I did the reinstallation of the OS I forgot to give permissions in postgresql for the user doing the backup in ubuntu! I have fixed this. I

[GENERAL] Postgresql Backups

2009-08-06 Thread sub_woofer
Hello all To backup my postgresql data I use the pg_dumpall command which dumps all my databases to a .sql file. If I would like to restore a single database from this file how would I do this? Is it possible using PgAdmin - as this only allows us to restore a database from a .backup file???

Re: [GENERAL] Trigger error

2009-04-17 Thread sub_woofer
Hi Thank you both for your responses and apologies for the late reply! Tom you were correct! :) I split the If statements into 2 for the old and new tests and it all worked! :) Thanks once again for all your help! :) t. Tom Lane-2 wrote: sub_woofer tqzeli...@yahoo.co.uk writes

[GENERAL] Trigger error

2009-04-15 Thread sub_woofer
Hi All Its been some time since I did any work using triggers/pgsql and when I did, it was pretty much basic stuff. Ive now returned to developing apps using postgres and have run into an error when using a trigger that I wrote a few years back (which worked fine then) but doesnt seem to work