Обсуждение: Recovering disk space...
Greetings, I'm moving files in preparation of loading them into their appropriate databases. I just ran out of space on my system before I got all the files moved. I seem to remember reading some place that there is a command that will go clean up after a successful postgres installation. I want to get rid of all the set up files that I no longer need. Is there such a command or is this just wishful thinking. Carol
I'm running on Solaris 10 and postgreSQL 8.2.10. Thanks, Carol On Oct 24, 2008, at 7:47 AM, Helio Campos Mello de Andrade wrote: > On Thu, Oct 23, 2008 at 4:12 PM, Carol Walter <walterc@indiana.edu> > wrote: >> Greetings, >> >> I'm moving files in preparation of loading them into their >> appropriate >> databases. I just ran out of space on my system before I got all >> the files >> moved. I seem to remember reading some place that there is a >> command that >> will go clean up after a successful postgres installation. I want >> to get >> rid of all the set up files that I no longer need. Is there such a >> command >> or is this just wishful thinking. >> >> Carol >> >> -- >> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-admin >> > > > Can you give us the name of the Operating System you are using? It > will help a lot.. :) > > -- > Helio Campos Mello de Andrade
On Fri, Oct 24, 2008 at 8:43 AM, Carol Walter <walterc@indiana.edu> wrote: > I'm running on Solaris 10 and postgreSQL 8.2.10. > > Thanks, > Carol > > On Oct 24, 2008, at 7:47 AM, Helio Campos Mello de Andrade wrote: > >> On Thu, Oct 23, 2008 at 4:12 PM, Carol Walter <walterc@indiana.edu> wrote: >>> >>> Greetings, >>> >>> I'm moving files in preparation of loading them into their appropriate >>> databases. I just ran out of space on my system before I got all the >>> files >>> moved. I seem to remember reading some place that there is a command >>> that >>> will go clean up after a successful postgres installation. I want to get >>> rid of all the set up files that I no longer need. Is there such a >>> command >>> or is this just wishful thinking. >>> >>> Carol Are you referring to VACUUM? That only clears out and marks free space within the database. If it's external files, then I don't really know. Which files do you need to "clean up"? Peter