Re: Postgres is not starting or stopping

I have installed it using rpm..So "bin" folder is not available inside pgsql :-(

Manish

Shoaib Mir <shoaibmir(at)gmail(dot)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(at)yahoo(dot)com > wrote: Hi,

I am getting only this much...

[root(at)KLC2 init.d]# ./postgresql restart
Stopping postgresql service: [FAILED]
Starting postgresql service: [FAILED]
[root(at)KLC2 init.d]#

How to enable log in postgres...Please help

Regards
Manish

Shoaib Mir < shoaibmir(at)gmail(dot)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(at)yahoo(dot)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.