I have a postgresql 7.0.2 server running on a linux box. I have a number of
views that I have converted to tables in order to improve performance. I
need these tables to be deleted and re-created daily and using a script
through cron would work beautifully.
Is it possible to require all used to have a password to log ont the
database, but allow the cron job to connect (through jdbc) without needing a
password? that way I would not have to put the password in plain text in
the script.
Thanks,
Travis