i prefer cygwin as all the unix commands are available but mkuser and groupadd
arent up yet..ugh
i have a bunch of apps already running..webapp
servers..tomcat..glassfish..weblogic
and 2 other databases running and because I need god access (I cant run any of
these as postgres user)
here is the rundown on RUNAS
> runas /noprofile /user:mymachine\administrator cmd
> runas /profile /env /user:mydomain\admin "mmc %windir%\system32\dsa.msc"
> runas /env /user:u...@domain.microsoft.com "notepad \"my file.txt\""
whats *supposed to* happen is
RUNAS will run any command (the question is are we working with Windows Native
Binaries or cygwin?)
with regards to cygwin
i can build postmaster.exe postgres.exe initdb.exe, libpgport_srv.dll and all
the binaries using gcc and ld
not a big blocker.. I have a psql command prompt ..i can create roles users
databases and tables now
btw:those ipc libraries seemed to be wrapped around the axle of elog statements
but thats another topic
i commented out elog and replaced with printf..and all the ipc errors went away
thanks scott!
Martin Gainty
______________________________________________
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung
oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem
Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung.
Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung
fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le
destinataire prévu, nous te demandons avec bonté que pour satisfaire informez
l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est
interdite. Ce message sert à l'information seulement et n'aura pas n'importe
quel effet légalement obligatoire. Étant donné que les email peuvent facilement
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
> Date: Sat, 26 Sep 2009 20:12:15 -0600
> Subject: Re: [GENERAL] psql: FATAL: role "postgres" does not exist
> From: scott.marl...@gmail.com
> To: mgai...@hotmail.com
> CC: pgsql-general@postgresql.org
>
> On Sat, Sep 26, 2009 at 8:10 PM, Martin Gainty <mgai...@hotmail.com> wrote:
> > partial victory but
> > im baffled i started all commands with RUNAS /user:postgres
> > cd /postgres/pgctl/bin
> > RUNAS /user:postgres "initdb.exe -D /data"
> > RUNAS /user:postgres ""pg_ctl.exe" -D "/data" -l logfile start"
> > RUNAS /user:postgres "postgres.exe -D /data"
> >
> > but to get into postgres i have to
> > psql -u Admin
> >
> > now when i do
> > postgres-# \du
> > List of roles
> > Role name | Attributes | Member of
> > ---------------+-------------+-----------
> > Admin | Superuser | {}
> > : Create role
> > : Create DB
> >
> > yes i initially logged in as Admin
> > but I ran all the commands thru RUNAS /user:postgres
> >
> > currently unable to login as postgres as I have webservers,appservers
> > running under 'admin' space
> >
> > I'm confused as to the install under admin when i did the runas?
> > recommendations?
>
> You've exhausted my knowledge of running pg under windows I'm afraid.
> Must be how the windows installer works or something?
_________________________________________________________________
Hotmail® has ever-growing storage! Don’t worry about storage limits.
http://windowslive.com/Tutorial/Hotmail/Storage?ocid=TXT_TAGLM_WL_HM_Tutorial_Storage_062009
