Skip site navigation (1) Skip section navigation (2)

7.4beta2 initdb Fix

From: Database Administrator <dba(at)vilaj(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: 7.4beta2 initdb Fix
Date: 2003-08-29 20:59:46
Message-ID: 3F4FBEC2.1080304@vilaj.com (view raw or flat)
Thread:
Lists: pgsql-patches
I found some trouble in installing PostgreSQL 7.4beta2 on Mac OS X
10.2.6. Specifically, on that operating system, the new script
calculates shared-buffers at 400 and max-connections at 20. The problem
is that once you get to the point in the script where template1 is being
created, the calls to "postgres -boot ..." appear to still assume a
"best case" scenario of 1000 and 100, respectively, a situation that
repeats itself throughout the rest of the script. This causes a failure
of initdb on platforms where 1000 and 100 exceed the OS' capability.

I therefore applied the following change, which allowed initdb to work
without problem. I am not sure that this is in the appropriate format. 
If not, my apologies.

[share]$ diff ~/src/postgresql-7.4beta2/src/bin/initdb /opt/pgsql/bin/initdb
610a611,612
> PGSQL_OPT="$PGSQL_OPT -c shared-buffers=$nbuffers -c 
max-connections=$nconns"
>

- Will

-- 
Database Administrator, vilaj.com, LLC
<http://www.vilaj.com/>





Responses

pgsql-patches by date

Next:From: Bruce MomjianDate: 2003-08-30 15:11:11
Subject: Re: Index creation takes for ever
Previous:From: Andriy TkachukDate: 2003-08-29 13:12:13
Subject: Re: about contrib/dbase/dbf.c (fwd): conversion of non-ascii dbf

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group