7.4beta2 initdb Fix

Started by Database Administratoralmost 23 years ago2 messagespatches
Jump to latest

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/&gt;

#2Bruce Momjian
bruce@momjian.us
In reply to: Database Administrator (#1)
Re: 7.4beta2 initdb Fix

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/&gt;

---------------------------(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