Year 2000 Compliant. A new data type may be registered in the database system for data that cannot easily be represented by the default data types. Create type is specific to PostgreSQL and may not be available on other database systems. A supervisory daemon allocates shared memory and verifies database intergity. Backend processes are spawned to handle each client application connection.
Client applications connect via sockets from either the local or a remote machine.
The libraries and binaries consume roughly 5Mb of disk space. 8Mb of free RAM is the minimum recommendation, with significant performance increases when more than 80Mb is available, especially on SMP systems. S means run silent, no messages to standard out. D the data directory where the database catalogs are stored. This command updates the system statistics used to optimize queries as well as reclaiming space freed by delete statements.