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, 17:03 Category: Software Views: 2291 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.
Ubuntu

Setting Up Proftpd With A Postgresql Backend For Auth And Logging

Post date: June 17, 2006, 06:06 Category: Software Views: 3699 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.
Debian

Complete Debian Linux Server Setup Guide

Post date: March 15, 2006, 00:03 Category: Installing Views: 5305 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
Ubuntu

Perfect Setup Of Snort + Base + PostgreSQL On Ubuntu 6.06 LTS

Post date: April 25, 2007, 21:04 Category: Installing Views: 4041 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.
Ubuntu

Database Server With postgresql and pgadmin3 in Ubuntu

Post date: April 20, 2008, 18:04 Category: Software Views: 3550 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.

Unix+clones

How To Set Up Database Replication In MySQL

Post date: December 14, 2005, 19:12 Category: Software Views: 3889 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.
Debian

Installing PowerDNS (With MySQL Backend) And Poweradmin On Debian Lenny

Post date: July 11, 2010, 22:07 Category: Installing Views: 3281 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.
Debian

Installing PowerDNS (With MySQL Backend) And Poweradmin On Debian Etch

Post date: January 20, 2009, 11:01 Category: Installing Views: 3450 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.
Debian

Creating Advanced MySQL-Based Virtual Hosts On Lighttpd (Debian Etch)

Post date: August 19, 2008, 10:08 Category: Software Views: 3186 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.
Debian

Installing MyDNS-NG & MyDNSConfig On Debian Squeeze

Post date: January 20, 2011, 12:01 Category: Installing Views: 2095 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.
Web-based applications and online marketing solutions - LumoLink