how can i use the initdb?

[henryhcface]

i use the comman , initdb in my postgresql

as followers

initdb henryDB

means ,i want to create the database henryDB

but wrong .syntax error at or near "initdb" at character 1

how can i do ? thank you

[henryhcface]

fixing permissions on existing directory e:/testdb ... ok
creating directory e:/testdb/global ... ok
creating directory e:/testdb/pg_xlog ... ok
creating directory e:/testdb/pg_xlog/archive_status ... ok
creating directory e:/testdb/pg_clog ... ok
creating directory e:/testdb/pg_subtrans ... ok
creating directory e:/testdb/pg_twophase ... ok
creating directory e:/testdb/pg_multixact/members ... ok
creating directory e:/testdb/pg_multixact/offsets ... ok
creating directory e:/testdb/base ... ok
creating directory e:/testdb/base/1 ... ok
creating directory e:/testdb/pg_tblspc ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 50

i can not found these files ,above >?
why ?

[rski]

i use the comman , initdb in my postgresql

as followers

initdb henryDB

means ,i want to create the database henryDB

but wrong .syntax error at or near "initdb" at character 1

how can i do ? thank you

Initdb is not for creating database but for creating clusters see here

http://www.postgresql.org/docs/8.0/interactive/app-initdb.html

[henryhcface]

thank you rski

but now i have another question, because in our project

some tables have too records ,so the speed of the run application is
very slow ,

we plan to use partition table. but what can we do ?
the restriction condition as followers

the original data in the table ,

the table have 2 foreign key

expecting your answers . thank you!
henry

[henryhcface]

the original data in the table ,

means how could i move the data .to other partition tables,

and at the same time the foreign key also must be taken

account.

[henryhcface]

expecting ....
expecting ....
expecting ....expecting ....

[rski]

I think i would be enough to create tables which inherrited (with a where clause) from the parent table (original table).
Give u'r parrent table and tell how u want to partition it.

Do u understand what I mean?