Unix Technical Forum

restarting postmaster

This is a discussion on restarting postmaster within the pgsql Admins forums, part of the PostgreSQL category; --> My system is Fedora Core 7 running postgresql 8.2.3-2. I can shutdown postgres and the postmaster with the single ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Admins

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-10-2008, 09:19 AM
Marc Fromm
 
Posts: n/a
Default restarting postmaster

My system is Fedora Core 7 running postgresql 8.2.3-2.

I can shutdown postgres and the postmaster with the single command
"pg_ctl stop -m smart."

According to the documentation I can restart the postmaster with "pg_ctl
start." When I enter pg_ctl start, everything starts except the
postmaster.
Checking ps ax | grep post displays 4 postgres processes and no
postmaster.

If I run "service postgresql start" instead of "pg_ctl start" then
everything starts, including the postmaster.

How come "pg_ctl start" does not start the postmaster?
Why does "service postgresql start" start the postmaster and all of
postgres, but it is not mentioned in the documentation?

What is the correct way to stop and start postgresql?

thanks

Marc Fromm
Information Technology Specialist II
Financial Aid Department
Western Washington University
Phone: 360-650-3351
Fax: 360-788-0251


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://mail.postgresql.org/mj/mj_www...ra=pgsql-admin

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-10-2008, 09:19 AM
Tom Lane
 
Posts: n/a
Default Re: restarting postmaster

"Marc Fromm" <Marc.Fromm@wwu.edu> writes:
> My system is Fedora Core 7 running postgresql 8.2.3-2.
> I can shutdown postgres and the postmaster with the single command
> "pg_ctl stop -m smart."


> According to the documentation I can restart the postmaster with "pg_ctl
> start." When I enter pg_ctl start, everything starts except the
> postmaster.
> Checking ps ax | grep post displays 4 postgres processes and no
> postmaster.


One of them is the postmaster.

postmaster and postgres are identical in recent PG releases;
what you're looking at is just a difference between pg_ctl and
the initscript about which name they choose to use.

regards, tom lane

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://mail.postgresql.org/mj/mj_www...ra=pgsql-admin

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 10:49 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com