Re: Postgres is not starting or stopping

["Shoaib Mir" <shoaibmir@xxxxxxxxx>]

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@xxxxxxxxx > 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@xxxxxxxxx> 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@xxxxxxxxx> 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.