* Re: [Postgres] initdb - does it ever finish?!?
[not found] <02Sep6.101215-0700_pdt.292221-5504+21@lmg.ahnet.net>
@ 2002-09-06 10:28 ` Jason Tishler
2002-09-07 2:20 ` news
` (2 more replies)
0 siblings, 3 replies; 6+ messages in thread
From: Jason Tishler @ 2002-09-06 10:28 UTC (permalink / raw)
To: cygwin
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/
^ permalink raw reply [flat|nested] 6+ messages in thread
* Re: [Postgres] initdb - does it ever finish?!?
2002-09-06 10:28 ` [Postgres] initdb - does it ever finish?!? Jason Tishler
@ 2002-09-07 2:20 ` news
[not found] ` <E17nZmd-00083T-00@quimby.gnus.org>
[not found] ` <02Sep6.233728-0700_pdt.297018-2018+106@lmg.ahnet.net>
2 siblings, 0 replies; 6+ messages in thread
From: news @ 2002-09-07 2:20 UTC (permalink / raw)
To: cygwin
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/
^ permalink raw reply [flat|nested] 6+ messages in thread
* Postgres - more questions (was: Re: [Postgres] initdb - does it ever finish?!?)
[not found] ` <E17nZmd-00083T-00@quimby.gnus.org>
@ 2002-09-07 3:45 ` news
[not found] ` <02Sep7.022547-0700_pdt.290634-25802+89@lmg.ahnet.net>
1 sibling, 0 replies; 6+ messages in thread
From: news @ 2002-09-07 3:45 UTC (permalink / raw)
To: cygwin
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/
^ permalink raw reply [flat|nested] 6+ messages in thread
* Re: [Postgres] initdb - does it ever finish?!?
[not found] ` <02Sep6.233728-0700_pdt.297018-2018+106@lmg.ahnet.net>
@ 2002-09-07 12:44 ` Jason Tishler
0 siblings, 0 replies; 6+ messages in thread
From: Jason Tishler @ 2002-09-07 12:44 UTC (permalink / raw)
To: cygwin
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/
^ permalink raw reply [flat|nested] 6+ messages in thread
* Re: Postgres - more questions (was: Re: [Postgres] initdb - does it ever finish?!?)
[not found] ` <02Sep7.022547-0700_pdt.290634-25802+89@lmg.ahnet.net>
@ 2002-09-07 12:57 ` Jason Tishler
2002-09-11 9:22 ` Postgres - more questions news
0 siblings, 1 reply; 6+ messages in thread
From: Jason Tishler @ 2002-09-07 12:57 UTC (permalink / raw)
To: cygwin
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/
^ permalink raw reply [flat|nested] 6+ messages in thread
* Re: Postgres - more questions
2002-09-07 12:57 ` Jason Tishler
@ 2002-09-11 9:22 ` news
0 siblings, 0 replies; 6+ messages in thread
From: news @ 2002-09-11 9:22 UTC (permalink / raw)
To: cygwin
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/
^ permalink raw reply [flat|nested] 6+ messages in thread
end of thread, other threads:[~2002-09-11 16:22 UTC | newest]
Thread overview: 6+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
[not found] <02Sep6.101215-0700_pdt.292221-5504+21@lmg.ahnet.net>
2002-09-06 10:28 ` [Postgres] initdb - does it ever finish?!? Jason Tishler
2002-09-07 2:20 ` news
[not found] ` <E17nZmd-00083T-00@quimby.gnus.org>
2002-09-07 3:45 ` Postgres - more questions (was: Re: [Postgres] initdb - does it ever finish?!?) news
[not found] ` <02Sep7.022547-0700_pdt.290634-25802+89@lmg.ahnet.net>
2002-09-07 12:57 ` Jason Tishler
2002-09-11 9:22 ` Postgres - more questions news
[not found] ` <02Sep6.233728-0700_pdt.297018-2018+106@lmg.ahnet.net>
2002-09-07 12:44 ` [Postgres] initdb - does it ever finish?!? Jason Tishler
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).