Mostrando entradas con la etiqueta PgSQL. Mostrar todas las entradas
Mostrando entradas con la etiqueta PgSQL. Mostrar todas las entradas

lunes, 8 de octubre de 2007

PostgreSQL 8.2 LiveCD

Pg_live es una distribución en formato LiveCD basada en Xubuntu creada por el Grupo de Usuarios *BSD de Nueva York "diseñada y optimizada expresamente para el administrador y el entusiasta de la base de datos PostgreSQL". El CD de Pg_live arranca con un servidor web Apache con PHP, SSH y, por supuesto, PosgreSQL compilado con los siguientes lenguajes procedurales: plpgsql, plperl, pltcl, plpython, plruby, pljava y plr. Se incluyen también 3 clientes de PostgreSQL (psql, PgAdmin3 y phpPgAdmin) y replicación con Slony, además de miles de páginas de documentación y hasta el todavía vigente libro Practical PostgreSQL.

(más...)

viernes, 5 de octubre de 2007

PostgreSQL Replication with Slony-I

"In this post, we look at another replication mechanism available for PostgreSQL, Slony-I. Slony-I is an asynchronous, master-slave replication system. With PGCluster, we had the ability to load balance connections to the PostgreSQL database, knowing that data that is modified in one server will be replicated across to the other server. Additionally, its synchronous nature gave us confidence that, in the event of a failure, all completed transactions will be accounted for. With Slony-I, we run into a very different type of replication. Slony-I is a master-slave system, designed to utilize one master database, and one or more slaves. Data is replicated in a one-way fashion, from the master to the slave(s). It does not include a built-in load balancing feature like PGCluster, and there is no automatic failover from a failed master to one of the slaves. Failover must be manually configured using a third-party utility, such as heartbeat. Slony-I's asynchronous nature means that, in the event of a database failure, there may be uncommitted transactions that have not been replicated across. Slony-I performs batching of transaction replication in order to improve performance. However, if the master fails prior to a batch of transactions being replicated, those transactions are lost."

PostgreSQL Replication with PGCluster

"In an earlier post, I briefly mentioned the PGCluster project. PGCluster is an extension of the PostgreSQL database, designed to give it synchronous, multi-master replication. Replication is one of the areas in which PostgreSQL is lacking in comparison to other proprietary databases, such as Oracle or MS SQL Server. However, after playing around with PGCluster, I have become very impressed with its capabilities. If development continues, PGCluster could offer a sound solution to a very important problem that large enterprises will encounter if they wish to role out PostgreSQL in a high-availability situation."

(more...)

martes, 21 de agosto de 2007

PostgreSQL in the OpenSolaris OS

This article describes key features of PostgreSQL 8.2, which have been available in OpenSolaris since build 66.

jueves, 29 de marzo de 2007

PostgreSQL LiveCD

Pg_live is an Xubuntu based liveCD "designed and optimized expressly for the PostgreSQL Database administrator and enthusiast." It is also an ideal classroom aid and utility for those who want to learn more about the latest version of Postgres without having to install and configure it first.

(more...)

sábado, 24 de marzo de 2007

Instalación y Configuración de PostgreSQL 8.x

Hace algún tiempo cree éste tutorial para la comunidad española de ElDemonio en el que explico el procedimiento para instalar, configurar y securizar PostgreSQL Server. En ese momento tenía una máquina 5.5-STABLE, pero el proceso es el mismo que para una 6.x.

Existe un mirror en la comunidad BSD de Perú.