pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Postgres in Solaris 8
4+ messages / 4 participants
[nested] [flat]

* Postgres in Solaris 8
@ 2005-09-16 09:38 vespadict <vespadict@gmail.com>
  2005-09-16 14:17 ` Re: Postgres in Solaris 8 Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 4+ messages in thread

From: vespadict @ 2005-09-16 09:38 UTC (permalink / raw)
  To: pgsql-admin

Hi :

I'm trying to install postgres in Solaris 8. I tried with 7.3.10 and 
8.0.3 postgres versions but I have the same
problem in both. The compilation process was ok but in the init process 
I have the next 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"

The Solaris machine that I'm using is not only for my project so I can´t 
modify any kernel parameter in /etc/system principally because after 
need a reboot ... so , where can I modify the shared_buffers and 
max_connection parameters ?
The problem is that these parameters are in postgresql.conf in /data 
directory but I don´t have this directory.
Is necesary to modify the initdb.c function ???

Thanks for your help ...



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Postgres in Solaris 8
  2005-09-16 09:38 Postgres in Solaris 8 vespadict <vespadict@gmail.com>
@ 2005-09-16 14:17 ` Tom Lane <tgl@sss.pgh.pa.us>
  2005-09-20 09:04   ` Re: Postgres in Solaris 8 the vespadict <vespadict@gmail.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Tom Lane @ 2005-09-16 14:17 UTC (permalink / raw)
  To: vespadict@gmail.com; +Cc: pgsql-admin

vespadict <vespadict@gmail.com> writes:
> The Solaris machine that I'm using is not only for my project so I can´t 
> modify any kernel parameter in /etc/system principally because after 
> need a reboot ... so , where can I modify the shared_buffers and 
> max_connection parameters ?

initdb already tried values that were much smaller than reasonable.
If you can't increase SHMMAX beyond 1 megabyte, use another machine.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Postgres in Solaris 8
  2005-09-16 09:38 Postgres in Solaris 8 vespadict <vespadict@gmail.com>
  2005-09-16 14:17 ` Re: Postgres in Solaris 8 Tom Lane <tgl@sss.pgh.pa.us>
@ 2005-09-20 09:04   ` the vespadict <vespadict@gmail.com>
  2005-09-20 12:00     ` Re: Postgres in Solaris 8 Alvaro Herrera <alvherre@alvh.no-ip.org>
  0 siblings, 1 reply; 4+ messages in thread

From: the vespadict @ 2005-09-20 09:04 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin

Thanks for your answer .

I changed the kernel parameter . After I executed the initdb and the
'data' directory was created , so I changed the postgresql.conf
parameters and executed the 'postmaster'.

All was OK . Finally I restored the kernel parameters like originally
and all works now fine !!

Thank you for all.


2005/9/16, Tom Lane <tgl@sss.pgh.pa.us>:
> vespadict <vespadict@gmail.com> writes:
> > The Solaris machine that I'm using is not only for my project so I can´t
> > modify any kernel parameter in /etc/system principally because after
> > need a reboot ... so , where can I modify the shared_buffers and
> > max_connection parameters ?
> 
> initdb already tried values that were much smaller than reasonable.
> If you can't increase SHMMAX beyond 1 megabyte, use another machine.
> 
>                         regards, tom lane
>



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Postgres in Solaris 8
  2005-09-16 09:38 Postgres in Solaris 8 vespadict <vespadict@gmail.com>
  2005-09-16 14:17 ` Re: Postgres in Solaris 8 Tom Lane <tgl@sss.pgh.pa.us>
  2005-09-20 09:04   ` Re: Postgres in Solaris 8 the vespadict <vespadict@gmail.com>
@ 2005-09-20 12:00     ` Alvaro Herrera <alvherre@alvh.no-ip.org>
  0 siblings, 0 replies; 4+ messages in thread

From: Alvaro Herrera @ 2005-09-20 12:00 UTC (permalink / raw)
  To: the vespadict <vespadict@gmail.com>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; pgsql-admin

On Tue, Sep 20, 2005 at 11:04:56AM +0200, the vespadict wrote:
> Thanks for your answer .
> 
> I changed the kernel parameter . After I executed the initdb and the
> 'data' directory was created , so I changed the postgresql.conf
> parameters and executed the 'postmaster'.
> 
> All was OK . Finally I restored the kernel parameters like originally
> and all works now fine !!

You forgot to mention that you set shared_buffers to 32 after initdb.
Sorry if I'm repeating myself but that seems a pretty dumb idea.

-- 
Alvaro Herrera                  http://www.amazon.com/gp/registry/5ZYLFMCVHXC
"Et put se mouve" (Galileo Galilei)



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2005-09-20 12:00 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-09-16 09:38 Postgres in Solaris 8 vespadict <vespadict@gmail.com>
2005-09-16 14:17 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-09-20 09:04   ` the vespadict <vespadict@gmail.com>
2005-09-20 12:00     ` Alvaro Herrera <alvherre@alvh.no-ip.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox