pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Shoaib Mir <shoaibmir@gmail.com>
To: Manish Pillai <manishg_pillai@yahoo.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Postgres is not starting or stopping
Date: Fri, 2 Feb 2007 19:15:37 +0500
Message-ID: <bf54be870702020615s326f7d53yb88a86767bccfd33@mail.gmail.com> (raw)
In-Reply-To: <878936.26029.qm@web52313.mail.yahoo.com>
References: <bf54be870702020557m3aed4cd4j260de3e5191ea5a9@mail.gmail.com>
	<878936.26029.qm@web52313.mail.yahoo.com>

Instead of starting with the service, trying starting up with 'postmaster'
binary. It can be found in the database server 'bin' folder and that should
give a little more detail failure message.

To enable logging please go through --> "16.4.5. Error Reporting and
Logging" at
http://www.postgresql.org/docs/7.4/interactive/runtime-config.html

--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 2/2/07, Manish Pillai <manishg_pillai@yahoo.com> wrote:
>
> Hi,
>
>        I am getting only this much...
>
> [root@KLC2 init.d]# ./postgresql restart
> Stopping postgresql service:                               [FAILED]
> Starting postgresql service:                               [FAILED]
> [root@KLC2 init.d]#
>             How to enable log in postgres...Please help
>
> Regards
> Manish
>
>
>
>
> *Shoaib Mir <shoaibmir@gmail.com>* wrote:
>
> If you can tell the specific error on start/stop then someone might be
> able to help you with this...
>
> --
> Shoaib Mir
> EnterpriseDB (www.enterprisedb.com)
>
> On 2/2/07, Manish Pillai <manishg_pillai@yahoo.com> wrote:
> >
> > Hi all,
> >
> >
> >      I have two production server .One ia already live and the other is
> > going to live soon.
> >
> > In the 1st server i have postgres 7.4.6 and having no problem
> >
> > In the second server we have postgres (PostgreSQL) 7.4.15. Here i have
> > made a mistake. I have removed postgresql.conf and pg_hba.conf and kept
> > the same files from the first server (7.4.6).
> >
> >
> >  After this process the postgres is not able to start/stop. Then i
> > removed the two files which i have copied from the first server and copied
> > the the orginal files to the exact place (/var/lib/pgsql/data).But still the
> > database is not able to start or stop..
> >
> >
> > Please help if u have any idea
> >
> > Regards
> > Manish
> >
> >  ------------------------------
> > Need a quick answer? Get one in minutes from people who know. Ask your
> > question on Yahoo! Answers
> > <http://answers.yahoo.com/;_ylc=X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTEwOARfcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnb...;.
> >
> >
>
>
> ------------------------------
> Want to start your own business? Learn how on Yahoo! Small Business.<http://us.rd.yahoo.com/evt=41244/*http://smallbusiness.yahoo.com/r-index;
>
>

view thread (10+ messages)  latest in thread

Message-ID: <bf54be870702020615s326f7d53yb88a86767bccfd33@mail.gmail.com>
Permalink:  ../bf54be870702020615s326f7d53yb88a86767bccfd33@mail.gmail.com/
Also on:    postgresql.org/message-id/bf54be870702020615s326f7d53yb88a86767bccfd33@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: shoaibmir@gmail.com, manishg_pillai@yahoo.com
  Subject: Re: Postgres is not starting or stopping
  In-Reply-To: <bf54be870702020615s326f7d53yb88a86767bccfd33@mail.gmail.com>
  References: <bf54be870702020557m3aed4cd4j260de3e5191ea5a9@mail.gmail.com> <878936.26029.qm@web52313.mail.yahoo.com> <bf54be870702020615s326f7d53yb88a86767bccfd33@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox