Re: [COMMITTERS] pgsql-server/src - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [COMMITTERS] pgsql-server/src
Date
Msg-id Pine.LNX.4.44.0208132024180.9559-100000@localhost.localdomain
Whole thread Raw
In response to Re: [COMMITTERS] pgsql-server/src  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [COMMITTERS] pgsql-server/src  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Tom Lane writes:

> That does not change my opinion about the -X/PGXLOG switch though ---
> having a backup safety check is not an excuse for having a fundamentally
> insecure set of startup options.

OK, so:

1. Leave -X option in initdb.  Remove all other -X options.

2. Remove all uses of PGXLOG.

3. Symlink from PGDATA to desired location.

4. Implement pg_mvxlog to move xlog if server is shut down.  (So no one
needs to know about 3.)

In the future:

Combine pg_mvxlog, pg_controldata, pg_resetxlog into pg_srvadm.

Sounds good.

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Is contrib/rserv/Makefile broken?
Next
From: Peter Eisentraut
Date:
Subject: Re: [GENERAL] Linux Largefile Support In Postgresql RPMS