agora inbox for postgres@postgres.berkeley.eduhelp / color / mirror / Atom feed
temp files and dual dbs 2+ messages / 2 participants [nested] [flat]
* temp files and dual dbs @ 1994-09-22 01:16 Glen Darby <glen@macadam.mpce.mq.edu.au> 0 siblings, 1 reply; 2+ messages in thread From: Glen Darby @ 1994-09-22 01:16 UTC (permalink / raw) To: legacy Hi, Im not sure if my initial message got through but Ill try again. I have developed an application that uses dual databases (one remotely and one locally), I have two problems at the moment. Firstly I seem to get a lot of tempxxx files generated in the ~postgres/data/base/appdb directory. Can I just remove this files, what causes them or should I get postgres to remove them somehow ? Secondly when the remote db and the local db actually live on the same machine I occasionally get crashes from postgres indicating that the local db doesnt exist when in fact it does. Is there a switching delay when both dbs are on the same machine or is more likely poor coding on behalf :) I am using this on 3 Suns all running SunOS 4.1.3 or 4.1.3_U1 on Sun is a Sparc 10 and the others are ipx's. Thanx for any assistance you can give in this matter. ----------------------------------------------------------------------------- | Glen Darby | Email : glen@mpce.mq.edu.au | | Computer Systems Officer | Phone : +61 2 850-9508 | | Maths/Physics/Computing/Electronics | Fax : +61 2 850-9551 | | Macquarie University (Australia) | | ============================================================================= ============================================================================== 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. ============================================================================== ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: temp files and dual dbs @ 1994-09-23 20:21 Paul M. Aoki <aoki@cs.berkeley.edu> parent: Glen Darby <glen@macadam.mpce.mq.edu.au> 0 siblings, 0 replies; 2+ messages in thread From: Paul M. Aoki @ 1994-09-23 20:21 UTC (permalink / raw) To: Glen Darby <glen@macadam.mpce.mq.edu.au>; +Cc: legacy glen@macadam.mpce.mq.edu.au (Glen Darby) writes: > Firstly I seem to get a lot of tempxxx files generated in the > ~postgres/data/base/appdb directory. Can I just remove this files, what > causes them or should I get postgres to remove them somehow ? if you don't have any backends running at the time, it's safe to remove them. > Secondly when the remote db and the local db actually live on the same > machine I occasionally get crashes from postgres indicating that the local > db doesnt exist when in fact it does. i don't understand what you mean by "remote db" and "local db", i.e., whether there are two postmasters running on different machines, or one set of database directories are nfs-mounted and the other is not, or what. -- Paul M. Aoki | University of California at Berkeley aoki@CS.Berkeley.EDU | Dept. of EECS, Computer Science Division (#1776) | Berkeley, CA 94720-1776 ============================================================================== 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. ============================================================================== ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1994-09-23 20:21 UTC | newest] Thread overview: 2+ messages (download: mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 1994-09-22 01:16 temp files and dual dbs Glen Darby <glen@macadam.mpce.mq.edu.au> 1994-09-23 20:21 ` Paul M. Aoki <aoki@cs.berkeley.edu>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox