Postgres Pro
Downloads
Home   >   mailing lists

Thread: Installation on Windows XP Home

Installation on Windows XP Home

From
Christophe CADIC
Date:

Hello,

I currently develop a software using postgreSQL..
It will run on Windows XP (Professional & Home).
Actually i use UltraSQL on Windows XP Home.
I am very interested by your win32 developement.
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).
I hope you could help me...

Thank you,

Christophe CADIC
Independant Developper

Re: Installation on Windows XP Home

From
Daniel Schuchardt
Date:
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

Re: Installation on Windows XP Home

From
Bruce Momjian
Date:
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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073