PT3 performance tuning 2 HDDs

[WhiteRider]

You're welcome.

[Traclugator]

1) Can i create the new DB on a spare disk using custom encoding?
2) How can i connect to command-line-created DB from other Windows installation?

[WhiteRider]

There are links in the "How To" section of the Database / Postgres FAQ which should help you set up what you want.

[live2bet]

Now we need to allow the database user full access to this folder. Right click on pg_data and click Properties. Choose the Security tab, and click "Add" and type "postgres" (without the quotes), then click "Check Names" to change the name to the correct format and then click "OK". "Postgres" should now appear in the list of names available. Click on it, then look underneath and check the box that says "Allow/Full Control". Click Apply and then OK. Now the database user has complete rights to control this folder.

Cannot find "Add"


Also,

Click Start --> Programs --> PostgreSQL --> psql to template1. This will open up a console window. In the console type:

Cannot find psql to template1


Advise please.
Thank you.

[WhiteRider]

Click "Edit" then click "Add" on the next Window.

"psql to postgres" should do it.

[live2bet]

Thanks WhiteRider.

What about this warning code?



Thanks for your patient and help, just bear with me please, i'm almost there.

[kraada]

You can safely ignore that warning.

[live2bet]

Cool kraada.
Now you can go to bed .
Thanks.

[kraada]

Bed? It's 10AM over here, I'm not going to bed anytime soon

[live2bet]

Thought you never sleep.

By using 2 HDDs would it be considered as RAID0?