Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
Hi. I'm jon.404, a Unix/Linux/Database/Openstack/Kubernetes Administrator, AWS/GCP/Azure Engineer, 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: *nix.
PostgreSQL StuffAs far as databases go, and as far as I'm concerned, **this** is the good stuff.
Posted 04-05-2011 at 09:26 AM byrocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 04-05-2011 at 09:47 PM byrocket357
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)
Posted 03-24-2011 at 09:48 AM byrocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 03-29-2011 at 07:58 AM byrocket357
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>"...
Posted 03-04-2011 at 09:35 AM byrocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 03-30-2011 at 03:19 PM byrocket357
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
Posted 02-12-2010 at 11:01 AM byrocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 02-12-2010 at 11:55 AM byrocket357
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.
Posted 02-10-2010 at 09:54 AM byrocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 03-04-2011 at 09:42 AM byrocket357(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!).
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.