>> 3... switzerland's largest cinema website moved from
>> sql server to
>> postgresql two months ago. lost some comfort
>> (automated backups, jobs) but
>> gained lot of performance, stability... and last but
>> not least, budget! ;-)
>
> Thomas, can't pgsql backups be autmoated via cron
> jobs? i think it is a bit more complex than point and
> click, but once you know how, it isn't and issue
> anymore.
>
> speaking of knowing how... i'll be asking just this
> question in the future. ;-)
of course it can. but it's not as comfortable as through an internal db
scheduling job. in mssql, you also could schedule just about anything...
like reindex, data integrity checks, etc.. all of these can be handled
through a cron job or a windows task as well, but its kinda an external
process compared to the way it is done in mssql.
i saw internal schedule jobs already being on the wishlist for future pgsql
versions :-)
cheers,
thomas