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 …
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 7.2 upgrade and crypto I upgraded to
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 …
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 …
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 …
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 …
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 …
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 …