Re: Problems - Mailing list pgsql-cygwin

Hi!

It won't work at all without the Cygwin-IPC-daemon. You can get it here:
http://www.neuro.gatech.edu/users/cwilson/cygutils/V1.1/cygipc/index.htm
l - just download the latest tarball without a 'src' in it's filename.
To unpack, do bunzip2 -c cygipc-1.10-1.tar.bz2 | tar xvf -
(this assumes you have the bzip2-packet installed). The /usr/-tree in
the tarball needs to go in the root of the cygwin-tree of course. To
install the daemon, start it with 'ipc-daemon --install-as-service'. It
seems however that you haven't yet read the documentation for
postgreSQL; you can find it in /usr/doc/Cygwin/postgresql-7.1.3.README .
There are instructions included on how to install PostgreSQL under
Cygwin. To start and stop the postmaster-service, you can use "net start
postmaster" or "net stop postmaster" respectively on the
Win2k-commandline or in batch-files. Access can be achieved via ODBC.
There's an excellent administration-frontend for Windows called PGAdmin
II which installs an ODBC-driver for Postgres on the system during it's
installation, too. You can find it here:
http://pgadmin.postgresql.org/downloads/ . I have established connection
to Postgres via ODBC using this PCAdminII, StarOffice 5.2 and
ColdFusion, each without any problems.

Greetings,

Markus

-----Ursprüngliche Nachricht-----
Von: Jessica Luchesi [mailto:jessica@apaixonadas.net]
Gesendet: Montag, 19. November 2001 12:56
An: Markus Wollny
Betreff: Re: AW: [CYGWIN] Problems


Well, mine is win2k pro...

I need it to work on Windows, for I have to design, test and develop
this
system on Windows for it's tools, even if it's going to run on Linux...

I didn't install the IPC deamon... could you send me a step-by-step on
what
to install and what to do? Is there any way postgres can be accessed,
started and stopped outside cygwin's shell? Like mySQL on Win2k?

Kisses,

Jessica

On Mon, 19 Nov 2001 14:26:25 +0100, "Markus Wollny"
<Markus.Wollny@computec.de> escreveu :

> Hello!
>
> I noticed the very same strange behaviour under Win2k Server, too.
Under
> Win2k Professional, everything installs fine as long as the Cygwin IPC
> daemon is running as service. Under Win2k Server however, an IPC
daemon
> running as service just doesn't do the trick - initdb just hangs on
> creating the database.
>
> I found a solution to the problem however (I just don't know if it's
> "neat" enough to find everyone's approval :) ):
>
> Install the cygwin ipc-daemon and the postmaster as services just as
> desribed in the readme. Then go to the services manager and stop the
ipc
> daemon if it's running. Go to the cygwin bash and run the daemon as
> ordinary process ($ ipc-daemon & [Enter]); then do the initdb as
> described, do a ps x|grep ipc and kill the ipc-daemon process, then go
> to the services manager and start the Cygwin ipc-daemon service.
Having
> ipc-daemon running as ordinary process during initdb did the trick for
> me - as I said before, I couldn't get initdb to complete with
ipc-demon
> running as service under win2k Server, just under Professional. I
still
> wonder why, so if anyone manages to bring some light into that
> situation, I'd happy to hear about it, too.
>
> Greetings,
>
>     Markus
>
> -----Ursprüngliche Nachricht-----
> Von: Jessica Luchesi [mailto:jessica@apaixonadas.net]
> Gesendet: Montag, 19. November 2001 11:42
> An: pgsql-cygwin@postgresql.org
> Betreff: [CYGWIN] Problems
>
>
> HI,
>
> I got PostgreSQL from Cygwin, but after Cygwin finished installing,
> initdb
> doesn't work... it simply starts, says it's creating the database, and

> exits without finishing.
>
> What am I doing wrong?
>
> Jessica Luchesi
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>
>