Re: Enhancement request for pg_dump

From: Pierre Chevalier Géologue <pierrechevaliergeol(at)free(dot)fr>
To: Sergei Agalakov <Sergei(dot)Agalakov(at)getmyle(dot)com>, pgsql-general(at)postgresql(dot)org, melvin6925(at)gmail(dot)com, wmoran(at)potentialtech(dot)com
Subject: Re: Enhancement request for pg_dump
Date: 2016-04-22 16:45:45
Message-ID: 571A5539.1010104@free.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Le 18/04/2016 03:10, Sergei Agalakov a écrit :
> I just wanted to check that my request will have the peoples support.
> So far it doesn't.

Well, you can count on my support, for sure!

> It looks like that or people never need to compare two PG databases
> to find the differences in the schemas or security, or happy to use
> the third party tools to do it, and don't want any native support.

I definitely share your opinion. But I understand that pg_dump wasn't
originally designed for this purpose, although such a feature would seem
so natural, at first glance.
So, another idea would be to implement another utility, something very
similar to pg_dump (probably sharing most of its code with it, or
calling pg_dump like my scripts did), but giving an ordered output.
Implementing such a tool outside of postgres would bring a bit more chaos.
So, the tool should be preferably bundled with postgres, to avoid the
need to get a third-party tool.
Hm. When I think about it twice, it sounds like overkilling.

Opinions?

> If I see any support from other people for this idea then I shall
> go to https://postgresql.uservoice.com/forums/21853-general,

I'd say +1, but the idea should be a bit more matured first, maybe?

À+
Pierre
--
____________________________________________________________________________
Pierre Chevalier
PChGEI: Pierre Chevalier Géologue Et Informaticien
Partenaire DALIBO
Mesté Duran
32100 Condom
Tél+fax : 09 75 27 45 62
06 37 80 33 64
Émail : pierrechevaliergeolCHEZfree.fr
icq# : 10432285
jabber: pierre(dot)chevalier1967(at)jabber(dot)fr
http://pierremariechevalier.free.fr/pierre_chevalier_geologue
____________________________________________________________________________

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Shulgin, Oleksandr 2016-04-22 16:49:41 Re: Add relcreated (timestamp) column to pg_class catalog to record the time an object was created
Previous Message Pierre Chevalier Géologue 2016-04-22 16:44:01 Re: Enhancement request for pg_dump