Thread: PG windows service issues
Hi All, I'm new to this list. I've set up postgreSQL on windows about 4 times since the first 8.x series came out. The first time it was 8.0 beta3 IIRC. I believe I've installed another in the 8.0 series, then a 8.1 then just a couple of weeks ago 8.2.4. Every time I run into the same problem. I get the thing to work, find out I have to hack a couple of conf files to allow the port to work and then when I close my machine, trying to restart the service fails. (I know a server isn't meant to be shutdown like a desktop machine, but I'm trying out PG on my desktop ...) The only way I found to get rid of that problem is to reinitialize the password of the account that runs the service *every time I reboot my machine*. Then I can start the service. This is not only cumbersome, but it is outright dangerous. I wonder why this happens. I've installed a lot of software from the linux world as services (e.g.Zope) and I never encountered such problems. How can I get rid of those issues ? Sorry for the slightly whining tone of this email (I do like postgreSQL!), but I figured those types of issues had some time to settle since the 8.x series came out and they didn't. TIA, from a user who wants to bring folks to postgreSQL on windows, Yves Moisan
Yves Moisan wrote: > Hi All, > > I'm new to this list. > > I've set up postgreSQL on windows about 4 times since the first 8.x > series came out. The first time it was 8.0 beta3 IIRC. I believe > I've installed another in the 8.0 series, then a 8.1 then just a > couple of weeks ago 8.2.4. Every time I run into the same problem. I > get the thing to work, find out I have to hack a couple of conf files > to allow the port to work and then when I close my machine, trying to > restart the service fails. (I know a server isn't meant to be shutdown > like a desktop machine, but I'm trying out PG on my desktop ...) > > The only way I found to get rid of that problem is to reinitialize the > password of the account that runs the service *every time I reboot my > machine*. Then I can start the service. This is not only cumbersome, > but it is outright dangerous. I wonder why this happens. I've > installed a lot of software from the linux world as services > (e.g.Zope) and I never encountered such problems. How can I get rid > of those issues ? > > Sorry for the slightly whining tone of this email (I do like > postgreSQL!), but I figured those types of issues had some time to > settle since the 8.x series came out and they didn't. > > TIA, from a user who wants to bring folks to postgreSQL on windows, > > Yves Moisan > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq The only similar issues I have seen was where the user was created for the DB with the user must change password at next login option and this caused some issues? Also if I removed and reinstalled PostgreSQL in some of the older 8.0.X?? versions it complained as it tried to create the postgres user account when it already existed. I am installing PostgreSQL 8.0.x 8.1.x and 8.2.x on Windows 2000 Pro and Server, Windows XP and Windows 2003 Server without issue. Are you deinstalling and reinstalling on the same machine over and over? Does the postgres windows user still exist after the deinstall? Oisin
Hi Oisin, > The only similar issues I have seen was where the user was created for > the DB with the user must change password at next login option and this > caused some issues? I checked and I have the option "never change password checked". However, for the user I used for the previous 8.0 install(postgres, the one for 8.2 is postgres82) the user must change password at next login option was checked. > Also if I removed and reinstalled PostgreSQL in some > of the older 8.0.X?? versions it complained as it tried to create the > postgres user account when it already existed. Same here. So I went and created another user (postgres82). > I am installing PostgreSQL 8.0.x 8.1.x and 8.2.x on Windows 2000 Pro and > Server, Windows XP and Windows 2003 Server without issue. > Are you deinstalling and reinstalling on the same machine over and over? Yes. > Does the postgres windows user still exist after the deinstall? Yes That was the whole point of the original email : how come a previous install either does not uninstall all it has to or can'treuse stuff from the previous install (e.g. the user postgreSQL runs under) ? Also, I find the "usage of users" (databaseuser vs superuser) confusing, but that's most probably just me not understanding who does what. It seems to me the postgreSQL install on Windows does not provide "sensible defaults" : the port is disabled on the hostmachine ?? I can see the security concerns of not opening everything up, but it is awkward to have to Google some informationand find out one has to tweak conf files just to get it working. Or did I miss something obvious in the installdialogs ? One thing I should point out is that I'm Québec, so we use the "French Canada" settings. Could it be localisation issuesnot completely resolved in the installer ? Thanx for your help. Yves