Re: Postgres error

Ritu Khetan wrote:
>
>
>
>
> Hi Paul,
>
> The service does not start , hence we tried it through the command prompt
> to check what is the error.
>
> Any thoughts?
>
> Regards,
> Ritu
>
>
>

Are you presented with any particular error when you try starting the
service?

Have you checked the event viewer log?

If you check in task manager and there are NO postmaster processes
running, then check the data directory and delete the postmaster.pid
file if it exists, then give the service a restart.

Failing that, check the logs in data/pg_log.

Check that the user the pg service is running under hasn't lost write
permissions to the directory. (E:/crisilfe/crisil/pgsql/data)

--
Paul Lambert
Database Administrator
AutoLedgers