PT3 performance tuning 2 HDDs

[mrsfishnet]

Hey,

I am happy that there is a faster way. although i can't figure it out.

at first i now have 2DB: following info is when i go to database management!
*my backup with DBname: "PT3_2009_09_09_193650" and DB info: "Database: pt3_newdb; Server: localhost; Port: 5432; USER: postgres;
and
*My new empty tablespace DB: "PT3_JAN 16-07-2010" and DB info: "Database: pt3_newjan; Server: localhost; Port: 5432; USER: postgres;

Then at the psql prompt after you've connected to your database run the following commands:

How should i connect with the database? in PT3? or in the prompt? more details would be nice for a noob

ALTER DATABASE "Your Database Name" SET TABLESPACE spare_disk;

I tried writing this:
"ALTER DATABASE PT3_2009_12_09_193650 SET TABLESPACE spare_disk;"
and
"ALTER DATABASE PT3_newdb SET TABLESPACE spare_disk;"

When i type this, i get this error: (translated from dutch)
ALTER is not recognized as an internal or external command, programme or batch file.


i didn't get further than this.

hope to hear from you soon

[kraada]

Click Start --> Programs --> PostgreSQL --> psql to 'postgres' - at the prompt, enter:
\connect "Your Database Name"

and once you hit enter the prompt will change to indicate that you've connected to your database. Then follow the steps above and the commands should work properly.

[mrsfishnet]

ok, so i connected to my db by typing "\connect pt3_newdb" (this is the old slow one. not the empty one) Is this correct?
It says i am connected. so this should be fine.

when i want to type: "ALTER DATABASE "Your Database Name" SET TABLESPACE spare_disk;"
I get this error: syntax error at or near "spare_disk"
under the first letter of "spare" comes a "^" sign.
I tried retyping it with a capital S and stuff. but it keeps giving the same error.

Maybe a need to type my disk drive (P:\) instead of spare disk?

Any help will be appreciated.

[kraada]

Ah, no that was my fault. Use this command instead:

ALTER DATABASE "Your Database Name" SET default_tablespace to spare_disk;

That should do it.

[octopus]

Thanks for the how-to, everything works fine for me with PG 9.0 and PT 3. Except when creating the database, i had to specify the character encoding, or else i'd end up with UTF8 and various import errors, probably caused by player names with strange characters. PT operates with SQL ASCII as long as i understand.

So for the command i used this:

Code: Select all

CREATE DATABASE pt3_ext WITH ENCODING 'SQL_ASCII' TEMPLATE=template0 TABLESPACE spare_disk;

[kraada]

Yes, PT3 needs to be SQL ASCII - PT4 is UTF 8.