On Mon, Jan 17, 2011 at 14:49, Simon Riggs <simon@2ndquadrant.com> wrote:
> On Mon, 2011-01-17 at 13:43 +0100, Magnus Hagander wrote:
>> Downthread you say that this tool is also useful for making base
>> backups
>> > independent of replication functionality. Sounds good. But then
>> the
>> > documentation says that the connection must be with a user that has
>> the
>> > replication permission. Something is conceptually wrong here: why
>> would
>> > I have to grant replication permission just to take a base backup
>> for
>> > the purpose of making a backup?
>>
>> It uses the replication features for it. You also have to set
>> max_walsenders > 0, which is in the replication section of the
>> postgresql.conf file.
>>
>> The point I wanted to make downthread was that it's useful without
>> having a replication *slave*. But yes, you need the master.
>
> Suggest calling this utility pg_replication_backup
> and the other utility pg_replication_stream
>
> It will be easier to explain the connection with replication.
Hmm. I don't like those names at all :(
But that's just me - and I don't totally hate them. So I'm opening the
floor for other peoples votes :-)
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/