Upgrading PostgreSQL From time to time, I need to upgrade PostgreSQL. When you are upgrading between minor revisions, you must dump and restore your databases. This article shows how I do this with FreeBSD 8.x and PostgreSQL 8.3, but this should be applicable to most other operating systems and versions of PostgreSQL. NOTE: If, for […]
Upgrading PostgreSQL Read More »
PostgreSQL – removing foreign keys I’m a big fan of PostgreSQL. I really like that database. I’ve been working with client/server databases since 1989 using a wide variety of databases including Sybase, Oracle, DB2, mySQL, Access, SQL Server, and SQL Anywhere. Everything has advantages and disadvantages but right now, I prefer PostgreSQL. Every relationship has
PostgreSQL – removing foreign keys Read More »
PostgreSQL 7.2 upgrade and crypto I upgraded to
PostgreSQL 7.2 upgrade and crypto Read More »
Introduction to C++ API for mySQL Murat Balaban wrote this article. We will try to make a brief introduction to the `complex` C++ API for Mysql on FreeBSD. We are going to explain the installation procedure and introduce the API in light of three samples…Recent version of this document can be found on ; http://www.enderunix.org/documents/eng/mysql++.html
Introduction to C++ API for mySQL Read More »
Samba authentication through PAM with MySQL Ed. note: Randall actually wrote this article back in November, but I’ve only just put it on the site today. Note: this assumes you have Samba, mySQL and pam_mysql already installed and running on FreeBSD 4.0 or greater The following describes how to setup Samba, PAM, and mySQL such
Samba authentication through PAM with MySQL Read More »
PostgreSQL and Perl Right after I started coding the new FreshPorts, I started to write some Perl scripts to load data into tables. The first problem was getting the Perl-PostgreSQL interface installed. I’d forgotten how I’d done this with mySQL. This is also known as the PostgreSQL DBI or DBD::Pg. The easy install The easiest
PostgreSQL and Perl Read More »
Adding procedural language support to PostgreSQL This document was originally written for PostgreSQL 7.0.3 but was updated on 13 October 2001 for version 7.1.3. I’m in the process of creating a new version of FreshPorts. This version will track all of the FreeBSD source tree, not just the ports collection. Initial testing of database design
Adding procedural language support to PostgreSQL Read More »
PostgreSQL – installation and configuration Here’s another plug for FreshPorts. I’ve been playing with ideas and I’ve come up a few good improvements. But they will require a database with more features than mySQL. Specifically, I’m going to need stored procedures and functions. I actually installed PostgreSQL back in late July, but never did anything
PostgreSQL – installation and configuration Read More »
Keeping mysql passwords secure Regular readers will remember my article about installing and configuring mysql. In that article you’ll see how I did a database backup. I’ve found a way to improve that script. ~/.my.cnf The script I use for backing up my database is available from: samples/database_dump2.sh.txt In that script, I include the password
Keeping mysql passwords secure Read More »
Accessing a mysql database from perl In previous articles I wrote about how to install and configure mysql (a very popular database). In this article, I write about how to access a mysql database from within a perl program. This will not be a full tutorial on the perl/mysql interface. Rather, it just shows you
Accessing a mysql database from perl Read More »