Forum OpenACS Q&A: OpenACS instance not stable...

Collapse
Posted by MK Tam on
Hi,

I get my Openacs instance installed and started sucessfully, but
after a few hours the AOLserver kills itself and I receive error
messages:

[05/May/2001:04:01:22]
    Error: Ns_PgOpenDb(postgres):  Could not connect to
localhost::hric:  The Data Base System is in recovery mode

[05/May/2001:04:01:22]
    Error: dbinit: error(localhost::hric,pqReadData() -- backend
closed the channel unexpectedly.
    This probably means the backend terminated abnormally
    before or while processing the request.
    ): 'select a.oid, a.user_id, a.first_names, a.last_name,
a.birthmonth, a.birthday, a.days_in_advance_to_remind,
a.date_last_reminded, a.days_in_advance_to_remind_2,
a.date_last_reminded_2
    from address_book a, users_alertable
    where a.user_id=users_alertable.user_id
    and a.birthmonth is not null
    and a.birthday is not null
    and (a.days_in_advance_to_remind is not null or
a.days_in_advance_to_remind_2 is not null)'

The master server (I user nsvhr/nsunix for virtual hosting serveral
OpenACS instances) and Postgres are still running.

Any advice?

I use the following command line to start postgres:

bin/postgres -N 100 -B 200 -SD /usr/local/pgsql/data

Thanks.

Collapse
Posted by Ben Adida on
What version of PostgreSQL are you using?
Collapse
Posted by MK Tam on
I use Postgres7.03.  But the problem is solved after I give up using pgdump when migrating the database. I create all the tables again and just ports in data.  This works without problem.

Thanks.