You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@trafficcontrol.apache.org by "Rivas, Jesse" <Je...@comcast.com> on 2019/09/13 16:58:07 UTC
Re: [EXTERNAL] Re: Changing dbdump output format
pg_restore cannot handle plain-text formats -- psql has to be used in order
to restore from .sql format.
Jesse
On 9/13/19, 10:21 AM, "Jeremy Mitchell" <mi...@gmail.com> wrote:
If pg_restore can handle both (the current binary and your suggested plain
sql) seamlessly then doesn't seem like a problem to me to change the format
to plain SQL but i can't speak for everyone using this endpoint. is
everyone using the endpoint's response in tandem with pg_restore?
if it helps testability, i think your suggestion makes a lot of sense.
jeremy
On Thu, Sep 12, 2019 at 11:26 AM ocket 8888 <oc...@gmail.com> wrote:
> I'm rewriting the dbdump endpoint (PR #3912) and the output format used by
> Perl is a binary, compressed SQL script. It makes editing and even testing
> just a bit harder than it could be. The data is still compressed for
> transfers, but a plain SQL script is much easier for a human to analyze.
> pg_restore can work with any format that pg_dump outputs - and it
> automatically detects which one to use, so the user doesn't even need to
> know, really.
>
> But is this a problem for anyone, for any reason?
>