Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 51B7D9FB283 for ; Fri, 2 Feb 2007 10:47:31 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 82380-10 for ; Fri, 2 Feb 2007 10:47:11 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web52302.mail.yahoo.com (web52302.mail.yahoo.com [206.190.48.145]) by postgresql.org (Postfix) with SMTP id 1576B9FA4CD for ; Fri, 2 Feb 2007 10:47:15 -0400 (AST) Received: (qmail 5858 invoked by uid 60001); 2 Feb 2007 14:47:13 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=jP3EEX+AFm01fWnFWoEBLrSGY4qGM1q3Oc0hh0ufpfJL9dGG6yjEUdXm09iHA6kN+da8CllT8sO7jDRjlDgcYgCeWf+vLXNvfSULqGPvDnA7ASIhi4iVdYeZDyFpOa+JR65k5xbKADsREBhnAJNupc+UCymhu00qUtD+aviGU78=; X-YMail-OSG: tsZHYPIVM1n4KhkHlbV4bVqltVOHDlDvxzdGDgrIaCP4m5BoBjIsSGdWxKSx57g4WBZIIMlhuUwE_TXDEt1KMiiKU.iJL5GcC7HG8yU7LcDb7JRGuKVm.BI8NVMujcIGUvYVj8PVtQgsLLU- Received: from [61.95.207.84] by web52302.mail.yahoo.com via HTTP; Fri, 02 Feb 2007 06:47:12 PST Date: Fri, 2 Feb 2007 06:47:12 -0800 (PST) From: Manish Pillai Subject: Re: Postgres is not starting or stopping To: Shoaib Mir Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-765406636-1170427632=:5361" Content-Transfer-Encoding: 8bit Message-ID: <114814.5361.qm@web52302.mail.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/23 X-Sequence-Number: 24488 --0-765406636-1170427632=:5361 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit I have installed it using rpm..So "bin" folder is not available inside pgsql :-( Manish Shoaib Mir wrote: 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 < 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 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. --------------------------------- Finding fabulous fares is fun. Let Yahoo! FareChase search your favorite travel sites to find flight and hotel bargains. --0-765406636-1170427632=:5361 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
I have installed it using rpm..So  "bin" folder is not available inside pgsql :-(
 
Manish
 
 


Shoaib Mir <shoaibmir@gmail.com> wrote:
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.



Finding fabulous fares is fun.
Let Yahoo! FareChase search your favorite travel sites to find flight and hotel bargains. --0-765406636-1170427632=:5361--