newb: moving postgresql data from c:?

[zaxpoker]

hey!

I'm totally newb to configure postgresql i installed it by the step by step guide.

I just realized that my 17G C: became almost full since i installed pt3+pstgsql

exactly how much space does pstgsql require?

can I change it somehow that pstgsql should use other than the system drive? (i have 700g of harddisk space on other drives)

how?

srry for the newb q I'm really troubled

[kraada]

See this post for information on how to configure PostgreSQL to use another hard drive and this post for info on how to back up and restore your database.

PostgreSQL will take up more space the more hands you import. If you're having millions of hands of database it's going to (obviously) get quite large. Moving the data to your secondary hard drive should improve performance as well, so it's probably a good idea regardless.

[zaxpoker]

hey i did everything as i was told in the forum on how to make a new database on my i:\ drive

in the command prompt there might have been a problem pls check this:

http://img513.imageshack.us/my.php?imag ... mptuu9.jpg


there is a WARNING text following the spare_disk line

i made the steps after this also which all gave me a normal feedback and i have a new db now (i had schema.postgre.sql file succesfully loaded after what you see)

BUT

how can i check if that table and the whole db was set right onto I:?

does this WARNING mean that that command line wasn't executed?

how should i procced now?



+ how do i import the data intoto this new db supposedly on I: from my original db?

Thx for your quick answers!

[kraada]

It looks like you forgot to copy the schemas.postgre.sql from the PokerTracker 3/Data/Schemas/ directory. You can also use: \i "C:\Program Files\PokerTracker 3\Data\Schemas\schema.postgre.sql" -- copying it over just saves you retyping.

Once you have this database created, connect to it in PokerTracker 3 from the Database --> Database Management area (click new, click Browse and choose it), then just import the hands using the Manual Import as you did previously.