Re: psql: FATAL: role "postgres" does not exist

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:user(at)domain(dot)microsoft(dot)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(dot)marlowe(at)gmail(dot)com
> To: mgainty(at)hotmail(dot)com
> CC: pgsql-general(at)postgresql(dot)org
>
> On Sat, Sep 26, 2009 at 8:10 PM, Martin Gainty <mgainty(at)hotmail(dot)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