Обсуждение: Postgres is not starting or stopping

---

Need a quick answer? Get one in minutes from people who know. Ask your question on Yahoo! Answers.

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)

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.

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)

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.

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

>>        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
>>

Unless you have turned it off logging is on by default (with minimum
setting)

Your prob may be knowing where the log is. By default you will find it
in your data directory along with postgresql.conf and it will be called
serverlog

tail that file (as root) and see what shows up there



--

Shane Ambler
pgSQL@007Marketing.com

Get Sheeky @ http://Sheeky.Biz

Shane Ambler wrote:
>
>>>        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
>>>
>
> Unless you have turned it off logging is on by default (with minimum
> setting)
>
> Your prob may be knowing where the log is. By default you will find it
> in your data directory along with postgresql.conf and it will be called
> serverlog
>
> tail that file (as root) and see what shows up there

likely /var/log/postgresql

What linux is this?

>
>
>


--

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

"Joshua D. Drake" <jd@commandprompt.com> writes:
> Shane Ambler wrote:
>> Your prob may be knowing where the log is. By default you will find it
>> in your data directory along with postgresql.conf and it will be called
>> serverlog

> likely /var/log/postgresql
> What linux is this?

There are enough different initscripts out there that the only way to be
sure is to look at the initscript and see what it's doing with the
postmaster's stderr output.  It's not too unlikely that it's sending it
to /dev/null, in which case your only hope of finding out what's going
wrong is to change the script.

Or you could try launching the postmaster manually as someone
recommended upthread, but that may well fail to show the problem.

            regards, tom lane

Hello,

On Fri, 2007-02-02 at 06:08 -0800, Manish Pillai wrote:
>   [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

The startup problems appear in /var/lib/pgsql/pgstartup.log , when
installed from RPMs. You will find the possible cause of the error
there.

Regards,
--
Devrim GÜNDÜZ
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/