Originally Posted by call1call2
if I want to use a 1 month old backup of c:\, delete all data there and rewrite it with 1 month old data and my actual database data is on e:\ will my database will still be as it is now?
should i do a database backup just in case? if yes is it possible to not use c:\ as temp space? i dont have enough space left at c:\.
If you have PostgreSQL installed on E: then everything should be fine, I think. If PostgreSQL is installed on C: with just the database itself on E: then I expect it will still be fine, but I wouldn't like to say for sure. Kraada is off today but he'll be able to give you a more conclusive answer tomorrow I'm sure.
I would always make a backup before doing anything like this, though.
PostgreSQL will use the TEMP environment variable in Windows to decide where to write the temp files so you could change that temporarily if you really can't free up enough space on c: - see this post
for details. I'd suggest changing it back afterwards as it affects many other things too.
For reference, something like CCleaner
can help you clear up disk space too.