Re: [GENERAL] createdb argument question

2007-10-27 Thread Seneca Cunningham
On Sat, Oct 27, 2007 at 12:56:37PM -0500, Perry Smith wrote: On my Mac systems, this work. On my AIX system it does not. I get: createdb dog -E utf8 createdb: too many command-line arguments (first is utf8) Try createdb --help for more information. Has anyone else bumped in to this? Is

Re: [GENERAL] Q re installing Pg on OS X?

2007-04-15 Thread Seneca Cunningham
On Sun, Apr 15, 2007 at 06:18:18PM -0400, Kynn Jones wrote: OK, I found the answer to my question about the roles error. Still, it would be nice to have more up-to-date instructions on how to install PostgreSQL on OS X. Any pointers would be much appreciated! Try the main documentation at:

Re: [GENERAL] OS X Tiger, and PostgreSQL 8.2 don't mix?

2007-01-02 Thread Seneca Cunningham
On Tue, Jan 02, 2007 at 10:12:56AM -0700, Scott Ribe wrote: /etc/rc is what causes the values from /etc/sysctl.conf to be read in and used. Some values, such as the shm-related values are specified in the default /etc/rc after /etc/sysctl.conf is parsed up by /etc/rc and applied, but in

Re: [GENERAL] OS X Tiger, and PostgreSQL 8.2 don't mix?

2006-12-30 Thread Seneca Cunningham
On Thu, Dec 28, 2006 at 09:11:24AM -0700, Scott Ribe wrote: and added the appropriate items to /etc/sysctl.conf 1) The location may be out of date. Don't add to /etc/sysctl.conf; edit the values already in /etc/rc. Where you set these values has shifted around somewhat in OS X releases. I

Re: [GENERAL] strange sum behaviour

2006-08-29 Thread Seneca Cunningham
double sum looks to be a normal error for floats in that situation. Take a look at http://www2.hursley.ibm.com/decimal/decifaq.html for some information about why you should be using numeric for your amount column. -- Seneca Cunningham [EMAIL PROTECTED] ---(end

Re: [GENERAL] More AIX 5.3 fun - out of memory ?

2006-03-29 Thread Seneca Cunningham
Gavin Hamill wrote: Seneca Cunningham wrote: You're using a 32-bit build with the default memory model, it would seem. You're limited to less than 256MB for the heap in that model. Try stopping the postmaster and starting it back up with the environment variable LDR_CNTRL set to MAXDATA

Re: [GENERAL] More AIX 5.3 fun - out of memory ?

2006-03-28 Thread Seneca Cunningham
the gory details of what's happening. [1] http://publib.boulder.ibm.com/infocenter/pseries/topic/com.ibm.aix.doc/aixprggd/genprogc/lrg_prg_support.htm [2] http://www.redbooks.ibm.com/abstracts/sg245674.html?Open -- Seneca Cunningham [EMAIL PROTECTED] ---(end

Re: [GENERAL] pg 8.1.3 on AIX

2006-03-22 Thread Seneca Cunningham
unadorned numbers to label the options. They're options, not steps) -- Seneca Cunningham [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Encoding errors when upgrading from 7.4 to 8.1

2006-01-26 Thread Seneca Cunningham
this is failing in 8.1.2? 8.1 changed UTF-8 handling to be more strict about invalid sequences. You may want to read the 8.1.0 release notes. http://www.postgresql.org/docs/8.1/interactive/release-8-1.html -- Seneca Cunningham [EMAIL PROTECTED] ---(end of broadcast

Re: [GENERAL] out of memory during query execution

2005-12-21 Thread Seneca Cunningham
/redbooks/SG245674/ -- Seneca Cunningham [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] out of memory during query execution

2005-12-20 Thread Seneca Cunningham
available to the process. Setting OBJECT_MODE to 64 before the ./configure and gmake should result in a 64-bit build, but I don't have a copy of IBM's compiler to test with. I would be interested in seeing the errors output by the 64-bit gcc build if another build is attempted. -- Seneca Cunningham

Re: [GENERAL] out of memory during query execution

2005-12-19 Thread Seneca Cunningham
You'll also want to export OBJECT_MODE=64 before the ./configure line. -- Seneca Cunningham [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org