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 »
Phorum – installation, upgrade, and conversion from MySQL to PostgreSQL Phorum and PostgreSQL represent the most stable and robust tools in their respective classes. Phorum is a “web based message board written in PHP”. PostgreSQL is the most advanced open source database available. Both are tools which I have used for several years and which
Phorum – installation, upgrade, and conversion from MySQL to PostgreSQL Read More »
PostgreSQL – analyzing a query to improve speed PostgreSQL is the leading open source database. Many people consider PostgreSQL to be a competitor to mySQL. People who say that don’t know either product. PostgreSQL isn’t competing with mySQL; it’s competing with Oracle. Yes, it’s being quiet about it. But the users aren’t. They were Oracle
PostgreSQL – analyzing a query to improve speed 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 »
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 »