In VMWare Player on Win7 can't expand my virtual OS's disk even though I have 10GB free on my Win7 file system

Question

please i need help, i want to cancel an SQL query in postgresql (update) after the execution how can i do that ?

this is my sql query:

UPDATE mail_activity2 SET activity_type_id =3 WHERE activity_type_id = 5 ;

Thanks in advance.

Solution

OK I figured it out. VMWare Player doesn't expand your disk in place. It creates a new file of the new size then copies the contents of the old file to the new file. So if you want to expand from 16GB to 20GB, you need 36GB, so that a 16GB file and a 20Gb file can coexist while the contents of the 16GB file is copied over to the 20GB file

Comments

[Joe C]

Is it fair to give me a down vote for this? What on earth is wrong with this question?

[Lukasz Szozda]

What do you mean by cancel? Is it still running or you want revert changes? In first scenario just kill the query, in second you need a logic to recover old values or restore from backup.

[a_horse_with_no_name]

this depends on the SQL client you are using. I believe in psql you can simply hit Ctrl-C

[Lukasz Szozda]

after the execution how can i do that ? - Restore from backup.

[Pacerier]

So how do we make it extend the existing file instead of making a copy?

[Sebastian Patten]

If only their help articles said this as simply as you did.

[Saloua SAHNOUNE]

No, i want to revert change made by this query