Is that possible to create a fake postgresql server using postgres-protocol ?

[prx0]

Hi,
I would like to create a fake postgresql server which will be able to respond to any postgresql client. (even psql) Such project already exists https://pkg.go.dev/github.com/jackc/pgproto3/[email protected]#section-readme

I would like to know if the current state of posgres-protocol give me everything I need for making a fake postgresql server. I'm not sure that the crate was designed for this. The backend-module give me nothing to handle startup message (but I've a function for sending startup message, that's not really what I'm looking for) to I think I've to read the buffer myself in order to analyse what I have from my client.

Thank you very much!

[sfackler]

postgres-protocol currently only handles serialization of frontend messages and deserialization of backend messages, while a server implementation would need the opposite. I'd be happy to take a PR adding that support in though.

[prx0]

I'd be happy to take a PR adding that support in though.

It could be great! I will check how pg Message flow works and I'll try to do something in order to add serialization of backend message and deserialization of frontend message.

[prx0]

I've worked on this #946
Still in work in progress currently.

[sunng87]

hi @prx0 I have a library pgwire allows you to do that. The library uses postgres-types from rust-postgres