LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Blogs > Musings on technology, philosophy, and life in the corporate world
User Name
Password

Notices

Hi. I'm a Unix Administrator, mathematics enthusiast, and amateur philosopher. This is where I rant about that which upsets me, laugh about that which amuses me, and jabber about that which holds my interest most: Unix.
PostgreSQL Stuff As far as databases go, and as far as I'm concerned, **this** is the good stuff.
Old

OpenBSD/amd64: BIGMEM is default

Posted 04-05-2011 at 09:26 AM by rocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 04-05-2011 at 09:47 PM by rocket357

Thanks to the work of Bob Beck and countless other OpenBSD developers, amd64 BIGMEM is now turned on by default in the April 4th snapshot of OpenBSD-CURRENT.

Code:
OpenBSD 4.9-current (GENERIC.MP) #865: Mon Apr  4 13:03:14 MDT 2011
    deraadt@amd64.openbsd.org:/usr/src/sys/arch/amd64/compile/GENERIC.MP
real mem = 137428045824 (131061MB)
avail mem = 133755703296 (127559MB)
mainbus0 at root
bios0 at mainbus0: SMBIOS rev. 2.6 @ 0xdf79c000 (103 entries)
...
Member
Views 3639 Comments 4 rocket357 is offline
Old

PostgreSQL 8.x backup caveat

Posted 03-24-2011 at 09:48 AM by rocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 03-29-2011 at 07:58 AM by rocket357

During the deployment of our latest software revision (a major version bump that migrated all of our databases from MSSQL to Linux/PostgreSQL and migrated all of our web servers from Apache/PHP to Tomcat/GWT), we started hitting snags in IT operations immediately with database backups. When this major version revision came out, it allowed customers to store documents, photos, etc...directly in the database (something MSSQL 2005 isn't capable of). Doing a simple "pg_dump <opts> <dbname>"...
Member
Views 609 Comments 0 rocket357 is offline
Old

Updated PostgreSQL auto-configure script

Posted 03-04-2011 at 09:35 AM by rocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 03-30-2011 at 03:19 PM by rocket357

I've altered the postgresql auto-configure script quite a bit since I last posted it. Here's the updated version:

Code:
#!/bin/sh

# configPG.sh:
#
# This script automatically detects system RAM and other resources
# and modifies $PG_DATA_DIR/postgresql.conf to configure the server
# for one of three uses:  web, oltp, or data warehousing.
# 
# Author: rocket357@users.sourceforge.net
# License: BSD
#
# This script
...
Member
Views 1595 Comments 0 rocket357 is offline
Old

This database has been brought to you by the number -17

Posted 02-12-2010 at 11:01 AM by rocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 02-12-2010 at 11:55 AM by rocket357

In this blogpost, I shared two scripts: one was to dynamically configure PostgreSQL to the specs of the machine it's running on (based on three different "usage patterns": web-based backend, online transaction processing, and data warehousing/business intelligence), and the other script was a very basic startup/init script for PostgreSQL. In the init script I put a few new lines (new to me, at least), so I figured I'd explain those.

First off, the lines in question:...
Member
Views 1681 Comments 5 rocket357 is offline
Old

PostgreSQL reconfigure script

Posted 02-10-2010 at 09:54 AM by rocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 03-04-2011 at 09:42 AM by rocket357 (Added Version changelog to script)

UPDATE: Script has been revised and is available here

The following script is something I've written up to ease my duties as the PostgreSQL DBA for a large hosting company. It configures PostgreSQL according to whack-a-mole, and it auto-detects various resources such as system RAM, shared memory settings, etc...

The script currently supports Linux and OpenBSD (FreeBSD coming soon!).

Code:
#!/bin/sh

# configPG.sh:
#
# This script
...
Member
Views 1673 Comments 2 rocket357 is offline

  



All times are GMT -5. The time now is 04:13 PM.

Main Menu

My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration