Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 93BAE9FB1DD for ; Fri, 2 Feb 2007 10:15:54 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 01121-03 for ; Fri, 2 Feb 2007 10:15:41 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.231]) by postgresql.org (Postfix) with ESMTP id D2C739FA4CD for ; Fri, 2 Feb 2007 10:15:40 -0400 (AST) Received: by nz-out-0506.google.com with SMTP id i11so837254nzh for ; Fri, 02 Feb 2007 06:15:37 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=MjYkjTzad48MQPNIZ3eiyMKspNLjfOgr/6WPFZ3IMf2B3rJTUqkXo+VhrNqSwwz/AY25d/SyqItHyc/6i2iwaZ4guQ8ahJNXCzqQ1bTD8zRk4En2YnMuFfjPF9Cfu8klKHNFyjhr+4SU6s1qGaoyJehowqyzyrxU/5MK7RZtuyk= Received: by 10.64.185.7 with SMTP id i7mr6098678qbf.1170425737393; Fri, 02 Feb 2007 06:15:37 -0800 (PST) Received: by 10.65.206.17 with HTTP; Fri, 2 Feb 2007 06:15:37 -0800 (PST) Message-ID: Date: Fri, 2 Feb 2007 19:15:37 +0500 From: "Shoaib Mir" To: "Manish Pillai" Subject: Re: Postgres is not starting or stopping Cc: pgsql-admin@postgresql.org In-Reply-To: <878936.26029.qm@web52313.mail.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_15989_30603840.1170425737022" References: <878936.26029.qm@web52313.mail.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/22 X-Sequence-Number: 24487 ------=_Part_15989_30603840.1170425737022 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 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 * 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 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 > > . > > > > > > > ------------------------------ > Want to start your own business? Learn how on Yahoo! Small Business. > > ------=_Part_15989_30603840.1170425737022 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 .



Want to start your own business? Learn how on Yahoo! Small Business.


------=_Part_15989_30603840.1170425737022--