Hi Mark!
Postgres should work well - I use it since ser 0.8. Just make sure that
the hard disk does not get full, because this breaks the index inside
postgres and postgres is getting real slow (re-create the index if it
happens).
Last time I tested openser_postgres.sh it worked fine. If you find a bug
please let us know.
Please check to use the latest versions from CVS (for 1.1 use CVS rel_1_1_0)
regards
klaus
Mark Price wrote:
Hi,
What is the best way to use postgres with openser?
Is postgres a viable option?
I ask, because the install script appears to be broken.
If I am able to fix it well enough create the necessary tables,
will it be fit for use?
As an example, there are several errors in the openser_postgres.sh that
comes with openser 1.1
In particular, there are instances where the following is done:
create table a (
field type,
index a_idx(field)
);
However, postgres requires syntax like this:
create table a (
field type
);
create index a_idx on a (field);
Thanks.
------------------------------------------------------------------------
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
--
Klaus Darilion
nic.at