Thread: initdb hangs even though ipc-daemon is running?
Hi Guys, I'm having trouble installing & running PostgreSQL for the first time on my Win2K system. I'm running ipc-daemon as a service (following a reboot after ipc-daemon --install-as-service) but initdb is still hanging at the point shown below. I'm guessing there may be a problem with logins/access rights here? Administrator@GILBERTT ~ $ initdb -D test The files belonging to this database system will be owned by user "Administrator". This user must also own the server process. creating directory test... ok creating directory test/base... ok creating directory test/global... ok creating directory test/pg_xlog... ok creating directory test/pg_clog... ok creating template1 database in test/base/1... I am logged in to a company domain VMSW1 as user GilbertT (well, I type gilbertt when logging on to Win2K but user manager shows it as GilbertT) who belongs to Administrators group on the local machine. I installed everything via this login. Could this be the problem, since initdb reports that the files will belong to Administrator and requires that the same user must own the server process? thanks for any help - amazing how many hours (days) this sort of thing can eat up...! cheers, Tom Gilbert
Are you _sure_ ipc-daemon is running? I've never had success with it running as a daemon. Jon On Thu, 27 Feb 2003, Tom Gilbert wrote: > Hi Guys, > > I'm having trouble installing & running PostgreSQL for the first time on my > Win2K system. I'm running ipc-daemon as a service (following a reboot after > ipc-daemon --install-as-service) but initdb is still hanging at the point > shown below. > > I'm guessing there may be a problem with logins/access rights here? > > > Administrator@GILBERTT ~ > $ initdb -D test > The files belonging to this database system will be owned by user > "Administrator". > This user must also own the server process. > > creating directory test... ok > creating directory test/base... ok > creating directory test/global... ok > creating directory test/pg_xlog... ok > creating directory test/pg_clog... ok > creating template1 database in test/base/1... > > > I am logged in to a company domain VMSW1 as user GilbertT (well, I type > gilbertt when logging on to Win2K but user manager shows it as GilbertT) who > belongs to Administrators group on the local machine. I installed everything > via this login. Could this be the problem, since initdb reports that the > files will belong to Administrator and requires that the same user must own > the server process? > > thanks for any help - amazing how many hours (days) this sort of thing can > eat up...! > > cheers, > > Tom Gilbert > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >
Hi all Does anybody have experience with Cache from www.intersystems.com and can say something about the differences with PostgreSQL or how it compares to PostgreSQL? Thanks Conni
I have just managed to get a working version of PostfreSQL by using the PeerDirect PostgreSQL beta version. see lower half of the page at: http://techdocs.postgresql.org/guides/InstallingOnWindows This version seems to better understand NT user management, as initdb reports: W:\>initdb The files belonging to this database system will be owned by user "GilbertT". This user must also own the server process. Not that I am running ipc-daemon as a service using --install-as-service option on Win2K SP3. The other version of initdb got the user wrong, thinking I was logged in as user Administrator, which is most certianly not the case. decent start to my day, anyway, cheers, Tom Gilbert -----Original Message----- From: Tom Gilbert [mailto:Tom.Gilbert@vmusicstores.com] Sent: 27 February 2003 17:25 To: 'pgsql-general@postgresql.org' Subject: [GENERAL] initdb hangs even though ipc-daemon is running? Hi Guys, I'm having trouble installing & running PostgreSQL for the first time on my Win2K system. I'm running ipc-daemon as a service (following a reboot after ipc-daemon --install-as-service) but initdb is still hanging at the point shown below. I'm guessing there may be a problem with logins/access rights here? Administrator@GILBERTT ~ $ initdb -D test The files belonging to this database system will be owned by user "Administrator". This user must also own the server process. creating directory test... ok creating directory test/base... ok creating directory test/global... ok creating directory test/pg_xlog... ok creating directory test/pg_clog... ok creating template1 database in test/base/1... I am logged in to a company domain VMSW1 as user GilbertT (well, I type gilbertt when logging on to Win2K but user manager shows it as GilbertT) who belongs to Administrators group on the local machine. I installed everything via this login. Could this be the problem, since initdb reports that the files will belong to Administrator and requires that the same user must own the server process? thanks for any help - amazing how many hours (days) this sort of thing can eat up...! cheers, Tom Gilbert ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)