Re: [GENERAL] Install Postgresql on Win2000 with Admin Rights
On Wed, 2008-03-26 at 08:28 +0100, Stefan Sturm wrote: > Hello, > > I tried everything to get init_db working, but I failed :-( > So I tried another way. I tried Veriosn 8.2. With 8.2 I got another > DLL missing. So I tried 8.1. > And look, it works :-) No DLL problems. > > But now init_db tells me, that the PostgreSQL Server can't be started > with admin rights. > Is there a way to do it? Not in 8.1. 8.2 added support for starting as admin. For 8.1, you need to create a user that's not an admin user for the service to run under, and make sure you set the permissions properly for it to access the data directories. //Magnus -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Install Postgresql on Win2000 with Admin Rights
Hello, I tried everything to get init_db working, but I failed :-( So I tried another way. I tried Veriosn 8.2. With 8.2 I got another DLL missing. So I tried 8.1. And look, it works :-) No DLL problems. But now init_db tells me, that the PostgreSQL Server can't be started with admin rights. Is there a way to do it? Thanks, Stefan Sturm
Re: [GENERAL] Install Postgresql on Win2000 with Admin Rights
Stefan Sturm wrote: Hello Craig and Magnus, thanks for your Help. I downloaded MSVCR80.DLL, but still the same problems: When I simply start init_db from within the bin folder I get the Message, that he can't find libintl3.dll. The errormessage shows the PATH, and this path contains the bin Folder... Have you used Dependency Walker (depends.exe) to examine initdb and see what DLLs it's being linked to? You can get Dependency Walker from http://www.dependencywalker.com/ (it's free). Use the "show full paths" option in the view menu to see the full DLL locations. Have you tried explicitly setting your PATH environment variable to include the postgresql bin directory? By the way, on mailing list discussions it's generally considered polite to respond below the other person's email, chopping off the bits that are not relevant. You should also respond to individual parts of the email (like separate questions) where that makes more sense. -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Install Postgresql on Win2000 with Admin Rights
Hello Craig and Magnus, thanks for your Help. I downloaded MSVCR80.DLL, but still the same problems: When I simply start init_db from within the bin folder I get the Message, that he can't find libintl3.dll. The errormessage shows the PATH, and this path contains the bin Folder... When I copy libintl3.dll and libiconv2.dll to the system32 folder, I get the Error, that the applcattion could not get initilaized. Seams to be an odd problem. Thanks for your Help, Stefan Sturm Am 25.03.2008 um 12:17 schrieb Craig Ringer: Stefan Sturm wrote: Hello, If you can do that, you obviously have admin rights, so why not just use the MSI installer? When I try to run the Intaller, I get this Message: "The Systemadminitrator guidelines issued in order to prevent this installation". Have you upgraded the Windows Installer engine? Do you have domain or local group policy in place that might be blocking msi installations? Have you examined your event log for more information? Have you gone digging with filemon to see what's *really* going on? That said, this often happens if you have an incorrect version of the MSVC runtime on your system. See the README file in the download directory. I can't istall the runtime, because I can't run the MSI installer. The same problem :-( The MSVC runtime linked to by the README: http://www.microsoft.com/downloads/details.aspx?FamilyID=200b2fd9-ae1a-4a14-984d-389c36f85647&DisplayLang=en is supported for installation on win2k. It'll require admin access to install, though. Since that's no good for you, you might be able to bundle the required vc2008 runtime DLL(s) in the postgresql executable directory. I've done this for my own apps without problems, but it's possible that if Pg is specifically compiled to use WinSxS it might not work. Using Dependency Walker (depends.exe) I can see that my standard (MSI install) 8.3 binaries want MSVCR80.DLL . They're finding it in my WinSxS directory on my Vista box. It's not at all difficult to either pull MSVCR80.DLL from a machine that already has the file or download it off the 'net. If you put it in the pg bin directory it *should* work, though I don't know enough about the details of Windows DLL registration etc to be sure that's safe. In other words: Try dropping a copy of MSVCR80.DLL into the bin directory of the non-MSI postgresql zip file and see how you go. -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Install Postgresql on Win2000 with Admin Rights
Stefan Sturm wrote: Hello, If you can do that, you obviously have admin rights, so why not just use the MSI installer? When I try to run the Intaller, I get this Message: "The Systemadminitrator guidelines issued in order to prevent this installation". Oh. So it's not actually admin rights, it's a group policy restriction. That said, this often happens if you have an incorrect version of the MSVC runtime on your system. See the README file in the download directory. I can't istall the runtime, because I can't run the MSI installer. The same problem :-( So, I thnk, there is no chance to install prostgres here :-( Sure you can, it's just harder to do when your domain admins are trying to prevent you from doing it ;) You could try installing the MSI of the runtime on a different machine, then manually copy the files over to the one you need to run it on. It's not really convenient, but you *are* trying to do something your admins don't want you to do after all ;-) //Magnus -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Install Postgresql on Win2000 with Admin Rights
Stefan Sturm wrote: Hello, If you can do that, you obviously have admin rights, so why not just use the MSI installer? When I try to run the Intaller, I get this Message: "The Systemadminitrator guidelines issued in order to prevent this installation". Have you upgraded the Windows Installer engine? Do you have domain or local group policy in place that might be blocking msi installations? Have you examined your event log for more information? Have you gone digging with filemon to see what's *really* going on? That said, this often happens if you have an incorrect version of the MSVC runtime on your system. See the README file in the download directory. I can't istall the runtime, because I can't run the MSI installer. The same problem :-( The MSVC runtime linked to by the README: http://www.microsoft.com/downloads/details.aspx?FamilyID=200b2fd9-ae1a-4a14-984d-389c36f85647&DisplayLang=en is supported for installation on win2k. It'll require admin access to install, though. Since that's no good for you, you might be able to bundle the required vc2008 runtime DLL(s) in the postgresql executable directory. I've done this for my own apps without problems, but it's possible that if Pg is specifically compiled to use WinSxS it might not work. Using Dependency Walker (depends.exe) I can see that my standard (MSI install) 8.3 binaries want MSVCR80.DLL . They're finding it in my WinSxS directory on my Vista box. It's not at all difficult to either pull MSVCR80.DLL from a machine that already has the file or download it off the 'net. If you put it in the pg bin directory it *should* work, though I don't know enough about the details of Windows DLL registration etc to be sure that's safe. In other words: Try dropping a copy of MSVCR80.DLL into the bin directory of the non-MSI postgresql zip file and see how you go. -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Install Postgresql on Win2000 with Admin Rights
Hello, If you can do that, you obviously have admin rights, so why not just use the MSI installer? When I try to run the Intaller, I get this Message: "The Systemadminitrator guidelines issued in order to prevent this installation". That said, this often happens if you have an incorrect version of the MSVC runtime on your system. See the README file in the download directory. I can't istall the runtime, because I can't run the MSI installer. The same problem :-( So, I thnk, there is no chance to install prostgres here :-( Greetings, Stefan Sturm //Magnus Stefan Sturm wrote: Hello, i copied the dll files to the system32 directory. But now I get another error: The Programm could not be initialized( 0xcc022 ) Any Hints? Stefan Sturm Stefan Sturm wrote: Hello, is there a Way to install PostgreSQL ( 8.3.1 ) on a Win2000 Maschine without Admin Rights? Yes, but you cannot use the MSI installer, and you cannot install it as a service (for auto-start). You can download the binaries-no- installer and run the initdb and pg_ctl steps yourself (follow the Unix instructions for those parts) //Magnus -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Install Postgresql on Win2000 with Admin Rights
Hello, I know that :-)It was just a try... Greetings, Stefan Sturm Am 25.03.2008 um 11:28 schrieb Craig Ringer: Stefan Sturm wrote: Hello, i copied the dll files to the system32 directory. That's really NOT a good idea. Win2k and up look in the executable directory for required DLLs. You should never need to modify the system directories, and it's a really bad idea to do so. See: http://msdn2.microsoft.com/en-us/library/ms811694.aspx I'm not speaking from PostgreSQL specific experience here, so maybe there's some odd reason why it might be required for the pgsql server. In general, though, it's a terrible idea to go messing with the windows directory for program installs. -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Install Postgresql on Win2000 with Admin Rights
If you can do that, you obviously have admin rights, so why not just use the MSI installer? That said, this often happens if you have an incorrect version of the MSVC runtime on your system. See the README file in the download directory. //Magnus Stefan Sturm wrote: Hello, i copied the dll files to the system32 directory. But now I get another error: The Programm could not be initialized( 0xcc022 ) Any Hints? Stefan Sturm Stefan Sturm wrote: Hello, is there a Way to install PostgreSQL ( 8.3.1 ) on a Win2000 Maschine without Admin Rights? Yes, but you cannot use the MSI installer, and you cannot install it as a service (for auto-start). You can download the binaries-no-installer and run the initdb and pg_ctl steps yourself (follow the Unix instructions for those parts) //Magnus -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Install Postgresql on Win2000 with Admin Rights
Stefan Sturm wrote: > Hello, > > i copied the dll files to the system32 directory. That's really NOT a good idea. Win2k and up look in the executable directory for required DLLs. You should never need to modify the system directories, and it's a really bad idea to do so. See: http://msdn2.microsoft.com/en-us/library/ms811694.aspx I'm not speaking from PostgreSQL specific experience here, so maybe there's some odd reason why it might be required for the pgsql server. In general, though, it's a terrible idea to go messing with the windows directory for program installs. -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Install Postgresql on Win2000 with Admin Rights
Hello Stefan Sturm wrote: Hello, is there a Way to install PostgreSQL ( 8.3.1 ) on a Win2000 Maschine without Admin Rights? Yes, but you cannot use the MSI installer, and you cannot install it as a service (for auto-start). You can download the binaries-no- installer and run the initdb and pg_ctl steps yourself (follow the Unix instructions for those parts) //Magnus thanks for your answer. I downloaded the binaries and tried to run inidb. But then I get the message, that he could not find libintl3.dll. But it is in this directory... Any Hints? Thanks, Stefan Sturm -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Install Postgresql on Win2000 with Admin Rights
Hello, i copied the dll files to the system32 directory. But now I get another error: The Programm could not be initialized( 0xcc022 ) Any Hints? Stefan Sturm Stefan Sturm wrote: Hello, is there a Way to install PostgreSQL ( 8.3.1 ) on a Win2000 Maschine without Admin Rights? Yes, but you cannot use the MSI installer, and you cannot install it as a service (for auto-start). You can download the binaries-no- installer and run the initdb and pg_ctl steps yourself (follow the Unix instructions for those parts) //Magnus
Re: [GENERAL] Install Postgresql on Win2000 with Admin Rights
Stefan Sturm wrote: Hello, is there a Way to install PostgreSQL ( 8.3.1 ) on a Win2000 Maschine without Admin Rights? Yes, but you cannot use the MSI installer, and you cannot install it as a service (for auto-start). You can download the binaries-no-installer and run the initdb and pg_ctl steps yourself (follow the Unix instructions for those parts) //Magnus -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general