Tutorial eBooks PDF File Download

The PostgreSQL server will be installed with the following options: '--prefix=/usr/local/postgresql-7.4.7' '--exec-prefix=/usr/local/postgresql-7.4.7' '--with-tcl' '--with-tclconfig=/usr/local/tcltk8.4.7/lib' '--with-tkconfig=/usr/local/tcltk8.4.7/lib' '--with-java' '--disable-shared' '--enable-thread-safety' 'CFLAGS=-D_FILE_OFFSET_BITS=64-D_LARGEFILE_SOURCE' Above is output from the "pg_config --configure" command. Other configuration features: - vacuum - all standard databases will have their vacuum runs submitted via the fxa cron - all vacuum runs will have "verbose" option on - all output from vacuum runs will be saved in $LOG_DIR directory - partitions - all standard databases will be placed in separate partitions - see Appendix A for partition sizes - users - normal configuration will have only the users postgres and pguser defined - user oper will not be defined as a user known to postgresql - database ownership - all standard databases will be owned by user postgres and all tables will be owned by user pguser - adding plugins from /contrib directory will not allowed - function languages available: plpgsql, C, sql,Tcl