[ADMIN] postgresql won't restart. Cannot allocate memory. Must reboot. Any alternative short of reboot?

Hi, I am a very happy user of Postgresql! Thank you all for this marvelous work! I have an older linux server running debian etch 4.0 using the old postgresql-7.4. There is essentially a single application running on that machine which serves up data from a single postgresql database. There i

Re: [ADMIN] Severe Badness On My Server: psql: FATAL: the database

to separate out the point of failure of the hard drives from postgresql. What do you think? Thanks again both of you!, Mitchell Laks ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

[ADMIN] Severe Badness On My Server: psql: FATAL: the database system is starting up

Dear Gurus: My Server and me have had a very bad weekend, starting Friday afternoon. I am running Debian Sarge, Postgresql 7.4.6 with linux kernel 2.6.8. I am running a Postgresql backed application on a remote server. The system has a system drive, on which the Postgresql database runs and ther

[ADMIN] how to make a trigger to copy files.

ry just made into the database, and $destination is my other pc? Thanks, Mitchell Laks ---(end of broadcast)--- TIP 8: explain analyze is your friend

[ADMIN] input in flex scanner failed

before I blow the machine away? Thanks for all your help, Mitchell Laks ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [ADMIN] Postgresql on software RAID

smooth. MItchell Laks >On Thursday 18 December 2003 12:13 am, you wrote: > When grilled further on (Wed, 17 Dec 2003 08:45:43 -0700 (MST)), > > "scott.marlowe" <[EMAIL PROTECTED]> confessed: > > Just wondering, was that on hardware or software RAID5, and if hardw

[ADMIN] where is the database physically

Hi. Thank you all for your thoughful comments, Philo and Jeremy. One question wasn't addressed (mixed in with the mess of comments, my fault...). Where is the database located physically - i guess /var/lib/pgsql but how is it broken into files. For instance in mysql, i find the directory /var/

[ADMIN] repair table? database? how ? neccessary?

Hi. I have suffered for the last few years with M$ft access as the database backbone for an application that I have been running. After scouring the internet, I have switched the application to running on Linux, and using Postgresql. The main issue I had with Access was that as the database got