BUG #4122: ./postres 'restart' does not start server with same options as 'start' does

Lists: pgsql-bugs
From: "Eugen Konkov" <Eugen(dot)Konkov(at)aldec(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4122: ./postres 'restart' does not start server with same options as 'start' does
Date: 2008-04-22 08:49:17
Message-ID: 200804220849.m3M8nHp9092598@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4122
Logged by: Eugen Konkov
Email address: Eugen(dot)Konkov(at)aldec(dot)com
PostgreSQL version: 8.3.1
Operating system: FreeBSD 6.3
Description: ./postres 'restart' does not start server with same
options as 'start' does
Details:

sturtup script bug:
http://pgsql.privatepaste.com/2d1s3IvbIp


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Eugen Konkov" <Eugen(dot)Konkov(at)aldec(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4122: ./postres 'restart' does not start server with same options as 'start' does
Date: 2008-04-22 15:11:13
Message-ID: 21623.1208877073@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

"Eugen Konkov" <Eugen(dot)Konkov(at)aldec(dot)com> writes:
> PostgreSQL version: 8.3.1
> Operating system: FreeBSD 6.3
> Description: ./postres 'restart' does not start server with same
> options as 'start' does

You'd need to take that up with whoever supplied your startup script.
The one we provide (in contrib/start-scripts/freebsd) clearly does
use the same options for start and restart.

regards, tom lane


From: <Eugen(dot)Konkov(at)aldec(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #4122: ./postres 'restart' does not start server with same options as 'start' does
Date: 2008-04-22 16:59:16
Message-ID: 006201c8a49a$3c316c90$1200a8c0@kharkov.localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

I have just installed Postgres 8.3.1.
And /usr/local/etc/rc.d/postgresql and <tar>/contrib/start-scripts/freebsd
scripts are different
BUG in installator?

----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Eugen Konkov" <Eugen(dot)Konkov(at)aldec(dot)com>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Sent: Tuesday, April 22, 2008 6:11 PM
Subject: Re: [BUGS] BUG #4122: ./postres 'restart' does not start server
with same options as 'start' does

> "Eugen Konkov" <Eugen(dot)Konkov(at)aldec(dot)com> writes:
>> PostgreSQL version: 8.3.1
>> Operating system: FreeBSD 6.3
>> Description: ./postres 'restart' does not start server with same
>> options as 'start' does
>
> You'd need to take that up with whoever supplied your startup script.
> The one we provide (in contrib/start-scripts/freebsd) clearly does
> use the same options for start and restart.
>
> regards, tom lane


From: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
To: Eugen(dot)Konkov(at)aldec(dot)com
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4122: ./postres 'restart' does not start server with same options as 'start' does
Date: 2008-04-22 17:21:41
Message-ID: 480E1EA5.3090705@kaltenbrunner.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

Eugen(dot)Konkov(at)aldec(dot)com wrote:
> I have just installed Postgres 8.3.1.
> And /usr/local/etc/rc.d/postgresql and
> <tar>/contrib/start-scripts/freebsd scripts are different
> BUG in installator?

the one in /usr/local/etc/rc.d/postgresql is likely the on that freebsd
supplies if you install from the porttree so you should ask them ...

Stefan


From: Gary Doades <gpd(at)gpdnet(dot)co(dot)uk>
To: pgsql-bugs(at)postgresql(dot)org
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: BUG #4122: ./postres 'restart' does not start server with same options as 'start' does
Date: 2008-04-22 19:04:02
Message-ID: 480E36A2.1020404@gpdnet.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

Stefan Kaltenbrunner wrote:
> Eugen(dot)Konkov(at)aldec(dot)com wrote:
>> I have just installed Postgres 8.3.1.
>> And /usr/local/etc/rc.d/postgresql and
>> <tar>/contrib/start-scripts/freebsd scripts are different
>> BUG in installator?
>
> the one in /usr/local/etc/rc.d/postgresql is likely the on that freebsd
> supplies if you install from the porttree so you should ask them ...
>
>
> Stefan
>

Actually this looks like an issue with pg_ctl on freebsd.

If I invoke pg_ctl manually to do a start:

pg_ctl -D /usr/local/pgsql/data start

and then

ps aux

the root postgres process shows as:

/usr/local/bin/postgres -D /usr/local/pgsql/data

However, if I manually do a restart:

pg_ctl -D /usr/local/pgsql/data restart

the root postgres process shows as:

/usr/local/bin/postgres

i.e without the parameters.

The init script is not the problem as it invokes the same pg_ctl command
line in each case of start, stop, restart (apart from the start, stop,
restart bit of course).

Cheers,
Gary.