Two Databases - Each in a different drive

[kraada]

There are also options to do things in other ways in PGAdmin that might suit you a bit better. Right click on your server (where it says PostgreSQL 9.1) and choose New -> Tablespace. Give it a name, set the owner to the postgres user via the drop down. Enter your directory on the Definition tab. You shouldn't need to set anything else. You'll see the SQL used to create it on the SQL tab and you can compare it to what is here.

Once you have the tablespace, right click on where it says Databases and choose New Database. Again give it a name. On the Definition page, pick an existing PT4 database as a Template (this will save later steps - you won't need to run the schema definition manually), pick the table space. That actually should be all you need to do.

[leviathan74]

I think I did it, I connected the new database and it seems to be working on PT fine. A thousand thanks.

One more question. What steps should I take if I want I rename the pg_data folder I just created on Drive D to a somewhat more human name? Or this is not feasible at all?

[kraada]

Honestly while it can be done it's not worth the work of mucking around in configuration files just to have a different name.

[leviathan74]

I guess I can delete the new database, delete the tablespace I created and start the process anew, right? It didn't take that long.

But there's no imperative that the folder on drive d has to be called pg_data, right?

[kraada]

That's also fine if it bothers you that much. It can be named whatever you like, but it must be empty until the tablespace is created or the creation will fail.

[leviathan74]

Triumph. I ve renamed everything like I wanted, moved the database to Drive D, deleted the old one and saved some space, everything seems to be working fine.

Final question. Do I still need the schema.postgres.sql file on Drive D?

[Dreamstrike]

Just working though this myself. When I try and backup my DB I get this the attacked picture:


Its a brand new 1Tb external HD and the database is only 28GB pls advise

[WhiteRider]

The TEMP folder is almost certainly on your main drive so if that is nearly full that could be the problem. Try freeing up some space on the main drive.
You could also change the TEMP environment variable to point to a different drive, but if the only other drive is your external drive that wouldn't be ideal as it would slow things down somewhat when Windows needs to use the TEMP folder and it would mean that the drive would always need to be connected or you could cause problems in Windows.

[Dreamstrike]

cheers mate. windows 10 dumped 26gb. all sorted now