Unix Technical Forum

Install Postgresql on Win2000 with Admin Rights

This is a discussion on Install Postgresql on Win2000 with Admin Rights within the Pgsql General forums, part of the PostgreSQL category; --> Hello, I know that :-)It was just a try... Greetings, Stefan Sturm Am 25.03.2008 um 11:28 schrieb Craig Ringer: ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > Pgsql General

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #11 (permalink)  
Old 04-10-2008, 12:23 AM
Stefan Sturm
 
Posts: n/a
Default Re: 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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #12 (permalink)  
Old 04-10-2008, 12:23 AM
Magnus Hagander
 
Posts: n/a
Default Re: 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( 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

>



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #13 (permalink)  
Old 04-10-2008, 12:23 AM
Stefan Sturm
 
Posts: n/a
Default Re: 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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #14 (permalink)  
Old 04-10-2008, 12:23 AM
Magnus Hagander
 
Posts: n/a
Default Re: 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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 08:44 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com