Re: Postgres error - Mailing list pgsql-admin

From Paul Lambert
Subject Re: Postgres error
Date
Msg-id 464D3F76.4040302@autoledgers.com.au
Whole thread Raw
In response to Re: Postgres error  (Ritu Khetan <RKhetan@crisil.com>)
List pgsql-admin
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


pgsql-admin by date:

Previous
From: "Ashish Karalkar"
Date:
Subject: Re: Postgres error
Next
From: Stephane Bailliez
Date:
Subject: Frequent pg_clog on system