Berkeley POSTGRES user mailing list (1991-06 → 1997-01)
help / color / mirror / Atom feedProblems with postgres
5+ messages / 4 participants
[nested] [flat]
* Problems with postgres
@ 1992-06-10 23:57 Ted Frohling <[email protected]>
0 siblings, 1 reply; 5+ messages in thread
From: Ted Frohling @ 1992-06-10 23:57 UTC (permalink / raw)
To: legacy
Hi,
I recently upgraded to SunOS 4.1.2 and now postgres doesn't seem to want
to run.
I startup postmaster in the rc.local file but it core dumps with a memory
violation. After the system boots, as root I start up postmaster by hand
and it runs or seems to.
I then try to create the first database.
~/postgres/bin/createdb postgres as user postgres
and get the following error message:
FATAL 1:Jun 9 08:40:31:AttachSLockMemory: could not attach segment
createdb: database creation failed on postgres.
I have reconfigured the kernel and rebooted using it.
Any clues out there??
ted
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Problems with postgres
@ 1992-06-15 09:24
parent: Ted Frohling <[email protected]>
0 siblings, 0 replies; 5+ messages in thread
From: @ 1992-06-15 09:24 UTC (permalink / raw)
To: legacy
you write:
> I recently upgraded to SunOS 4.1.2 and now postgres doesn't seem to want
> to run.
>
> I startup postmaster in the rc.local file but it core dumps with a memory
> violation. After the system boots, as root I start up postmaster by hand
> and it runs or seems to.
>
> I then try to create the first database.
>
> ~/postgres/bin/createdb postgres as user postgres
> and get the following error message:
>
> FATAL 1:Jun 9 08:40:31:AttachSLockMemory: could not attach segment
>
> createdb: database creation failed on postgres.
>
> I have reconfigured the kernel and rebooted using it.
>
> Any clues out there??
I run postgres under SunOs 4.1.2 on our sparc I and things have worked fine.
Are you starting the postmaster as root? You might try starting as postgres.
Failing this, you can try (saving your data directory) reinstalling from
scratch.
Jeff Meredith
[email protected]
^ permalink raw reply [nested|flat] 5+ messages in thread
* Problems with POSTGRES
@ 1992-10-05 23:06 Noemi Romo Villalobos <[email protected]>
0 siblings, 0 replies; 5+ messages in thread
From: Noemi Romo Villalobos @ 1992-10-05 23:06 UTC (permalink / raw)
To: legacy; +Cc: Noemi Romo Villalobos <[email protected]>
I have been working with POSTGRES, but I have a lot of problems with
memory. First I give "postmaster &", and then the "monitor" commands.
But when I give "retrieve (u.all) from u in pg_user \g", the monitor
stay long time; at same time, in other window I watch the memory
available with the "pstat -s" statement, and the memory is less every
moment, until the process break down. Every time I work with POSTGRES
happen the same. Do you know what is happening?.
The last test I did, was with a LIBPQ and C program; the same
happened. I had break down the process and the memory reduce it also. A
"Vfork failed" message was displayed and the machine hanged up.
I'm starting my tesis prototype, and I have limit time. Could you say
me how can I do to fix it?
Thanks.
Noemi Romo Villalobos.
[email protected]
Instituto Tecnologico y de Estudios Superiores de Monterrey
CETEC 6o. Piso Torre Norte
Monterrey, Mexico.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Problems with POSTGRES
@ 1993-04-22 19:37 Manoj K. Jain <[email protected]>
0 siblings, 0 replies; 5+ messages in thread
From: Manoj K. Jain @ 1993-04-22 19:37 UTC (permalink / raw)
To: legacy
Here at Indiana University, we are using Postgres in one of the
database systems class. There are about 15-16 students in the class
and sometimes about 10-12 students use the Postgres system at the
same time. Some of them did their assignment entirely in POSTQUEL,
but some of them used Portals and Postquel embedded in C.
While POSTGRES ran fine if only POSTQUEL was being used (and about 5-6
people were using Postgres at the same time), it (postmaster) was very
flaky when people were running their C programs (with embedded postquel).
They got the following error at several times (I am including the errors
of just two runs...though people had problems all the time while somebody
was using portals and embedded C (all of them are same kind of errors):
Error 1:
>center:~/c690/task3 .22 %q2
>please enter the student name and course id
>joe 100
>WARN:Apr 5 22:45:27:cannot write block 0 of delta [gwu1] blind
>Error: No response from the backend, exiting...
Error 2:
>Query sent to backend is "remove function check " (my stuff)
>WARN:Apr 9 21:31:40:cannot write block 1 of pg_typeidind [abadia] blind
>>>>>>>> (hangs at this point)
>>>>>>>>> (I then restarted it)
>Go
>* \i check1 \g (mystuff)
Another thing is that postmaster hangs after 3 or 4 of these errors occur.
This is because there are several processes hanging in the postgres account.
I should also point out that the database owner of "gwu1" and "abadia" (the
names which appear in the error) were using embedded C.
Any clues as to why this is happening?
Thanks.
-- Manoj
^ permalink raw reply [nested|flat] 5+ messages in thread
* Problems with Postgres
@ 1996-05-03 17:48 Cristina Moreira Nunes <[email protected]>
0 siblings, 0 replies; 5+ messages in thread
From: Cristina Moreira Nunes @ 1996-05-03 17:48 UTC (permalink / raw)
To: legacy; +Cc: [email protected]
Hi,
Somebody knows how can I delete fisically instancies from a class?
I used the delete command, but the size is the same.
I am using Postgres v4.0.
Thanks,
Cristina Nunes
[email protected]
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "[email protected]".
If this fails, send mail to "[email protected]" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~1996-05-03 17:48 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1992-06-10 23:57 Problems with postgres Ted Frohling <[email protected]>
1992-06-15 09:24 `
1992-10-05 23:06 Problems with POSTGRES Noemi Romo Villalobos <[email protected]>
1993-04-22 19:37 Problems with POSTGRES Manoj K. Jain <[email protected]>
1996-05-03 17:48 Problems with Postgres Cristina Moreira Nunes <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox