Thread: postgreSQL NT4
Finally got it running on NT4, need a little help with creating databases... Ok, I get the below error trying to run createDb. It creates the physical directory, but does not "Catalog" it. bash-2.04$ createdb -h localhost soCalMOADB ERROR: CREATE DATABASE: Could not initialize database directory. Delete failed as well createdb: database creation failed bash-2.04$ Thanks, Fredrick
It's running. I have been able to create tables run SQL etc. But still not been able to create databases using createDb in bash. Note: I also installed it on a win 2000, it's running as well. But I am haveing similar problems running any pgsql commands at all under bash. D:\postgreSQL\bin>bash bash-2.04$ createDb -h localhost socaldata bash: createDb: command not found bash-2.04$ Any ideas would be helpful. Mohammed Abdel'al wrote: > How u did? > I am dieing to get it running > ----- Original Message ----- > From: "Fredrick Bartlett" <palmtreefrb@earthlink.net> > To: <pgsql-ports@postgresql.org> > Sent: Wednesday, August 16, 2000 8:32 PM > Subject: [PORTS] postgreSQL NT4 > > > Finally got it running on NT4, need a little help with creating > > databases... > > > > Ok, I get the below error trying to run createDb. It creates the > > physical directory, but does not "Catalog" it. > > > > bash-2.04$ createdb -h localhost soCalMOADB > > ERROR: CREATE DATABASE: Could not initialize database directory. Delete > > failed > > as well > > createdb: database creation failed > > bash-2.04$ > > > > Thanks, > > Fredrick > > > >
Hi! At 19:51 16.08.00 -0700, you wrote: >It's running. I have been able to create tables run SQL etc. But still not >been able to create databases using createDb in bash. > >Note: I also installed it on a win 2000, it's running as well. But I am >haveing similar problems running any pgsql commands at all under bash. Thanks for the info... >D:\postgreSQL\bin>bash >bash-2.04$ createDb -h localhost socaldata >bash: createDb: command not found >bash-2.04$ It's 'createdb' not 'createDb'. >Any ideas would be helpful. > >Mohammed Abdel'al wrote: > > > How u did? > > I am dieing to get it running > > ----- Original Message ----- > > From: "Fredrick Bartlett" <palmtreefrb@earthlink.net> > > To: <pgsql-ports@postgresql.org> > > Sent: Wednesday, August 16, 2000 8:32 PM > > Subject: [PORTS] postgreSQL NT4 > > > > > Finally got it running on NT4, need a little help with creating > > > databases... > > > > > > Ok, I get the below error trying to run createDb. It creates the > > > physical directory, but does not "Catalog" it. > > > > > > bash-2.04$ createdb -h localhost soCalMOADB > > > ERROR: CREATE DATABASE: Could not initialize database directory. Delete > > > failed > > > as well > > > createdb: database creation failed > > > bash-2.04$ > > > Yepp. Seen this too. Dunno where THAT comes from. Needs looking into it. On top of that, the distro is missing a 'less' command (psql uses it...). Easy fix for that: get the 'less' package from http://sourceware.cygnus.com, and install the exe in you INSTALLPATH/bin directory. Will be included in the next release. Sorting out the above mentioned bug can take some days, as I'm off for a short trip :-( Perhaps anyone else can shed some light on the symptom above? Ever seen it before? Me not! Greetings, Joe +------**** Science & Engineering Applications GmbH ****------+ | | | Joerg Hessdoerfer | | Leading SW developer Phone: +49 (0)2203-962211 | | S.E.A GmbH Fax: -962212 | | D-51147 Koeln Internet: joerg.hessdoerfer@sea-gmbh.com | | http://www.sea-gmbh.com | +---------------------------------------------------------------+
Just an FYI, the following error occures from the psql shell as well. template1=# CREATE DATABASE SoCalMOADB; ERROR: CREATE DATABASE: Could not initialize database directory. Delete failed as well template1=# Joerg Hessdoerfer wrote: > Hi! > > At 19:51 16.08.00 -0700, you wrote: > >It's running. I have been able to create tables run SQL etc. But still not > >been able to create databases using createDb in bash. > > > >Note: I also installed it on a win 2000, it's running as well. But I am > >haveing similar problems running any pgsql commands at all under bash. > > Thanks for the info... > > >D:\postgreSQL\bin>bash > >bash-2.04$ createDb -h localhost socaldata > >bash: createDb: command not found > >bash-2.04$ > > It's 'createdb' not 'createDb'. > > >Any ideas would be helpful. > > > >Mohammed Abdel'al wrote: > > > > > How u did? > > > I am dieing to get it running > > > ----- Original Message ----- > > > From: "Fredrick Bartlett" <palmtreefrb@earthlink.net> > > > To: <pgsql-ports@postgresql.org> > > > Sent: Wednesday, August 16, 2000 8:32 PM > > > Subject: [PORTS] postgreSQL NT4 > > > > > > > Finally got it running on NT4, need a little help with creating > > > > databases... > > > > > > > > Ok, I get the below error trying to run createDb. It creates the > > > > physical directory, but does not "Catalog" it. > > > > > > > > bash-2.04$ createdb -h localhost soCalMOADB > > > > ERROR: CREATE DATABASE: Could not initialize database directory. Delete > > > > failed > > > > as well > > > > createdb: database creation failed > > > > bash-2.04$ > > > > > > Yepp. Seen this too. Dunno where THAT comes from. Needs looking into it. > On top of that, the distro is missing a 'less' command (psql uses it...). > Easy fix for that: get the 'less' package from http://sourceware.cygnus.com, > and install the exe in you INSTALLPATH/bin directory. Will be included in > the next release. > > Sorting out the above mentioned bug can take some days, as I'm off for a short > trip :-( > > Perhaps anyone else can shed some light on the symptom above? Ever seen it > before? > Me not! > > Greetings, Joe > +------**** Science & Engineering Applications GmbH ****------+ > | | > | Joerg Hessdoerfer | > | Leading SW developer Phone: +49 (0)2203-962211 | > | S.E.A GmbH Fax: -962212 | > | D-51147 Koeln Internet: joerg.hessdoerfer@sea-gmbh.com | > | http://www.sea-gmbh.com | > +---------------------------------------------------------------+
Could u please Tell me how u get it running and which version u use? ----- Original Message ----- From: "Fredrick Bartlett" <palmtreefrb@earthlink.net> To: "Mohammed Abdel'al" <mma@msm.com.eg> Cc: <pgsql-ports@postgresql.org> Sent: Thursday, August 17, 2000 5:51 AM Subject: Re: [PORTS] postgreSQL NT4 > It's running. I have been able to create tables run SQL etc. But still not > been able to create databases using createDb in bash. > > Note: I also installed it on a win 2000, it's running as well. But I am > haveing similar problems running any pgsql commands at all under bash. > > D:\postgreSQL\bin>bash > bash-2.04$ createDb -h localhost socaldata > bash: createDb: command not found > bash-2.04$ > > Any ideas would be helpful. > > Mohammed Abdel'al wrote: > > > How u did? > > I am dieing to get it running > > ----- Original Message ----- > > From: "Fredrick Bartlett" <palmtreefrb@earthlink.net> > > To: <pgsql-ports@postgresql.org> > > Sent: Wednesday, August 16, 2000 8:32 PM > > Subject: [PORTS] postgreSQL NT4 > > > > > Finally got it running on NT4, need a little help with creating > > > databases... > > > > > > Ok, I get the below error trying to run createDb. It creates the > > > physical directory, but does not "Catalog" it. > > > > > > bash-2.04$ createdb -h localhost soCalMOADB > > > ERROR: CREATE DATABASE: Could not initialize database directory. Delete > > > failed > > > as well > > > createdb: database creation failed > > > bash-2.04$ > > > > > > Thanks, > > > Fredrick > > > > > > > >
Hello, Mohammed! Go to this ftp site and download all zip files. There are good instructions included in the readme.txt ftp://129.247.113.222 Fredrick Mohammed Abdel'al wrote: > Could u please Tell me how u get it running and which version u use? > ----- Original Message ----- > From: "Fredrick Bartlett" <palmtreefrb@earthlink.net> > To: "Mohammed Abdel'al" <mma@msm.com.eg> > Cc: <pgsql-ports@postgresql.org> > Sent: Thursday, August 17, 2000 5:51 AM > Subject: Re: [PORTS] postgreSQL NT4 > > > It's running. I have been able to create tables run SQL etc. But still > not > > been able to create databases using createDb in bash. > > > > Note: I also installed it on a win 2000, it's running as well. But I am > > haveing similar problems running any pgsql commands at all under bash. > > > > D:\postgreSQL\bin>bash > > bash-2.04$ createDb -h localhost socaldata > > bash: createDb: command not found > > bash-2.04$ > > > > Any ideas would be helpful. > > > > Mohammed Abdel'al wrote: > > > > > How u did? > > > I am dieing to get it running > > > ----- Original Message ----- > > > From: "Fredrick Bartlett" <palmtreefrb@earthlink.net> > > > To: <pgsql-ports@postgresql.org> > > > Sent: Wednesday, August 16, 2000 8:32 PM > > > Subject: [PORTS] postgreSQL NT4 > > > > > > > Finally got it running on NT4, need a little help with creating > > > > databases... > > > > > > > > Ok, I get the below error trying to run createDb. It creates the > > > > physical directory, but does not "Catalog" it. > > > > > > > > bash-2.04$ createdb -h localhost soCalMOADB > > > > ERROR: CREATE DATABASE: Could not initialize database directory. > Delete > > > > failed > > > > as well > > > > createdb: database creation failed > > > > bash-2.04$ > > > > > > > > Thanks, > > > > Fredrick > > > > > > > > > > > >