Thread: PostgreSQL Easy NT attempt

PostgreSQL Easy NT attempt

From
Joerg Hessdoerfer
Date:
Hi, all!

For those of us who need to do such weird things as run PostgreSQL on
Windows, I tried to create a 'easy to use' one ZIP file installation.

This install is biased towards a 'I just need a DBMS' on NT approach.

You can find the Readme and archive on ftp://129.247.113.222

Greetings,
    Joerg Hessdoerfer


+------****  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 Easy NT attempt

From
Fredrick Bartlett
Date:
NT4 sp4
Unzipped to c:\
Got the following error for install.bat...

bash.exe: warning: could not find /tmp, please create!
Please specify your database directory
(the directory where your databases should be)
in the form x/folder1/.../lastfolder
where "x" is your drive letter, and "/folder1/.../lastfolder" are
slash "/" separated directories.
Example: if your DB should be in "G:\PostgreSQL\data" you would
specify "g/PostgreSQL/data"
DB path>

Joerg Hessdoerfer wrote:

> Hi, all!
>
> For those of us who need to do such weird things as run PostgreSQL on
> Windows, I tried to create a 'easy to use' one ZIP file installation.
>
> This install is biased towards a 'I just need a DBMS' on NT approach.
>
> You can find the Readme and archive on ftp://129.247.113.222
>
> Greetings,
>         Joerg Hessdoerfer
>
> +------****  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 Easy NT attempt

From
Fredrick Bartlett
Date:
Ok, continued story...

I created a c:\tmp dir and reran install.bat.  Ok now it created
setpath.bat.

When I ran initdb.bat I got the following error...

This database system will be initialized with username "bartletr".
This user will own all the data files and must also own the server
process.

Creating database system directory /cygdrive/exit
mkdir: cannot make directory `/cygdrive/exit': No such file or directory

initdb failed.
Removing /cygdrive/exit.
Removing temp file /tmp/initdb.1022.
Press any key to continue . . .

Joerg Hessdoerfer wrote:

> Hi, all!
>
> For those of us who need to do such weird things as run PostgreSQL on
> Windows, I tried to create a 'easy to use' one ZIP file installation.
>
> This install is biased towards a 'I just need a DBMS' on NT approach.
>
> You can find the Readme and archive on ftp://129.247.113.222
>
> Greetings,
>         Joerg Hessdoerfer
>
> +------****  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 Easy NT attempt

From
Joerg Hessdoerfer
Date:
Hi!

At 08:46 15.08.00 -0700, you wrote:
>NT4 sp4
>Unzipped to c:\
>Got the following error for install.bat...
>
>bash.exe: warning: could not find /tmp, please create!

OOoops - I forgot to mkdir/export /tmp - will be fixed shortly.

>Please specify your database directory
>(the directory where your databases should be)
>in the form x/folder1/.../lastfolder
>where "x" is your drive letter, and "/folder1/.../lastfolder" are
>slash "/" separated directories.
>Example: if your DB should be in "G:\PostgreSQL\data" you would
>specify "g/PostgreSQL/data"
>DB path>

At 08:58 15.08.00 -0700, you wrote:
>Creating database system directory /cygdrive/exit
>mkdir: cannot make directory `/cygdrive/exit': No such file or directory

What did you specify to above question? (The 'DB path>' prompt?) "exit"?
You should give it some meaningful path, e.g. "c/database", where "c" is
the drive letter.

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 Easy NT attempt

From
Fredrick Bartlett
Date:

Joerg Hessdoerfer wrote:

> Hi!
>
> At 08:46 15.08.00 -0700, you wrote:
> >NT4 sp4
> >Unzipped to c:\
> >Got the following error for install.bat...
> >
> >bash.exe: warning: could not find /tmp, please create!
>
> OOoops - I forgot to mkdir/export /tmp - will be fixed shortly.
>
> >Please specify your database directory
> >(the directory where your databases should be)
> >in the form x/folder1/.../lastfolder
> >where "x" is your drive letter, and "/folder1/.../lastfolder" are
> >slash "/" separated directories.
> >Example: if your DB should be in "G:\PostgreSQL\data" you would
> >specify "g/PostgreSQL/data"
> >DB path>
>
> At 08:58 15.08.00 -0700, you wrote:
> >Creating database system directory /cygdrive/exit
> >mkdir: cannot make directory `/cygdrive/exit': No such file or directory

I ran initdb.bat,  the above was the result.  I "did not" get a DB path>
prompt.

>
>
> What did you specify to above question? (The 'DB path>' prompt?) "exit"?
> You should give it some meaningful path, e.g. "c/database", where "c" is
> the drive letter.
>
> 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 Easy NT attempt

From
Fredrick Bartlett
Date:
This might be a stupid question but,  is it assumed that a user already has
cygwin installed?  Because I don't!!!

Fredrick

Joerg Hessdoerfer wrote:

> Hi!
>
> At 08:46 15.08.00 -0700, you wrote:
> >NT4 sp4
> >Unzipped to c:\
> >Got the following error for install.bat...
> >
> >bash.exe: warning: could not find /tmp, please create!
>
> OOoops - I forgot to mkdir/export /tmp - will be fixed shortly.
>
> >Please specify your database directory
> >(the directory where your databases should be)
> >in the form x/folder1/.../lastfolder
> >where "x" is your drive letter, and "/folder1/.../lastfolder" are
> >slash "/" separated directories.
> >Example: if your DB should be in "G:\PostgreSQL\data" you would
> >specify "g/PostgreSQL/data"
> >DB path>
>
> At 08:58 15.08.00 -0700, you wrote:
> >Creating database system directory /cygdrive/exit
> >mkdir: cannot make directory `/cygdrive/exit': No such file or directory
>
> What did you specify to above question? (The 'DB path>' prompt?) "exit"?
> You should give it some meaningful path, e.g. "c/database", where "c" is
> the drive letter.
>
> 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 Easy NT attempt

From
Joerg Hessdoerfer
Date:
At 08:08 16.08.00 -0700, you wrote:
>This might be a stupid question but,  is it assumed that a user already has
>cygwin installed?  Because I don't!!!
>
>Fredrick

No, of course not - this is what this is all about. This distro contains
all necessary
files from cygwin (and some more).

See my private e-mail, what went wrong with your setup.

Greetings,
         Joerg
+------****  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        |
+---------------------------------------------------------------+