Thread: Installing Postgres on Windows (2000 Pro).

Installing Postgres on Windows (2000 Pro).

From
Paul Linehan
Date:

Hi all,


I have just started messing around with Postgres
and I have downloaded PgSQL731wina1.exe (11MB)
from

ftp://ftp.ie.postgresql.org/mirr
ors/ftp.postgresql.org/pub/binary/v7.3.1/Windows/


7.3.2 wasn't available for windows.


What else do I need to download and/or run in
order to get postgres up and running under
Windows?


Paul...



___________________________________________________________
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com

Re: Installing Postgres on Windows (2000 Pro).

From
Paul Linehan
Date:

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.


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.

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.

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

Re: Installing Postgres on Windows (2000 Pro).

From
Justin Clift
Date:
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


Re: Installing Postgres on Windows (2000 Pro).

From
Paul Linehan
Date:

Justin Clift <justin@postgresql.org> a écrit:


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


Nope.


> If it's not starting automatically, that's
> generally caused by the presence of a "C:\Pro
> gram 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.


Tried searching for postgresql.pid - not 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.  :(


A pity. Postgresql should look at Interbase/Firebird
for the way to do this stuff. Run the exe and it
installs itself as a service no problem...


I have a project that I'm doing that requires
Windows for the server (hey, it's not *_my_*
fault) so I was going to try to use Postgresql,
but I think that I'll just have to stick with
Interbase.


From what I can see on the site, Postgresql will
be native for Windows from 7.4 about 6 months from
now. It looks like I'll have to wait until then.


Paul...


> Justin Clift




___________________________________________________________
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com