By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,983 Members | 1,717 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,983 IT Pros & Developers. It's quick & easy.

how can i use the initdb?

P: 15
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
Sep 6 '07 #1
Share this Question
Share on Google+
6 Replies


P: 15
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 ?
Sep 6 '07 #2

Expert 100+
P: 700
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/i...pp-initdb.html
Sep 6 '07 #3

P: 15
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
Sep 7 '07 #4

P: 15
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.
Sep 7 '07 #5

P: 15
expecting ....
expecting ....
expecting ....expecting ....
Sep 13 '07 #6

Expert 100+
P: 700
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?
Sep 13 '07 #7

Post your reply

Sign in to post your reply or Sign up for a free account.