pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres 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