pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpostmaster failure
4+ messages / 2 participants
[nested] [flat]
* postmaster failure
@ 2000-02-03 19:50 Christopher R. Jones <cj@interlog.com>
0 siblings, 1 reply; 4+ messages in thread
From: Christopher R. Jones @ 2000-02-03 19:50 UTC (permalink / raw)
To: pgsql-admin
I installed postgres-6.5 on Solaris 7, Intel - Pentium Pro, 128 MByte Ram.
I used gcc-2.95.1 and gnu make. The program compiled installed fine but
postmaster failed:
cr-jay.com% initdb
We are initializing the database system with username postgres (uid=1003).
This user will own all the files and must also own the server process.
Creating Postgres database system directory /usr/local/pgsql/data
Creating Postgres database system directory /usr/local/pgsql/data/base
Creating template database in /usr/local/pgsql/data/base/template1
Creating global classes in /usr/local/pgsql/data/base
Adding template1 database to pg_database...
Vacuuming template1
Creating public pg_user view
Creating view pg_rules
Creating view pg_views
Creating view pg_tables
Creating view pg_indexes
Loading pg_description
cr-jay.com% postmaster -i
IpcMemoryCreate: shmget failed (Invalid argument) key=5432001,
size=1063936, permission=600
FATAL 1: ShmemCreate: cannot create region
So then, after reading in the faq, I edited the /etc/system file to add:
set shmsys:shminfo_shmmax=1048567
set shmsys:shminfo_shmmin=200
set shmsys:shminfo_shmmni=200
set shmsys:shminfo_shmseg=200
set semsys:seminfo_semmap=250
set semsys:seminfo_semmni=500
set semsys:seminfo_semmns=500
set semsys:seminfo_semmsl=500
set semsys:seminfo_semmnu=500
set semsys:seminfo_semume=100
I now get:
cr-jay.com% postmaster -i
IpcMemoryCreate: shmget failed (Invalid argument) key=5432010, size=120,
permission=700
IpcMemoryIdGet: shmget failed (No such file or directory) key=5432010,
size=120, permission=0
IpcMemoryAttach: shmat failed (Invalid argument) id=-2
FATAL 1: AttachSLockMemory: could not attach segment
I played with the segment max size to no avail.
Any ideas?
Christopher R. Jones, P.Eng.
14 Oneida Avenue
Toronto, Ontario M5J 2E3
Tel. 416 203-7465
Fax. 416 203-3044
Email cj@interlog.com
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [ADMIN] postmaster failure
@ 2000-02-03 20:16 The Hermit Hacker <scrappy@hub.org>
parent: Christopher R. Jones <cj@interlog.com>
0 siblings, 0 replies; 4+ messages in thread
From: The Hermit Hacker @ 2000-02-03 20:16 UTC (permalink / raw)
To: Christopher R. Jones <cj@interlog.com>; +Cc: pgsql-admin
what does an 'ipcs' show? did you reboot after editing /etc/system? if
you can't reboot, use the -B option to reduce the number of segments used
until you can reboot with the new /etc/system in place ...
On Thu, 3 Feb 2000, Christopher R. Jones wrote:
> I installed postgres-6.5 on Solaris 7, Intel - Pentium Pro, 128 MByte Ram.
> I used gcc-2.95.1 and gnu make. The program compiled installed fine but
> postmaster failed:
>
> cr-jay.com% initdb
>
> We are initializing the database system with username postgres (uid=1003).
> This user will own all the files and must also own the server process.
>
> Creating Postgres database system directory /usr/local/pgsql/data
>
> Creating Postgres database system directory /usr/local/pgsql/data/base
>
> Creating template database in /usr/local/pgsql/data/base/template1
>
> Creating global classes in /usr/local/pgsql/data/base
>
> Adding template1 database to pg_database...
>
> Vacuuming template1
> Creating public pg_user view
> Creating view pg_rules
> Creating view pg_views
> Creating view pg_tables
> Creating view pg_indexes
> Loading pg_description
>
> cr-jay.com% postmaster -i
> IpcMemoryCreate: shmget failed (Invalid argument) key=5432001,
> size=1063936, permission=600
> FATAL 1: ShmemCreate: cannot create region
>
> So then, after reading in the faq, I edited the /etc/system file to add:
> set shmsys:shminfo_shmmax=1048567
> set shmsys:shminfo_shmmin=200
> set shmsys:shminfo_shmmni=200
> set shmsys:shminfo_shmseg=200
> set semsys:seminfo_semmap=250
> set semsys:seminfo_semmni=500
> set semsys:seminfo_semmns=500
> set semsys:seminfo_semmsl=500
> set semsys:seminfo_semmnu=500
> set semsys:seminfo_semume=100
>
> I now get:
> cr-jay.com% postmaster -i
> IpcMemoryCreate: shmget failed (Invalid argument) key=5432010, size=120,
> permission=700
> IpcMemoryIdGet: shmget failed (No such file or directory) key=5432010,
> size=120, permission=0
> IpcMemoryAttach: shmat failed (Invalid argument) id=-2
> FATAL 1: AttachSLockMemory: could not attach segment
>
> I played with the segment max size to no avail.
>
> Any ideas?
>
>
> Christopher R. Jones, P.Eng.
> 14 Oneida Avenue
> Toronto, Ontario M5J 2E3
> Tel. 416 203-7465
> Fax. 416 203-3044
> Email cj@interlog.com
>
>
>
> ************
>
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [ADMIN] postmaster failure
@ 2000-02-03 20:25 Christopher R. Jones <cj@interlog.com>
0 siblings, 1 reply; 4+ messages in thread
From: Christopher R. Jones @ 2000-02-03 20:25 UTC (permalink / raw)
To: The Hermit Hacker <scrappy@hub.org>; +Cc: pgsql-admin
I should have read more messages in the archives. Right after I sent my
message, I read that the following is typical:
set shmsys:shminfo_shmmax=16777216
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=51
postmaster now starts. Thanks for your help.
One more thing - is there a password access facility for users in the
postgres system?
>
>what does an 'ipcs' show? did you reboot after editing /etc/system? if
>you can't reboot, use the -B option to reduce the number of segments used
>until you can reboot with the new /etc/system in place ...
>
>On Thu, 3 Feb 2000, Christopher R. Jones wrote:
>
>> I installed postgres-6.5 on Solaris 7, Intel - Pentium Pro, 128 MByte Ram.
>> I used gcc-2.95.1 and gnu make. The program compiled installed fine but
>> postmaster failed:
>>
>> cr-jay.com% initdb
>>
>> We are initializing the database system with username postgres (uid=1003).
>> This user will own all the files and must also own the server process.
>>
>> Creating Postgres database system directory /usr/local/pgsql/data
>>
>> Creating Postgres database system directory /usr/local/pgsql/data/base
>>
>> Creating template database in /usr/local/pgsql/data/base/template1
>>
>> Creating global classes in /usr/local/pgsql/data/base
>>
>> Adding template1 database to pg_database...
>>
>> Vacuuming template1
>> Creating public pg_user view
>> Creating view pg_rules
>> Creating view pg_views
>> Creating view pg_tables
>> Creating view pg_indexes
>> Loading pg_description
>>
>> cr-jay.com% postmaster -i
>> IpcMemoryCreate: shmget failed (Invalid argument) key=5432001,
>> size=1063936, permission=600
>> FATAL 1: ShmemCreate: cannot create region
>>
>> So then, after reading in the faq, I edited the /etc/system file to add:
>> set shmsys:shminfo_shmmax=1048567
>> set shmsys:shminfo_shmmin=200
>> set shmsys:shminfo_shmmni=200
>> set shmsys:shminfo_shmseg=200
>> set semsys:seminfo_semmap=250
>> set semsys:seminfo_semmni=500
>> set semsys:seminfo_semmns=500
>> set semsys:seminfo_semmsl=500
>> set semsys:seminfo_semmnu=500
>> set semsys:seminfo_semume=100
>>
>> I now get:
>> cr-jay.com% postmaster -i
>> IpcMemoryCreate: shmget failed (Invalid argument) key=5432010, size=120,
>> permission=700
>> IpcMemoryIdGet: shmget failed (No such file or directory) key=5432010,
>> size=120, permission=0
>> IpcMemoryAttach: shmat failed (Invalid argument) id=-2
>> FATAL 1: AttachSLockMemory: could not attach segment
>>
>> I played with the segment max size to no avail.
>>
>> Any ideas?
>>
>>
>> Christopher R. Jones, P.Eng.
>> 14 Oneida Avenue
>> Toronto, Ontario M5J 2E3
>> Tel. 416 203-7465
>> Fax. 416 203-3044
>> Email cj@interlog.com
>>
>>
>>
>> ************
>>
>
>Marc G. Fournier ICQ#7615664 IRC Nick:
Scrappy
>Systems Administrator @ hub.org
>primary: scrappy@hub.org secondary:
scrappy@{freebsd|postgresql}.org
>
>
>
Christopher R. Jones, P.Eng.
14 Oneida Avenue
Toronto, Ontario M5J 2E3
Tel. 416 203-7465
Fax. 416 203-3044
Email cj@interlog.com
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [ADMIN] postmaster failure
@ 2000-02-03 21:19 The Hermit Hacker <scrappy@hub.org>
parent: Christopher R. Jones <cj@interlog.com>
0 siblings, 0 replies; 4+ messages in thread
From: The Hermit Hacker @ 2000-02-03 21:19 UTC (permalink / raw)
To: Christopher R. Jones <cj@interlog.com>; +Cc: pgsql-admin
On Thu, 3 Feb 2000, Christopher R. Jones wrote:
> I should have read more messages in the archives. Right after I sent my
> message, I read that the following is typical:
> set shmsys:shminfo_shmmax=16777216
> set shmsys:shminfo_shmmin=1
> set shmsys:shminfo_shmmni=100
> set shmsys:shminfo_shmseg=51
>
> postmaster now starts. Thanks for your help.
> One more thing - is there a password access facility for users in the
> postgres system?
password access facility? purely a guess, but I think you are referring
to the 'pg_hba.conf' file that is found in the data directory, whre you
can set various 'authentication' method on a database by database basis
...
> > >
> >what does an 'ipcs' show? did you reboot after editing /etc/system? if
> >you can't reboot, use the -B option to reduce the number of segments used
> >until you can reboot with the new /etc/system in place ...
> >
> >On Thu, 3 Feb 2000, Christopher R. Jones wrote:
> >
> >> I installed postgres-6.5 on Solaris 7, Intel - Pentium Pro, 128 MByte Ram.
> >> I used gcc-2.95.1 and gnu make. The program compiled installed fine but
> >> postmaster failed:
> >>
> >> cr-jay.com% initdb
> >>
> >> We are initializing the database system with username postgres (uid=1003).
> >> This user will own all the files and must also own the server process.
> >>
> >> Creating Postgres database system directory /usr/local/pgsql/data
> >>
> >> Creating Postgres database system directory /usr/local/pgsql/data/base
> >>
> >> Creating template database in /usr/local/pgsql/data/base/template1
> >>
> >> Creating global classes in /usr/local/pgsql/data/base
> >>
> >> Adding template1 database to pg_database...
> >>
> >> Vacuuming template1
> >> Creating public pg_user view
> >> Creating view pg_rules
> >> Creating view pg_views
> >> Creating view pg_tables
> >> Creating view pg_indexes
> >> Loading pg_description
> >>
> >> cr-jay.com% postmaster -i
> >> IpcMemoryCreate: shmget failed (Invalid argument) key=5432001,
> >> size=1063936, permission=600
> >> FATAL 1: ShmemCreate: cannot create region
> >>
> >> So then, after reading in the faq, I edited the /etc/system file to add:
> >> set shmsys:shminfo_shmmax=1048567
> >> set shmsys:shminfo_shmmin=200
> >> set shmsys:shminfo_shmmni=200
> >> set shmsys:shminfo_shmseg=200
> >> set semsys:seminfo_semmap=250
> >> set semsys:seminfo_semmni=500
> >> set semsys:seminfo_semmns=500
> >> set semsys:seminfo_semmsl=500
> >> set semsys:seminfo_semmnu=500
> >> set semsys:seminfo_semume=100
> >>
> >> I now get:
> >> cr-jay.com% postmaster -i
> >> IpcMemoryCreate: shmget failed (Invalid argument) key=5432010, size=120,
> >> permission=700
> >> IpcMemoryIdGet: shmget failed (No such file or directory) key=5432010,
> >> size=120, permission=0
> >> IpcMemoryAttach: shmat failed (Invalid argument) id=-2
> >> FATAL 1: AttachSLockMemory: could not attach segment
> >>
> >> I played with the segment max size to no avail.
> >>
> >> Any ideas?
> >>
> >>
> >> Christopher R. Jones, P.Eng.
> >> 14 Oneida Avenue
> >> Toronto, Ontario M5J 2E3
> >> Tel. 416 203-7465
> >> Fax. 416 203-3044
> >> Email cj@interlog.com
> >>
> >>
> >>
> >> ************
> >>
> >
> >Marc G. Fournier ICQ#7615664 IRC Nick:
> Scrappy
> >Systems Administrator @ hub.org
> >primary: scrappy@hub.org secondary:
> scrappy@{freebsd|postgresql}.org
> >
> >
> >
> Christopher R. Jones, P.Eng.
> 14 Oneida Avenue
> Toronto, Ontario M5J 2E3
> Tel. 416 203-7465
> Fax. 416 203-3044
> Email cj@interlog.com
>
>
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2000-02-03 21:19 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-02-03 19:50 postmaster failure Christopher R. Jones <cj@interlog.com>
2000-02-03 20:16 ` The Hermit Hacker <scrappy@hub.org>
2000-02-03 20:25 Re: [ADMIN] postmaster failure Christopher R. Jones <cj@interlog.com>
2000-02-03 21:19 ` The Hermit Hacker <scrappy@hub.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