SQLProxy server is designed to proxy tcp-requests for PostgreSQL database server.
PostgreSQL uses a message-based protocol for communication between frontends and backends (clients and servers). The protocol is supported over TCP/IP and also over Unix-domain sockets. Port number 5432 has been registered with IANA as the customary TCP port number for servers supporting this protocol, but in practice any non-privileged port number can be used.
Create test role and database
$ psql -U postgres -h localhost
postgres=# CREATE USER test with PASSWORD 'test';
postgres=# CREATE DATABASE testdb WITH ENCODING='UTF8' OWNER=test;
Commands to build sqlproxy
with scons
$ scons -Q
with cmake:
$ mkdir .build && cd .build
$ cmake ..
$ make