Thanks for your reply to my posting. Hope you would be willing to provide some additional assistance. What can I says, I really do not have enough experience to bail, myself out of this one.
i did cd /var/lib/pgsql/data then du-sh this reported 3.6gig This means I really have a 3.6 gig postgesql database? ********** Var contain also all log file of your box where would they be? can I dump old ones? well how do I dump them? ********* we run vacume everyday against the database. thanks in advance kd [EMAIL PROTECTED] (Gaetano Mendola) wrote in message news:<[EMAIL PROTECTED]>... > Duffy House wrote: > > > Hello: > > > > It looks like I got caught sleeping. > > > > I am running Postgresql 7.2 under Red Hat 7.3. > > Postgresql failed today. When I tried to restart it, I got a message > > stating that the device is full. > > I used df to confirm that /var where postgres reside is full. /var is > > on a 4 Gig device. > > Postgresql is the only application on this machine. > > > > Please note, the backup of the database from the prior day, is 45 Meg > > zipped. > > I do not know how the database could be soaking up a 4 Gig device. > > > > Questions: > > > > How can I recover from this situation? > > Var contain also all log file of your box I guess. > Go on your directory data ( on RH is on /var/lib/pgsql/data ) > and do : > > du -sh > > if is really 4GB move your data directory in another big partition, > make a simbolink link with your old location, start postgres and > do a vacuum full of your database. > > if is not really 4GB do a log rotate of your logs. > > > > > Regards > Gaetano Mendola > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
