Thank you for getting back to me.
I want to know what it is in every data file and the format, so I develop pgcheck.
I also hope pgcheck can check data error in pgsql more easily, but there are a lot of work to do.
It can not be finished by myself, so I hope more people can develop it together.
I just know pg_filedump from you, it's quite cool and so many people develop it. ^~^
I'm very interesting to move some pgcheck's functionality to pg_filedump.
While I have time I will try. ^~^
I don't know how to "submit a link to Reddit and/or Hacker News". if some people
also like pgcheck after know pg_filedump, hope to help me let more people to know it.
there are also some problem like "Euler Taveira" say, I will try my best to solve it.
for some reason I have to use some core function in pgsql and some function is static.
Maybe I can not solve the problem very well, also hope some suggests or push some patch to pgcheck.
hope the way of check data error in pgsql more easily!
best wishes!
At 2018-03-14 16:33:49, "Aleksander Alekseev" <a.alekseev@postgrespro.ru> wrote:
>Hello leap,
>
>> hello!
>> I develop a tool for pgsql, I want to submit it on pgsql.
>> how can I submit it?
>> address: https://github.com/leapking/pgcheck
>
>It's always nice to see another great tool! Thanks a lot for sharing it.
>I believe you should write a blog post about it for PostgreSQL Planet or
>at least submit a link to Reddit and/or Hacker News. Also consider
>submitting a talk about it to PostgreSQL conferences.
>
>I couldn't not notice that actually it looks quite similar to
>pg_filedump [1] which is currently maintained by the community. Perhaps
>you would be interested in porting the part of pgcheck's functionality
>that is missing in pg_filedump to pg_filedump? Or maybe vice versa? :)
>
>Fun fact! pg_filedump is designed for reading, checking and recovering
>data from database files. Since these files are usually recovered from a
>backup or corrupted hard drive pg_filedump will be most likely executed
>on the system which doesn't has a PostgreSQL package installed. And it's
>distributed separately just for this reason I believe.
>
>[1]: https://git.postgresql.org/gitweb/?p=pg_filedump.git;a=summary
>
>--
>Best regards,
>Aleksander Alekseev
