Thread: Installing Postgres on Windows (2000 Pro).
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
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
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
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