Postgres Pro
Downloads
Home   >   mailing lists

Thread: Postgres at startup

Postgres at startup

From
"Michael McCloskey"
Date:

Postgres is starting automatically for me at startup.

When I boot up my machine and then check the running processes I see postmaster.exe and 4 postgres processes.

How can I stop this?

I don’t want Postgres starting up automatically.

Thanks.

-Michael

Re: Postgres at startup

From
Kis János Tamás
Date:
2006. November 8. 02.34 dátummal Michael McCloskey ezt írta:
> Postgres is starting automatically for me at startup.
> When I boot up my machine and then check the running processes I
> see postmaster.exe and 4 postgres processes.
> How can I stop this?
PGBIN="/usr/local/pgsql/bin";
PGDATA="/srv/postgresql";
su postgres -c "$PGBIN/pg_ctl -D $PGDATA stop"

> I don't want Postgres starting up automatically.

If you have Linux/Unix, you must to find a soft link in your 
"/etc/rc[1-6].d" dir and must to remove them:

kjt:/# cat /etc/inittab | grep default
id:3:initdefault:
   ^^^
kjt:/# ls /etc/rc3.d/ | grep postgres
S20postgresql-my

kjt:/# rm -i /etc/rc3.d/S20postgresql-my

bye,
kjt


McAfee SCM 4.1 által ellenőrizve!

Re: Postgres at startup

From
"Andy Shellam (Mailing Lists)"
Date:
I'm guessing by the "postmaster.exe" that this is on Windows.

In that case, find "PostgreSQL X.Y" in Control Panel>Administrative
Tools>Services (where X.Y is your major.minor version number of Postgres.)
Change the services' start-up type to "Manual" (so you can start it
yourself when needed.)

Andy.

Kis János Tamás wrote:
> 2006. November 8. 02.34 dátummal Michael McCloskey ezt írta:
>
>> Postgres is starting automatically for me at startup.
>> When I boot up my machine and then check the running processes I
>> see postmaster.exe and 4 postgres processes.
>> How can I stop this?
>>
> PGBIN="/usr/local/pgsql/bin";
> PGDATA="/srv/postgresql";
> su postgres -c "$PGBIN/pg_ctl -D $PGDATA stop"
>
>
>> I don't want Postgres starting up automatically.
>>
>
> If you have Linux/Unix, you must to find a soft link in your
> "/etc/rc[1-6].d" dir and must to remove them:
>
> kjt:/# cat /etc/inittab | grep default
> id:3:initdefault:
>    ^^^
> kjt:/# ls /etc/rc3.d/ | grep postgres
> S20postgresql-my
>
> kjt:/# rm -i /etc/rc3.d/S20postgresql-my
>
> bye,
> kjt
>
>
> McAfee SCM 4.1 által ellenőrizve!
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>
> !DSPAM:37,455c14a340413711078630!
>
>
>


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

Re: Postgres at startup

From
Kis János Tamás
Date:
2006. November 16. 08.05 dátummal Kis János Tamás ezt írta:
> 2006. November 8. 02.34 dátummal Michael McCloskey ezt írta:
> > see postmaster.exe and 4 postgres processes.

Ooops!
I don't see the ".exe"...
I'm sorry! 

bye,
kjt


McAfee SCM 4.1 által ellenőrizve!