Skip site navigation (1) Skip section navigation (2)

Re: Postgres error

From: Paul Lambert <paul(dot)lambert(at)autoledgers(dot)com(dot)au>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgres error
Date: 2007-05-18 05:53:58
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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 

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 
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

In response to

pgsql-admin by date

Next:From: Stephane BailliezDate: 2007-05-18 10:08:05
Subject: Frequent pg_clog on system
Previous:From: Ashish KaralkarDate: 2007-05-18 05:29:51
Subject: Re: Postgres error

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group