Re: Postgres is not starting or stopping

"Andy Shellam (Mailing Lists)" <andy.shellam-lists@xxxxxxxxxxxxxxxxx> · Fri, 02 Feb 2007 14:53:54 +0000

You will always have a postmaster binary - do a "find / -name
postmaster" to find it.

If your secondary production server hasn't gone live yet, I'd seriously
consider starting it up on the 8.2 series.

Manish Pillai wrote:

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

  Manish

  Shoaib Mir <shoaibmir@xxxxxxxxx> 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@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.  

Finding fabulous fares is fun.

  Let
Yahoo! FareChase search your favorite travel sites to find flight
and hotel bargains.
!DSPAM:37,45c34f2c118211085466303!

-- 
Andy Shellam
NetServe Support Team

the Mail Network
"an alternative in a standardised world"

p: +44 (0) 121 288 0832/0839
m: +44 (0) 7818 000834