Re: initdb fails with invalid argument to shmat

Ok,

Are you starting cygserver and postgres in the same bash shell or in
separate bash shells(separate cygwin windows)?

No luck with XP and the source for me yet...

If you run the command, env, from a bash shell does CYGWIN=server appear
in the listing?

Mike
On Fri, 2004-07-02 at 02:32, Kevin Marth wrote:
> Actually, I tried both. I first installed Cygwin and postgresql and various other packages from the Cygwin mirror at ftp://mirror.mcs.anl.gov and encountered the "shmat" problem. I then tried building the source myself, but I wasn't any more successful. Note that the Cygwin install from the mirror site was to a pristine environment - there wasn't an existing Cygwin installation on my PC prior to my original post to this group on Sunday.
>
> -----Original Message-----
> From: mike g <mike(at)thegodshalls(dot)com>
> Sent: Jul 1, 2004 11:33 PM
> To: Kevin Marth <kem1(at)peoplepc(dot)com>
> Cc: pgsql-cygwin(at)postgresql(dot)org
> Subject: Re: [CYGWIN] initdb fails with invalid argument to shmat
>
> You are correct that services cannot be run under ME.
>
> Did you build from source or install it as cygwin package?
>
> I receive the same error when trying to run it under XP when building
> from source. Using the cygwin package it works fine. I have not yet
> had the time to continue to debug why I can't execute from the source
> code.
>
> On Thu, 2004-07-01 at 13:43, Kevin Marth wrote:
> > I am working with Windows ME. I could be mistaken, but it doesn't seem possible to run as a service under ME. When I try to invoke cygrunsrv, I get a message basically saying that "this service is unavailable". If I am mistaken, then I could use some further clarification about how to run as a service under ME. Thanks.
> >
> > -----Original Message-----
> > From: mike g <mike(at)thegodshalls(dot)com>
> > Sent: Jun 30, 2004 10:54 PM
> > To: Kevin Marth <kem1(at)peoplepc(dot)com>
> > Cc: pgsql-cygwin(at)postgresql(dot)org
> > Subject: Re: [CYGWIN] initdb fails with invalid argument to shmat
> >
> > What version of windows is this on and are you trying to run it as a
> > service?
> >
> >
> > On Sun, 2004-06-27 at 00:13, Kevin Marth wrote:
> > > I am using Cygwin 1.5.10-3 and postgresql 7.4.3-1 freshly downloaded and installed from scratch earlier today.
> > >
> > > I have set CYGWIN=server and started cygserver (from the default account).
> > >
> > > I receive the following when I execute "initdb -D /home/default/data --debug". Can someone set me straight? I don't see this particular problem in the archives. Thanks.
> > >
> > > ================
> > >
> > > Running in debug mode.
> > >
> > > initdb: internal variables:
> > > PGDATA=/home/default/data
> > > datadir=/usr/share/postgresql
> > > PGPATH=/usr/bin
> > > ENCODING=
> > > ENCODINGID=0
> > > POSTGRES_SUPERUSERNAME=default
> > > POSTGRES_BKI=/usr/share/postgresql/postgres.bki
> > > POSTGRES_DESCR=/usr/share/postgresql/postgres.description
> > > POSTGRESQL_CONF_SAMPLE=/usr/share/postgresql/postgresql.conf.sample
> > > PG_HBA_SAMPLE=/usr/share/postgresql/pg_hba.conf.sample
> > > PG_IDENT_SAMPLE=/usr/share/postgresql/pg_ident.conf.sample
> > > The files belonging to this database system will be owned by user "default".
> > > This user must also own the server process.
> > >
> > > The database cluster will be initialized with locale C.
> > >
> > > creating directory /home/default/data... ok
> > > creating directory /home/default/data/base... ok
> > > creating directory /home/default/data/global... ok
> > > creating directory /home/default/data/pg_xlog... ok
> > > creating directory /home/default/data/pg_clog... ok
> > > selecting default max_connections... 10
> > > selecting default shared_buffers... 50
> > > creating configuration files... ok
> > > creating template1 database in /home/default/data/base/1... DEBUG: invoking IpcMemoryCreate(size=1081344)
> > > FATAL: shmat(id=983040) failed: Invalid argument
> > > DEBUG: proc_exit(1)
> > > DEBUG: shmem_exit(1)
> > > DEBUG: exit(1)
> > >
> > >
> > > ________________________________________
> > > PeoplePC Online
> > > A better way to Internet
> > > http://www.peoplepc.com
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
> >
> >
> > ________________________________________
> > PeoplePC Online
> > A better way to Internet
> > http://www.peoplepc.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
>
> ________________________________________
> PeoplePC Online
> A better way to Internet
> http://www.peoplepc.com
>
> ---------------------------(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