473,799 Members | 3,147 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

how can i use the initdb?

15 New Member
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
6 5580
henryhcface
15 New Member
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
rski
700 Recognized Expert Contributor
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
henryhcface
15 New Member
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
henryhcface
15 New Member
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
henryhcface
15 New Member
expecting ....
expecting ....
expecting ....expecting ....
Sep 13 '07 #6
rski
700 Recognized Expert Contributor
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

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

Similar topics

6
3167
by: Martin Marques | last post by:
When running initdb on a fresh 7.4 install I get this error: postgres@bugs:~$ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data -E latin1 The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with locale es_AR. creating directory /usr/local/pgsql/data... ok
2
3201
by: Tim Farrell | last post by:
I use PostgreSQL as a default database in our solution and with the 7.2 version I was able to tar up the area pointed to by the --prefix build argument and untar to an arbitrary path as part of my product installation and I could initdb the database no problem and get a running database setup completely. With the 7.4 released version I get this failure while running initdb: ERROR: could not access file "$libdir/ascii_and_mic": No such...
1
1870
by: Seamus Thomas Carroll | last post by:
Hi, I have installed postgres in a non-standard location with this call to configure: ../configure --prefix=/scratch/postgresql-7.4/ --exec-prefix=/scratch/postgresql-7.4 --libdir=/scratch/postgresql-7.4/lib make make install I then put /scratch/postgresql/bin/ in my PATH and /scratch/postgresql/lib
9
8358
by: Jerome Lyles | last post by:
Hello List, I have installed Postgresql 7.4 on a Suse 9.0 system using apt. I cannot do this: /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data Because there is no "/pgsql/bin/initdb" nor /pgsql/bin/ on my system. Since apt did not create these directories how can I do it manually? Thanks,
1
2055
by: Medora Schauer | last post by:
I've installed 7.4.2 on a PowerPC system running linux 2.4.13. When I try to run initdb to create to create the database cluster I get the following: $ initdb -D $PGDATA The files belonging to this database system will be owned by user "thebox".
2
1938
by: tech tech | last post by:
Hello All, I installed postgresql 7.3.4 on HPUX PA in /usr/local/pgsql and put the libraries in /usr/local/pgsql/lib/LIB_new. During the initialization( initdb), it loads libraries (language) from /usr/local/pgsql/lib. In postgresql version 7.3.1, libraries are not loaded and no such problem during initdb. I had the following problem: $ initdb -D /var/pgsql The files belonging to this database system will be owned by user "postgres".
0
1196
by: Taras V. Panchenko | last post by:
Dear Sirs! Every time I tried to run initdb I get $ initdb The files belonging to this database system will be owned by user "Taras". This user must also own the server process. The database cluster will be initialized with locale C.
1
1900
by: Randy Yates | last post by:
Can't get the postgres server started under Win2000/cygwin. Here's what happens: $ initdb -D /Gauss/rr/data -W The files belonging to this database system will be owned by user "yates". This user must also own the server process. The database cluster will be initialized with locale C. fixing permissions on existing directory /Gauss/rr/data... ok
0
2044
by: Randall Smith | last post by:
I would like to be able to initdb to get a clean database to test backups. Reading the Debian version of the Postgresql README, I see that I should use the --debian-conffile option with initdb. Problem though. I have to run initdb as user postgres, but I need to be root to edit the stuff in /etc. So I can't run initdb as root or postgres. I lose either way. Also, since the configs are symlinked in etc, is there an elegant way to...
8
2158
by: BARTKO, Zoltán | last post by:
Hello, folks, I am trying to install pgsql8 on winxp. I tried first to install "as is" with pginstaller beta2-dev3, no luck, it froze, switched off Nod32, froze a little later, ran through the list of services, switched off anything that seemed to be a firewall, no luck. So I compiled beta3 with mingw, installed, and now initdb keeps telling me this:
0
10470
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10247
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10023
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9067
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6803
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5459
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4135
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3751
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2935
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.