If an exclusive backup API is really removed from #PostgreSQL, new extension supporting an exclusive one may need to be implemented.
-
-
Replying to @fujii_masao
What feature would you actually look for in it? What does that api deliver that the new one doesn't?
1 reply 0 retweets 1 like -
Replying to @magnushagander @fujii_masao
Easy scriptability? Seems to be the only advantage.
1 reply 0 retweets 0 likes -
Replying to @AndresFreundTec @fujii_masao
It provides easy scriptable for unsafe scripts. It doesn't provide safe scriptability. We could probably improve a safe scripting interface, but it's not what we had before. Heck even an example of a safe script might help most people.
1 reply 0 retweets 0 likes -
Replying to @magnushagander @fujii_masao
Meh. It's considerably easer to script the new thing wrongly than the old thing. It's far from easy to script keeping a postgres connection open in the background, with proper error checking, than with the old interface. Both are obviously easy to get wrong.
2 replies 0 retweets 0 likes -
Replying to @AndresFreundTec @fujii_masao
I agree the new one does not provide easy scriptability. I just don't agree the old one does, or does better.
1 reply 0 retweets 0 likes -
Replying to @magnushagander @fujii_masao
I mean obviously the old interface has issues around the system / script dying in the wrong moment, but I don't understand how having to keep a connection open doesn't increase difficulty.
1 reply 0 retweets 0 likes -
Replying to @AndresFreundTec @fujii_masao
It does. Both are difficult to get right. One of them pretends to be easy and in exchange for it you get corrupt backups or a server that doesn't start. The other one is up front about the fact that it's difficult. (and we have an easy one, it's called pg_basebackup)
1 reply 0 retweets 1 like -
And no it's not particularly hard to script with the new interface. Unless it a absolutely has to be in shellscript.
1 reply 0 retweets 0 likes -
Replying to @magnushagander @fujii_masao
Yea, but the reality is that shell-scriptability is a desirable goal, much as we dislike it from a dogmatic position. I think it was a mistake to not make this easier when the new interface was added.
2 replies 0 retweets 0 likes
Say by having a small commandline tool that accepts the command for copying the data directory as an argument, and handles the server connection for you.
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.