| From: | vespadict <vespadict(at)gmail(dot)com> | 
|---|---|
| To: | pgsql-es-ayuda(at)postgresql(dot)org | 
| Subject: | Instalacion en Solaris 8 | 
| Date: | 2005-09-16 09:18:52 | 
| Message-ID: | 432A8DFC.9080903@gmail.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-es-ayuda | 
Hola a todos :
Estoy tratando de instalar postgres en Solaris 8. He probado con las 
versiones 7.3.10 y 8.0.3 de postgres pero en ambas ocasiones me ocurre 
lo mismo. El proceso de compilacion es correcto pero a la hora de 
inicializar la base de datos aparece el siguiente error :
$ ./bin/initdb -D /usr/local/pgsql/data
The files belonging to this database system will be owned by user 
"postgres".
This user must also own the server process.
The database cluster will be initialized with locale C.
creating directory /usr/local/pgsql/data ... ok
creating directory /usr/local/pgsql/data/global ... ok
creating directory /usr/local/pgsql/data/pg_xlog ... ok
creating directory /usr/local/pgsql/data/pg_xlog/archive_status ... ok
creating directory /usr/local/pgsql/data/pg_clog ... ok
creating directory /usr/local/pgsql/data/pg_subtrans ... ok
creating directory /usr/local/pgsql/data/base ... ok
creating directory /usr/local/pgsql/data/base/1 ... ok
creating directory /usr/local/pgsql/data/pg_tblspc ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 50
creating configuration files ... ok
creating template1 database in /usr/local/pgsql/data/base/1 ... FATAL:  
could not create shared memory segment: Invalid argument
DETAIL:  Failed system call was shmget(key=1, size=1130496, 03600).
HINT:  This error usually means that PostgreSQL's request for a shared 
memory segment exceeded your kernel's SHMMAX parameter.  You can either 
reduce the request size or reconfigure the kernel with larger SHMMAX.  
To reduce the request size (currently 1130496 bytes), reduce 
PostgreSQL's shared_buffers parameter (currently 50) and/or its 
max_connections parameter (currently 10).
        If the request size is already small, it's possible that it is 
less than your kernel's SHMMIN parameter, in which case raising the 
request size or reconfiguring SHMMIN is called for.
        The PostgreSQL documentation contains more information about 
shared memory configuration.
child process exited with exit code 1
initdb: removing data directory "/usr/local/pgsql/data"
La cuestion es que la maquina Solaris donde la estoy instalando no la 
utilizo solo yo y no quiero modificar ningun parametro del kernel en el 
/etc/system , ya que ademas tendria que rebotar la maquina ...
Alguien me podria decir donde puedo modificar los parametros que toma 
por defecto en las variables shared_buffers y max_connections . Por lo 
que he estado viendo en la documentacion estos parametros estan en el 
fichero postgresql.conf del directorio data , pero claro ese directorio 
nunca me lo llega a crear . ¿Seria necesario modificar la funcion 
initdb.c ? ... en fin , espero vuestra ayuda .
Muchas gracias
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rodrigo Cortés | 2005-09-16 12:25:56 | Re: Obtener lista de tablas de una bd. | 
| Previous Message | vespadict | 2005-09-16 08:24:58 | Re: replicar |