pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Postgres is not starting or stopping
10+ messages / 7 participants
[nested] [flat]

* Postgres is not starting or stopping
@ 2007-02-02 13:50  Manish Pillai <manishg_pillai@yahoo.com>
  0 siblings, 1 reply; 10+ messages in thread

From: Manish Pillai @ 2007-02-02 13:50 UTC (permalink / raw)
  To: pgsql-admin

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.

^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: Postgres is not starting or stopping
@ 2007-02-02 13:57  Shoaib Mir <shoaibmir@gmail.com>
  parent: Manish Pillai <manishg_pillai@yahoo.com>
  0 siblings, 1 reply; 10+ messages in thread

From: Shoaib Mir @ 2007-02-02 13:57 UTC (permalink / raw)
  To: Manish Pillai <manishg_pillai@yahoo.com>; +Cc: pgsql-admin

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<http://answers.yahoo.com/;_ylc=X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTEwOARfcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnb...;
> .
>
>

^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: Postgres is not starting or stopping
@ 2007-02-02 14:08  Manish Pillai <manishg_pillai@yahoo.com>
  parent: Shoaib Mir <shoaibmir@gmail.com>
  0 siblings, 2 replies; 10+ messages in thread

From: Manish Pillai @ 2007-02-02 14:08 UTC (permalink / raw)
  To: Shoaib Mir <shoaibmir@gmail.com>; +Cc: pgsql-admin

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.

^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: Postgres is not starting or stopping
@ 2007-02-02 14:15  Shoaib Mir <shoaibmir@gmail.com>
  parent: Manish Pillai <manishg_pillai@yahoo.com>
  1 sibling, 2 replies; 10+ messages in thread

From: Shoaib Mir @ 2007-02-02 14:15 UTC (permalink / raw)
  To: Manish Pillai <manishg_pillai@yahoo.com>; +Cc: pgsql-admin

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
> > <http://answers.yahoo.com/;_ylc=X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTEwOARfcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnb...;.
> >
> >
>
>
> ------------------------------
> Want to start your own business? Learn how on Yahoo! Small Business.<http://us.rd.yahoo.com/evt=41244/*http://smallbusiness.yahoo.com/r-index;
>
>

^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: Postgres is not starting or stopping
@ 2007-02-02 14:47  Manish Pillai <manishg_pillai@yahoo.com>
  parent: Shoaib Mir <shoaibmir@gmail.com>
  1 sibling, 1 reply; 10+ messages in thread

From: Manish Pillai @ 2007-02-02 14:47 UTC (permalink / raw)
  To: Shoaib Mir <shoaibmir@gmail.com>; +Cc: pgsql-admin

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.

^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: Postgres is not starting or stopping
@ 2007-02-02 14:53  Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>
  parent: Manish Pillai <manishg_pillai@yahoo.com>
  0 siblings, 0 replies; 10+ messages in thread

From: Andy Shellam (Mailing Lists) @ 2007-02-02 14:53 UTC (permalink / raw)
  To: Manish Pillai <manishg_pillai@yahoo.com>; +Cc: pgsql-admin

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 <http://www.enterprisedb.com/;)
>
>     On 2/2/07, *Manish Pillai* <manishg_pillai@yahoo.com
>     <mailto: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
>         <mailto: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
>             <http://www.enterprisedb.com/;)
>
>             On 2/2/07, *Manish Pillai* <manishg_pillai@yahoo.com
>             <mailto: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
>                 <http://answers.yahoo.com/;_ylc=X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTEwOARfcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnb...;.
>
>
>
>
>         ------------------------------------------------------------------------
>         Want to start your own business? Learn how on Yahoo! Small
>         Business.
>         <http://us.rd.yahoo.com/evt=41244/*http://smallbusiness.yahoo.com/r-index;
>
>
>
>
> ------------------------------------------------------------------------
> Finding fabulous fares is fun.
> Let Yahoo! FareChase search your favorite travel sites 
> <http://farechase.yahoo.com/promo-generic-14795097;_ylc=X3oDMTFtNW45amVpBF9TAzk3NDA3NTg5BF9zAzI3MTk0O...; 
> 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

^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: Postgres is not starting or stopping
@ 2007-02-02 20:33  Shane Ambler <pgsql@007Marketing.com>
  parent: Shoaib Mir <shoaibmir@gmail.com>
  1 sibling, 1 reply; 10+ messages in thread

From: Shane Ambler @ 2007-02-02 20:33 UTC (permalink / raw)
  To: Shoaib Mir <shoaibmir@gmail.com>; +Cc: Manish Pillai <manishg_pillai@yahoo.com>; pgsql-admin


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



^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: Postgres is not starting or stopping
@ 2007-02-02 20:44  Joshua D. Drake <jd@commandprompt.com>
  parent: Shane Ambler <pgsql@007Marketing.com>
  0 siblings, 1 reply; 10+ messages in thread

From: Joshua D. Drake @ 2007-02-02 20:44 UTC (permalink / raw)
  To: Shane Ambler <pgsql@007Marketing.com>; +Cc: Shoaib Mir <shoaibmir@gmail.com>; Manish Pillai <manishg_pillai@yahoo.com>; pgsql-admin

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/




^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: Postgres is not starting or stopping
@ 2007-02-02 21:04  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Joshua D. Drake <jd@commandprompt.com>
  0 siblings, 0 replies; 10+ messages in thread

From: Tom Lane @ 2007-02-02 21:04 UTC (permalink / raw)
  To: Joshua D. Drake <jd@commandprompt.com>; +Cc: Shane Ambler <pgsql@007Marketing.com>; Shoaib Mir <shoaibmir@gmail.com>; Manish Pillai <manishg_pillai@yahoo.com>; pgsql-admin

"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



^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: Postgres is not starting or stopping
@ 2007-02-03 20:43  Devrim GUNDUZ <devrim@CommandPrompt.com>
  parent: Manish Pillai <manishg_pillai@yahoo.com>
  1 sibling, 0 replies; 10+ messages in thread

From: Devrim GUNDUZ @ 2007-02-03 20:43 UTC (permalink / raw)
  To: Manish Pillai <manishg_pillai@yahoo.com>; +Cc: Shoaib Mir <shoaibmir@gmail.com>; pgsql-admin

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/

Attachments:

  signature.asc (application/pgp-signature, 188B) download

^ permalink  raw  reply  [nested|flat] 10+ messages in thread


end of thread, other threads:[~2007-02-03 20:43 UTC | newest]

Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-02-02 13:50 Postgres is not starting or stopping Manish Pillai <manishg_pillai@yahoo.com>
2007-02-02 13:57 ` Shoaib Mir <shoaibmir@gmail.com>
2007-02-02 14:08   ` Manish Pillai <manishg_pillai@yahoo.com>
2007-02-02 14:15     ` Shoaib Mir <shoaibmir@gmail.com>
2007-02-02 14:47       ` Manish Pillai <manishg_pillai@yahoo.com>
2007-02-02 14:53         ` Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>
2007-02-02 20:33       ` Shane Ambler <pgsql@007Marketing.com>
2007-02-02 20:44         ` Joshua D. Drake <jd@commandprompt.com>
2007-02-02 21:04           ` Tom Lane <tgl@sss.pgh.pa.us>
2007-02-03 20:43     ` Devrim GUNDUZ <devrim@CommandPrompt.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox