Hi,
I'm looking to convert from Mailwatch to baruwa 2.0 on a gentoo system
and I've run into some issues, most of which I have been able to fix.
Right now, I'm stuck in the test phase.
I'm using Postgresql 9.2.3
Firstly, when I tried to run "indexer --all --rotate", I was getting a
bunch of errors relating to FUNCTION UNIX_TIMESTAMP(TIMESTAMP WITH TIME
ZONE)
After some searching, I found possible fixes for this. For example:
CREATE OR REPLACE FUNCTION UNIX_TIMESTAMP(TIMESTAMP WITH TIME ZONE)
RETURNS BIGINT
LANGUAGE SQL
IMMUTABLE STRICT
AS 'SELECT EXTRACT(EPOCH FROM $1)::bigint;';
Now I'm seeing another set of errors:
WARNING: sql_query_post[0]: error=ERROR: function
update_indexer_counters(unknown, timestamp without time zone) does not exist
LINE 1: SELECT update_indexer_counters('archive_delta_tmp', get_var(...
^
HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
, query=SELECT update_indexer_counters('archive_delta_tmp',
get_var('archive_maxtsdelta'))
If I skip this and run the test server, I get a bunch of these errors:
AttributeError: 'NoneType' object has no attribute 'twophase'
Are there particular supported versions of the prerequesites that we
should be using?
Thanks in advance for any help.
Jeff
_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056