pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres 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