Skip site navigation (1) Skip section navigation (2)

Re: postgresql.conf archive_command example

From: Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
To: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: "Dimitri Fontaine" <dimitri(at)2ndQuadrant(dot)fr>, "Josh Berkus" <josh(at)agliodbs(dot)com>, "Robert Haas" <robertmhaas(at)gmail(dot)com>, <pgsql-hackers(at)postgresql(dot)org>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: postgresql.conf archive_command example
Date: 2011-09-02 20:20:24
Message-ID: m21uvy4rxz.fsf@2ndQuadrant.fr (view raw or flat)
Thread:
Lists: pgsql-hackers
"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> writes:
> (1)  We're talking about a new /bin executable to do this which
> could be referenced in an archive_command string or run from a
> script called by archive_command, right?

That, or an internal implementation.  That would be a function in the
backend that would be called when archive_command is set to some
specific value, like for example test and cd are command lines referring
not to some executable on the PATH but to some internal code in bash.

But I know some people here will frown upon that idea.

> (2)  It should copy, not move, with protection against overwriting
> an existing file.

See, we need to provide a good production grade facility.  I've never
tried to do it myself, I'm just using walmgr to manage my archives.

> (3)  Maybe not in the initial version, but eventually it might be
> nice to support URLs of some known protocols in addition to local
> directories.

I guess that if patches are provided in that direction it would be kind
of hard to refuse integrating them :)

> (4)  Maybe not in the initial version, but eventually it might be
> nice to support checking for an "owner" file of some sort in the
> target directory, to help sort out problems with copied databases
> writing to the same location as the source.

Then we need to provide the associated restore command which must not be
one "owner" here I guess…

Regards,
-- 
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support

In response to

Responses

pgsql-hackers by date

Next:From: Kevin GrittnerDate: 2011-09-02 20:42:45
Subject: Re: postgresql.conf archive_command example
Previous:From: Bruce MomjianDate: 2011-09-02 20:11:27
Subject: Re: pg_upgrade automatic testing

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group