Re: Installing Postgres on Windows (2000 Pro).

Paul Linehan wrote:
>
> Paul Linehan <plinehan@yahoo.com> a écrit:
>
>>I have just started messing around with Postgres
>>and I have downloaded PgSQL731wina1.exe (11MB)
>
> I ran this programme and a whole lot of stuff
> was installed by the programme and now the
> service IPC-daemon runs automatically on startup.

Hi Paul,

There should be a service called "PostgreSQL Database" (or similar) that
auto-starts as well.

If it's not starting automatically, that's generally caused by the
presence of a "C:\Program Files\PostgreSQL\data\postgresql.pid" file at
startup.  That file should only be present while the server is running,
and stops PostgreSQL from starting up afresh if it's already there.

It's a bug with the present "Proof of Concept" for Windows PostgreSQL
build, as it's not being removed when PostgreSQL shuts down.  :(


> What do I have to do next to get Postgres to
> work on my system? I have looked around but
> cannot seem to find documentation on this
> type of install.

This installation package is really just an easier-to-install version of
the cygwin PostgreSQL version, and you may be better off looking at that
as it's better tested.  There are at least two known serious bugs with
the Proof of Concept build (caused by library files that are needed but
that are missing).


> Do I run cygrunsrv.exe? I have tried following
> paths and things, but just can't seem to figure
> it out.
>
> I downloaded the PGAdmin tool also, but I don't
> even think that the thing is even running just
> yet.

You'll need to enable TCP/IP communication too, and that's explained on
the PgAdmin site.  :)

Hope this helps.

Regards and best wishes,

Justin Clift


> Any help much appreciated.
>
>
> TIA.
>
>
> Paul...
>
>
>
>
>>Paul...
>
>
>
>
> ___________________________________________________________
> Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
> Yahoo! Mail : http://fr.mail.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org


--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi