Thread: 7.4beta2 initdb Fix

7.4beta2 initdb Fix

From
Database Administrator
Date:
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/>





Re: 7.4beta2 initdb Fix

From
Bruce Momjian
Date:
A fix for this will be in beta3.

---------------------------------------------------------------------------

Database Administrator wrote:
> 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/>
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073