Обсуждение: Install Postgresql on Win2000 with Admin Rights

Hello,

is there a Way to install PostgreSQL ( 8.3.1 ) on a Win2000 Maschine
without Admin Rights?

Thanks for your Help,
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

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

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

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( 0xcc0000022 )
>
> 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
>

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

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( 0xcc0000022 )
>> 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
>

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

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

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

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

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