17 PostgreSQL Database and MySQL Administration......................................

249

Installing PostgreSQL.............................................................................................................

249

Starting and Stopping PostgreSQL Server.................................................................................

249

Viewing the PostgreSQL Log File.............................................................................................

250

Administering PostgreSQL Accounts.........................................................................................

251

Important Files and Directories...........................................................................................

251

Running the Postmaster Startup Script..................................................................................

252

Using Existing PostgreSQL Accounts....................................................................................

252

Setting up a Crontab Entry for Vacuuming Databases................................................................

252

Scaling PostgreSQL...............................................................................................................

256

MySQLadministrationAdministering MySQL..............................................................................

258

Directories and Files Established by MySQL Installation.........................................................

258

Starting and Stopping MySQL...........................................................................................

258

Starting and Stopping the MySQL Server Using a Command Line..........................................

259

MySQL Configuration Files................................................................................................

259

MySQL Log Files..............................................................................................................

259

Viewing the MySQL Error Log............................................................................................

259

Viewing the MySQL General Log.......................................................................................

259

18 BIND Domain Name Server Administration..............................................

260

BIND Overview....................................................................................................................

260

Important BIND Files and Directories.......................................................................................

260

Enabling BIND.....................................................................................................................

262

Running the BIND Startup Script.............................................................................................

263

BIND Documentation............................................................................................................

263

19 Jabber.................................................................................................

265

Controlling the Jabber Server.................................................................................................

265

20 Twiki...................................................................................................

266

Starting TWiki......................................................................................................................

266

21 Stunnel................................................................................................

267

Sample client server configuration...........................................................................................

267

A Sendmail Supplemental Information..........................................................

268

Creating a Certificate of Authority..........................................................................................

268

Background - OpenSSL Certificate Creation..............................................................................

268

Mail Filter Example...............................................................................................................

269

Glossary..................................................................................................

272

Index.......................................................................................................

276

Contents 11