News for hackers. Stuff that matters.
Re:Why Pg_dump Is Amazing by hobs on Saturday November 09, 2024 @11:50AM (#42095393)
Classic problems in a state based vs migration based management of your database code. What's wrong with information schema and an order by? If you are using migrations then the creation dates should be generally in the right order as well.
Re:Why Pg_dump Is Amazing by peterldowns on Saturday November 09, 2024 @12:28PM (#42095583)
I’m not sure I understand — can you elaborate on “what’s wrong with an information schema and an order by”? I don’t see how that’s connected to the problems I described with pg_dump or the solution offered by pgmigrate, but I’d be curious to learn another way of solving be problem.
Re:Why Pg_dump Is Amazing by hobs on Saturday November 09, 2024 @01:38PM (#42096057)
Just the problem with ordering of state in a database not matching the other database after you ran migrations. Information schema being the authoritative schema for all the information about the meta state in most database systems (or at least the cross platform one) means you can write a query against these views and (if I am not mistaken) re-assemble state that's identical by ordering the application of the objects in the order they were created originally.
Re:Why Pg_dump Is Amazing by fooododododo on Saturday November 09, 2024 @05:09PM (#42097214)
Is everything in pgdump in the information schema?