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
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???
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
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