Thread: postgreSQL NT4

postgreSQL NT4

From
Fredrick Bartlett
Date:
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


Re: postgreSQL NT4

From
Fredrick Bartlett
Date:
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
> >
> >


Re: postgreSQL NT4

From
Joerg Hessdoerfer
Date:
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        |
+---------------------------------------------------------------+


Re: postgreSQL NT4

From
Fredrick Bartlett
Date:
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        |
> +---------------------------------------------------------------+


Re: postgreSQL NT4

From
"Mohammed Abdel'al"
Date:
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
> > >
> > >
>
>


Re: postgreSQL NT4

From
Fredrick Bartlett
Date:
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
> > > >
> > > >
> >
> >