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: 464D3F76.4040302@autoledgers.com.au (view raw or flat)
Thread:
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 
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


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-2014 The PostgreSQL Global Development Group