agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedFrom: Daryl Sayers <daryl@stone.oz.au>
To: postgres@postgres.Berkeley.EDU
Date: Fri, 12 Apr 96 15:46:39 AEST
Message-ID: <9604121546.aa08103@odtdev.stone.oz.au> (raw)
Newsgroups: stone.mlist.postgres
Path: daryl
From: daryl@stone.oz.au (Daryl Sayers)
Subject: 4.2 on Solaris causing big problems
Organization: Stone Microsystems, NSW, Australia
Date: Fri, 12 Apr 1996 05:46:35 GMT
Message-ID: <DpqIpo.68J@stone.oz.au>
X-Newsreader: NN version 6.5.0 #3
I have been using PG4.2 for a yaer or so without problems. It is a simple
Client record system using tk/tcl as the front end (PQTCL). I have
now run into a problem when accessing a database.
Using monitor I get 2 possible errors.
1. Read all the records (retrieve (CLASS.all) \g but will not return to the
Prompt after printing all records
2. After printing all the records it prints
WARN:Apr 12 15:31:32:cannot open segment 1 of relation pg_time
The process does not die either. Doing a ps shows
/usr/local/postgres-4.2/bin/./postgres -p -Q -o /dev/null -P4 Stone
still there.
In the data directory I have a huge pg_log and large pg_time.
-rw------- 1 postgres cdb 134234112 Apr 12 15:31 pg_log
-rw------- 1 postgres cdb 4595712 Apr 12 13:03 pg_time
Any ideas on how to fix this. I have reinstalled from a backup but
it eventually causes the same problem after adding a few records.
--
Daryl Sayers Ph: (02) 417 3788
Stone Group Asia Pacific Fax: (02) 417 3741
Unit 20, 380 Eastern Valley Way Email: daryl@stone.oz.au
Roseville, 2069 NSW Australia WWW: http://sydney.DIALix.com/~stone
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: postgres@postgres.berkeley.edu
Cc: daryl@stone.oz.au
Subject: Re:
In-Reply-To: <9604121546.aa08103@odtdev.stone.oz.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox