If all you want is a client you should just be able to write it and it will connect to the server and work. The client does not need to write just the server.
I was using Postgres for quite some time now without any problems. Now I'm facing some new challenge: Create a Read-Only Client out of a given Application and put it on CD/DVD. As the Application uses a PostgreSQL-DB (running on a FreeBSD-Server) I would like to at least keep the DB-Interface and use Postgres. The client-app, unfortunatly, is written for the .NET-Platform and doesn't run under mono (yet). So the CD would need to be run under Windows for the moment. I found some Threads discussion using a Knoppix-like approach to get Postgres running on a read-only medium but they were all concentrationg on linux. As far as I understand there is no way of turning WAL completely off (which would be ok for a CD-version as false writes cannot occur und thus cannot destroy the db-content). So then there are two possibilities: Send all writes to log-files to nirvana (like the good old BOFH used to do) or into a memdrive. Has anybody accomplished the task to run PostgreSQL from CD (even on Linux) and is willing to contribute some of his/her experiences? Any help is greatly appreciated.
...Dennis
---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings