Skip site navigation (1) Skip section navigation (2)

Re: Installation on Windows XP Home

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Daniel Schuchardt <daniel_schuchardt(at)web(dot)de>
Cc: cadic(dot)christophe(at)wanadoo(dot)fr, pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: Installation on Windows XP Home
Date: 2004-09-09 15:42:57
Message-ID: 200409091542.i89Fgvw17522@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers-win32
Or use pginstaller that does it all for you, I think.

---------------------------------------------------------------------------

Daniel Schuchardt wrote:
> Christophe CADIC schrieb:
> 
> > Hello,
> >
> > In the current win32 release, it is necessary to create a specific 
> > user account to install database.
> > On windows XP Home, it is not possible to create this type of account 
> > (Also Administrator or Limited User accounts are availables).
> >
> Hi Christophe,
> 
> that's not true.
> 
> here an example from my Setup (Created and tested on Windows XP-Home , 
> working on all Windows >=2000):
> 
> ExecWait 'net user postgres $AdminPassw /Add'
> WriteRegStr HKLM 'SYSTEM\CurrentControlSet\Control\Session 
> Manager\Environment\' 'PGDATA' '$INSTDIRPG/postgres/db'
> ExecWait '$INSTDIRPG\postgres\editrights -u postgres -a SeServiceLogonRight'
> ExecWait '$INSTDIRPG\postgres\runasp /domain:%COMPUTERNAME% 
> /user:postgres /password:$AdminPassw 
> /command:"$INSTDIRPG\postgres\bin\initdb -D $INSTDIRPG/postgres/db -L 
> $INSTDIRPG/postgres/share --locale=C" /wait'
> 
> user add is windows - standard.
> editrights is a cygwin exe. you only need to have this exe and 
> cygwin1.dll to run this exe
> runasp is a commercial tool like runas that is able to handle user 
> passwords in a script (it will not prompt for a password like runas); i 
> don't like it but thats the only tool i found :-(
> 
> see also
> 
> http://www.hagander.net/pgsql/win32snap/
> 
> for details
> 
> Daniel
> 
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-hackers-win32 by date

Next:From: Bruce MomjianDate: 2004-09-10 03:48:35
Subject: Re: VC++ psql build broken
Previous:From: Claudio NatoliDate: 2004-09-09 02:38:55
Subject: Re: Contrib modules on Win32

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group