Search results for PostgreSQL Database Server Configuration in Debian
 |
|
Post date: March 24, 2006, 17:03
Category: Software
Views: 2974
Comments
|
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. |
 |
|
Post date: June 17, 2006, 06:06
Category: Software
Views: 4443
Comments
|
Tutorial quote: This tutorial is very niche, I'm going to cover only proftpd, and only in so much as to get it operational with Postgres. A basic understanding of proftpd, and Postgres is assumed. This tutorial will get you up and running proftpd pretty fast, and having it utilize a database, if that database has triggers, the possibilities of this configuration are almost endless. |
 |
|
Post date: March 15, 2006, 00:03
Category: Installing
Views: 5973
Comments
|
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 |
 |
|
Post date: April 25, 2007, 21:04
Category: Installing
Views: 4855
Comments
|
Tutorial quote: This tutorial describes how you can install and configure the Snort IDS (intrusion detection system) and BASE (Basic Analysis and Security Engine) on an Ubuntu 6.06 (Dapper Drake) system. With the help of Snort and BASE, you can monitor your system - with BASE you can perform analysis of intrusions that Snort has detected on your network. Snort will use a PostgreSQL database to store/log the data it gathers. |
 |
|
Post date: April 20, 2008, 18:04
Category: Software
Views: 4382
Comments
|
Tutorial quote: PostgreSQL is a powerful, open source relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD,HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes
most SQL92 and SQL99 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and
TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others.
|
 |
|
Post date: December 14, 2005, 19:12
Category: Software
Views: 4804
Comments
|
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 192.168.0.100 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. |
 |
|
Post date: July 11, 2010, 22:07
Category: Installing
Views: 4083
Comments
|
Tutorial quote: This article shows how you can install the PowerDNS nameserver (with MySQL backend) and the Poweradmin control panel for PowerDNS on a Debian Lenny system. PowerDNS is a high-performance, authoritative-only nameserver - in the setup described here it will read the DNS records from a MySQL database (similar to MyDNS), although other backends such as PostgreSQL are supported as well. Poweradmin is a web-based control panel for PowerDNS. |
 |
|
Post date: January 20, 2009, 11:01
Category: Installing
Views: 4282
Comments
|
Tutorial quote: This article shows how you can install the PowerDNS nameserver (with MySQL backend) and the Poweradmin control panel for PowerDNS on a Debian Etch system. PowerDNS is a high-performance, authoritative-only nameserver - in the setup described here it will read the DNS records from a MySQL database (similar to MyDNS), although other backends such as PostgreSQL are supported as well. Poweradmin is a web-based control panel for PowerDNS. |
 |
|
Post date: August 19, 2008, 10:08
Category: Software
Views: 4008
Comments
|
Tutorial quote: This guide explains how you can create advanced virtual hosts on a lighttpd web server on Debian Etch that are stored in a MySQL database. The method described here does not use the lighttpd mod_mysql_vhost module, and unlike mod_mysql_vhost (which allows you to store only the hostname and document root of a vhost in a database), this method allows to store individual configuration directives for each vhost in the MySQL database. |
 |
|
Post date: January 20, 2011, 12:01
Category: Installing
Views: 2905
Comments
|
Tutorial quote: This tutorial will describe how to install and configure MyDNS-NG and MyDNSConfig 3 on Debian Squeeze. MyDNS-NG is a DNS server that uses a MySQL database as backend instead of configuration files. The advantage is that 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. A secondary nameserver can be easily set up by installing a second instance of MyDNS that accesses the same database or, to be more redundant, uses the MySQL master / slave replication features to replicate the data to the secondary nameserver. |
|
|