TODO list for PostgreSQL

========================

Last updated:Wed Oct 815:33:48 EDT 2003

Last updated:Wed Oct 817:43:55 EDT 2003

Current maintainer:Bruce Momjian (pgman@candle.pha.pa.us)

o Master/slave replication

o Multi-master replication

o Partition data across servers

o Sample implementation in contrib/rserv

o Queries across databases or servers (two-phase commit)

o Allow replication over unreliable or non-persistent links

o http://gborg.postgresql.org/project/pgreplication/projdisplay.php

* Point-in-time data recovery using backup and write-ahead log

* Create native Win32 port [win32]

* Create native Win32 port, http://momjian.postgresql.org/main/writings/pgsql/win32.html

Reporting

* Allow plug-in modules to emulate features from other databases

* SQL*Net listener that makes PostgreSQL appear as an Oracle database

to clients

* Two-phase commit to implement distributed transactions

* Add two-phase commit to all distributed transactions with

offline/readonly server status or administrator notification for failure

PERFORMANCE

* Acquire lock on a relation before building a relcache entry for it

* Research interaction of setitimer() and sleep() used by statement_timeout

* Add checks for fclose() failure

* Change CVS $Id: TODO,v 1.1143 2003/10/0819:33:53 momjian Exp $ to $PostgreSQL: pgsql/doc/TODO,v 1.1143 2003/10/0819:33:53 momjian Exp $

* Change CVS $Id: TODO,v 1.1144 2003/10/0821:44:06 momjian Exp $ to $PostgreSQL: pgsql/doc/TODO,v 1.1144 2003/10/0821:44:06 momjian Exp $

* Exit postmaster if postgresql.conf can not be opened

* Rename /scripts directory because they are all C programs now

* Allow the regression tests to start postmaster with -i so the tests