Go back to fronty page View most popular entries View latest additions Submit tutorials to UnixTutorials.info
UnixTutorials logo

Search results for PostgreSQL Database Server Configuration in Debian

Debian PostgreSQL Database Server Configuration in Debian
Post date: March 24, 2006, 12:03 Category: Software Views: 16
Tutorial quote: PostgreSQL is a fully featured object-relational database management system. It supports a large part of the SQL standard and is designed to be extensible by users in many aspects. Some of the features are: ACID transactions, foreign keys, views, sequences, subqueries, triggers, user-defined types and functions, outer joins, multiversion concurrency control. Graphical user interfaces and bindings for many programming languages are available as well.
Debian Complete Debian Linux Server Setup Guide
Post date: March 14, 2006, 19:03 Category: Installing Views: 39
Tutorial quote: This tutorial includes debian Installation,FTP Server Setup,Webserver Setup,Samba Server Setup,Database Server Setup,time clock sync server,
Mail Server Configuration,VNC Server setup,Proxy Server Setup,SSH Server Setup,tftp Server Setup,DHCP Server Setup,
IPtables Configuration,DNS Server Setup,Firewalls configuration,Backup configuration
Unix+clones How To Set Up Database Replication In MySQL
Post date: December 14, 2005, 14:12 Category: Software Views: 81
Tutorial quote: This tutorial describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync. This is not a backup policy because an accidentally issued DELETE command will also be carried out on the slave; but replication can help protect against hardware failures though.

In this tutorial I will show how to replicate the database exampledb from the master with the IP address to a slave. Both systems (master and slave) are running Debian Sarge; however, the configuration should apply to almost all distributions with little or no modification.
Debian Install Oracle Database XE on Debian Sarge
Post date: May 2, 2006, 11:05 Category: Installing Views: 19
Tutorial quote: Oracle Database 10g Express Edition (Oracle Database XE) is an entry-level, small-footprint database based on the Oracle Database 10g Release 2 code base that’s free to develop, deploy, and distribute; fast to download; and simple to administer. Oracle Database XE is a great starter database for

Developers working on PHP, Java, .NET, and Open Source applications

DBAs who need a free, starter database for training and deployment

Independent Software Vendors (ISVs) and hardware vendors who want a starter database to distribute free of charge

Educational institutions and students who need a free database for their curriculum

Unix+clones Running A MySQL-Based DNS Server: MyDNS
Post date: January 23, 2006, 10:01 Category: Network Views: 32
Tutorial quote: In this tutorial I will describe how to install and configure MyDNS, a DNS server that uses a MySQL database as backend instead of configuration files like, for example, Bind or djbdns. This has the advantage that you can easily use web-based frontends to administrate your DNS records. You could even write your own frontend, e.g. using PHP, to interact with the MyDNS database. MyDNS simply reads the records from the database, and it does not have to be restarted/reloaded when DNS records change or zones are created/edited/deleted! This is a major advantage.
Debian Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAssassin, ClamAV)
Post date: October 9, 2005, 14:10 Category: Network Views: 213
Tutorial quote: This document describes how to install a mail server based on Postfix that is based on virtual users and domains, i.e. users and domains that are in a MySQL database. I'll also demonstrate the installation and configuration of Courier (Courier-POP3, Courier-IMAP), so that Courier can authenticate against the same MySQL database Postfix uses.

The resulting Postfix server is capable of SMTP-AUTH and TLS and quota (quota is not built into Postfix by default, I'll show how to patch your Postfix appropriately). Passwords are stored in encrypted form in the database (most documents I found were dealing with plain text passwords which is a security risk). In addition to that, this tutorial covers the installation of Amavisd, SpamAssassin and ClamAV so that emails will be scanned for spam and viruses.
Debian Firebird database Configuration
Post date: May 5, 2006, 13:05 Category: Installing Views: 4
Tutorial quote: Firebird is a relational database offering many ANSI SQL-99 features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers. It has been used in production systems, under a variety of names since 1981.

Firebird is a commercially independent project of C and C++ programmers, technical advisors and supporters developing and enhancing a multi-platform relational database management system based on the source code released by Inprise Corp (now known as Borland Software Corp) under the InterBase Public License v.1.0 on 25 July, 2000.
Debian Linux virtual server on Debian Sarge
Post date: November 29, 2005, 16:11 Category: System Views: 163
Tutorial quote: Linux-VServer allows you to create virtual private servers and security contexts which operate like a normal Linux server, but allow many independent servers to be run simultaneously in one box at full speed. All services, such as ssh, mail, Web, and databases, can be started on such a VPS, without modification, just like on any real server. Each virtual server has its own user account database and root password and doesn't interfere with other virtual servers.
Debian Ruby on Rails on Debian
Post date: January 10, 2006, 12:01 Category: Network Views: 65
Tutorial quote: Most of you have probably heard of Ruby on Rails and may be wondering what exactly it does and how you can try it for yourself. Put simply, Rails is a web application framework that uses the model-view-controller software design pattern to allow for rapid development of web applications. This article will cover how to install Rails on Debian and how to configure it to work with Apache and a relational database of your choice.
Debian Installing Debian onto USB flash media with everything encrypted
Post date: September 28, 2005, 12:09 Category: Security Views: 228
Tutorial quote: This is a simple procedure for installing Debian GNU/Linux onto a USB key flash media. It includes several configuration changes but tries to stay as close to a default debian install as possible.

This is useful for administrators that need to carry sensitive information or people concerned about their privacy.