Re: [HACKERS] Hot Standby utility and administrator functions

Simon Riggs a écrit :
> On Fri, 2008-10-24 at 09:54 +0200, Guillaume Lelarge wrote:
>>[...]
>> Is there a way to get the IP of the salve (if we are connected to the
>> master? and vice-versa?
>
> No. They are separately configurable and don't pass that info.
>

I definitely need to read your mails on pgsql-hackers.

> [...]
>>>> * pg_start_backup()/pg_stop_backup() could work during recovery, but the
>>>> backup history file would need to be manually inserted into the archive
>>>> once complete. Is that acceptable? (Note that we don't know where the
>>>> archive is or how to access that; the information is all in
>>>> recovery_command. We cannot assume that archive_command points to same
>>>> archive. So making it happen automatically is too much work for this
>>>> release, if ever.) If that seems useful, we could do this by avoiding
>>>> any operation that changes WAL stream during recovery: no checkpoints,
>>>> log switches etc..
>>>> pg_start_backup() would return XLogRecPtr of last restartpoint.
>>>> pg_stop_backup() would return last known xlrec recovered (we won't keep
>>>> track of this record by record).
>>>>
>> No interest from pgAdmin's pov.
>
> I would ask: why not? Why is PITR not part of pgAdmin's capability?
>

Strictly speaking, pgAdmin is already able to configure PITR. Go on the
configure tool, put your archive command, reload (pre8.3) or restart
(8.3) the server. That's all it needs.

But LogShipping is a different matter. For LogShipping to be part of
pgAdmin's capabilities, we would need to be able to copy all PGDATA
files from the master server to a slave server within pgAdmin. I'm not
sure how we can handle this. Moreover, we would also need to launch the
slave server.

I mean, I would love to build a "PITR/LogShipping wizard": ask the slave
IP, configure postgresql.conf on the master, recovery.conf on the slave,
reload conf on the master, start the slave... but how do we copy files
from one server to the other? how do we start the slave server?

> [...]
>> Oh, I almost forgot. I see you mailed a few projects (pgAdmin, pgpool,
>> pgbouncer). Perhaps you should ask phpPgAdmin's guys too?
>
> Not on that list, if you are could you pass it on.
>

Done.

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com