severity 492843 minor.
thanks

Hi Dimitri,

Dimitri [2008-07-29 11:52 +0200]:
> The pg_ctlcluster does not allow to use all pg_ctl options, the -m
> option in particular is much needed. User reports failure to stop or
> restart their PostgreSQL server with /etc/init.d scripts, and
> resorting to pg_ctlcluster is not helping at all.

You can use --force with stop or restart to use -m fast -> -m
immediate -> kill, so that most important bit is provided already.

> Even worse, debian packaging makes /usr/lib/postgresql/8.X/bin/pg_ctl
> tool non-usable, as it's unaware of where to find the .pid and the
> .conf files given the PGDATA var (/var/lib/postgres/8.X/main/data).

That's indeed a known problem of pg_ctl not reading postgresql.conf
properly. It should ideally work with

  /usr/lib/postgresql/8.3/bin/pg_ctl -D /etc/postgresql/8.3/main stop

but pg_ctl doesn't read the data_directory directive.

That's one case where it is inconvenient to mix the upstream tools
(pg_ctl and initdb) and Debian tools (pg_createcluster,
pg_ctlcluster). As long as you stick in just one set, it works
reasonably well IMHO. Thus I downgrade this to 'minor'.

> Please export all pg_ctl options to pg_ctlcluster wrapper script in a
> way allowing the user to effectively control its debian PostgreSQL
> clusters.

Yes, I'll provide an option to feed additional options to pg_ctl.
However, that's a new feature which isn't appropriate any more for
Lenny (which is frozen for release preparations already), thus I
postpone this until after Lenny.

Thanks,

Martin

-- 
Martin Pitt                        | http://www.piware.de
Ubuntu Developer (www.ubuntu.com)  | Debian Developer  (www.debian.org)

Attachment: signature.asc
Description: Digital signature

Reply via email to