Re: [Postgres] initdb - does it ever finish?!?

Re: [Postgres] initdb - does it ever finish?!?

[Jason Tishler]

On Fri, Sep 06, 2002 at 07:06:27PM +0200, news@garydjones.mailshell.com wrote:
> I am currently futzing around with postgres, and initdb appears 
> to be hanging at "creating template1 database in 
> /cygdrive/k/pgsql/data/base/1... " Is that normal? Ctrl-C 
> elicits no response.

Did you install cygipc?  Did you start ipc-daemon?  Did you read the
README?

    http://www.tishler.net/jason/software/postgresql/postgresql-7.2.2.README

Jason

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: [Postgres] initdb - does it ever finish?!?

[news]

On 06 Sep 2002, Jason Tishler <jason@tishler.net> wrote:

> On Fri, Sep 06, 2002 at 07:06:27PM +0200,
> news@garydjones.mailshell.com wrote: 
>> initdb
>> appears to be hanging at "creating template1 database in 
>> /cygdrive/k/pgsql/data/base/1... "
> Did you install cygipc?  Did you start ipc-daemon?  Did you
> read the README?

Not yet, I was too busy reading the html docs.

>     http://www.tishler.net/jason/software/postgresql/postgres
>     ql-7.2.2.README 

I was going to say "That doesn't seem to be included in the 
package, nor a pointer to it." but that's untrue because the 
content of the README is there, just in a different file 
(FAQ_MSWIN). I'm so used to not reading the docs relating to 
Windows when installing Cygwin packages that it didn't register. 
Thanks for the advice, it works fine now (as far as I have taken 
it). A bit slow, but that's my underpowered machine for you. By 
the way, including the buyild options in the doc is an excellent 
touch; thanks!

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Postgres - more questions (was: Re: [Postgres] initdb - does it ever finish?!?)

[news]

On 06 Sep 2002, news@garydjones.mailshell.com wrote:

> Thanks for the advice, it works fine now (as far
> as I have taken it).

From pg_ctl I get output like this:
$ pg_ctl stop  
pg_ctl: no database directory or environment variable $PGDATA is 
specified
Try 'pg_ctl --help' for more information.

and yet:
$ echo $PGDATA   
/cygdrive/k/pgsql/data

Huh?!?

More worryingly:
$ pg_ctl stop -D /cygdrive/k/pgsql/data
waiting for postmaster to shut 
down............................................................
.... failed
pg_ctl: postmaster does not shut down

I had to use 
kill -9 `head -1 /usr/local/pgsql/data/postmaster.pid`
in the end (/usr/local/pgsql being a symlink to my data area).

I see a similar report to the latter problem in the archives 
(http://sources.redhat.com/ml/cygwin/2001-05/msg00499.html) but 
http://sources.redhat.com/ml/cygwin/2001-05/msg00774.html 
suggests it was fixed (over a year ago). BTW, I wish I'd read 
those threads about six months ago, some of the information 
solved something I had to work out for myself at that time.

I forgot to ask before, btw - is there a recommended method of 
running it on W9x? The docs generally recommend starting it as 
user "postgres". Is it best to just add an entry to /etc/passwd 
(AIUI "mkpasswd" is not supported on W9x)? I am thinking of 
something like "postgres::42:99:::".

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: Postgres - more questions (was: Re: [Postgres] initdb - does it ever finish?!?)

[Jason Tishler]

On Sat, Sep 07, 2002 at 11:21:49AM +0200, news@garydjones.mailshell.com wrote:
> On 06 Sep 2002, news@garydjones.mailshell.com wrote:
> > Thanks for the advice, it works fine now (as far as I have taken
> > it).
> 
> From pg_ctl I get output like this:
> $ pg_ctl stop  
> pg_ctl: no database directory or environment variable $PGDATA is 
> specified
> Try 'pg_ctl --help' for more information.
> 
> and yet:
> $ echo $PGDATA   
> /cygdrive/k/pgsql/data
> 
> Huh?!?

Did you export PGDATA?

> More worryingly:
> $ pg_ctl stop -D /cygdrive/k/pgsql/data
> waiting for postmaster to shut 
> down............................................................
> .... failed
> pg_ctl: postmaster does not shut down

Works for me:

    $ pg_ctl stop -D /usr/share/postgresql/data
    waiting for postmaster to shut down......done
    postmaster successfully shut down

> I had to use 
> kill -9 `head -1 /usr/local/pgsql/data/postmaster.pid`
> in the end (/usr/local/pgsql being a symlink to my data area).

Never "kill -9" the postmaster -- use "kill 15" instead.

> I see a similar report to the latter problem in the archives 
> (http://sources.redhat.com/ml/cygwin/2001-05/msg00499.html) but 

The above is unrelated...

> http://sources.redhat.com/ml/cygwin/2001-05/msg00774.html 
> suggests it was fixed (over a year ago).

and has been fixed.

> I forgot to ask before, btw - is there a recommended method of 
> running it on W9x? The docs generally recommend starting it as 
> user "postgres". Is it best to just add an entry to /etc/passwd 
> (AIUI "mkpasswd" is not supported on W9x)? I am thinking of 
> something like "postgres::42:99:::".

Sorry, I don't do the 9x/Me thing.  I suggest trying
pgsql-cygwin@postgresql.org -- someone there may be able to help.

Jason

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: Postgres - more questions

[news]

On 07 Sep 2002, Jason Tishler <jason@tishler.net> wrote:

> On Sat, Sep 07, 2002 at 11:21:49AM +0200,
> news@garydjones.mailshell.com wrote: 

>> $ pg_ctl stop  
>> pg_ctl: no database directory or environment variable
>> $PGDATA is specified
[..]
> Did you export PGDATA?

Agh! Sh8! I thought I had, but just checked and the "export" is 
missing, which I guess is kind of important. Sorry.

>> $ pg_ctl stop -D /cygdrive/k/pgsql/data
>> waiting for postmaster to shut 
>> down........................................................
>> .... .... failed pg_ctl: postmaster does not shut down
> 
> Works for me

And me, now. Because I wanted to know what was going on I 
removed the export of PGDATA, restarted bash, and tried again. 
No probelm, it still shut down fine. I really don't know what 
was causing this but for now it has "gone away". I haven't 
changed anything else in the meantime, afair, so I've really no 
idea what the difference is.

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: [Postgres] initdb - does it ever finish?!?

[Jason Tishler]

On Fri, Sep 06, 2002 at 09:14:29PM +0200, news@garydjones.mailshell.com wrote:
> On 06 Sep 2002, Jason Tishler <jason@tishler.net> wrote:
> > Did you install cygipc?  Did you start ipc-daemon?  Did you read the
> > README?
> 
> Not yet, I was too busy reading the html docs.
> 
> > http://www.tishler.net/jason/software/postgresql/postgresql-7.2.2.README
> 
> I was going to say "That doesn't seem to be included in the package,
> nor a pointer to it." but that's untrue because the content of the
> README is there, just in a different file (FAQ_MSWIN).

My Cygwin PostgreSQL package includes both the official PostgreSQL
FAQ/README (i.e., FAQ_MSWIN) and a README required by all Cygwin
packages (i.e., /usr/doc/Cygwin/postgresql-7.2.2.README).

Jason

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/