Обсуждение: initdb hangs
Hi!
From the posts in the forum this seems to be the most common problem. From cygwin I installed postgres, cygrunsrv and bzip2 packages. I also downloaded and untared cygipc. I followed jason's instructions, and I get stuck on the initdb step.
I am running W2K professional. When I log in as postgres initdb hangs. From the postgres user account, I cannot start ipc-daemon, I get Error 5 Access Denied. So from the login of user with administrative rights using the runas command i open the cygwin shell logged in as postgres. initdb still hangs with ipc-daemon running as well as without ipc-daemon running. I even tried running ipc-daemon as a non NT-service (i.e. $ ipc-daemon &) but to no avail.
What could be the reason for this peculiar problem. Please help as this is stalling the testing of our software which is well-past the deadline.
Thank you,
Richie
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
Since ipc-daemon is already running and initdb still hangs, could anyone familiar with the internals of initdb tell me what could be the possible reasons. Could it be memory leak, insufficient memory, config tweaking? i am no unix guru and this whole experience of installing postgres under W2K Pro for the past whole week with the same errors has been frustrating. The lack of error messages does not help either. The only clue I have is that Windows Task Manager shows the CPU usage as 100%.
My system has service pack 3 installed, AMD Athlon XP 1700+ processor with 1 GB RAM.
Thanks
Richie
Richard Pais <chris_pais@yahoo.com> wrote:
Hi!
From the posts in the forum this seems to be the most common problem. From cygwin I installed postgres, cygrunsrv and bzip2 packages. I also downloaded and untared cygipc. I followed jason's instructions, and I get stuck on the initdb step.
I am running W2K professional. When I log in as postgres initdb hangs. From the postgres user account, I cannot start ipc-daemon, I get Error 5 Access Denied. So from the login of user with administrative rights using the runas command i open the cygwin shell logged in as postgres. initdb still hangs with ipc-daemon running as well as without ipc-daemon running. I even tried running ipc-daemon as a non NT-service (i.e. $ ipc-daemon &) but to no avail.
What could be the reason for this peculiar problem. Please help as this is stalling the testing of our software which is well-past the deadline.
Thank you,
Richie
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
-----Original Message-----
From: pgsql-cygwin-owner@postgresql.org [mailto:pgsql-cygwin-owner@postgresql.org] On Behalf Of Richard Pais
Sent: Thursday, November 14, 2002 1:26 PM
To: pgsql-cygwin@postgresql.org
Subject: Re: [CYGWIN] initdb hangsSince ipc-daemon is already running and initdb still hangs, could anyone familiar with the internals of initdb tell me what could be the possible reasons. Could it be memory leak, insufficient memory, config tweaking? i am no unix guru and this whole experience of installing postgres under W2K Pro for the past whole week with the same errors has been frustrating. The lack of error messages does not help either. The only clue I have is that Windows Task Manager shows the CPU usage as 100%.
My system has service pack 3 installed, AMD Athlon XP 1700+ processor with 1 GB RAM.
Thanks
RichieRichard Pais <chris_pais@yahoo.com> wrote:
Hi!
From the posts in the forum this seems to be the most common problem. From cygwin I installed postgres, cygrunsrv and bzip2 packages. I also downloaded and untared cygipc. I followed jason's instructions, and I get stuck on the initdb step.
I am running W2K professional. When I log in as postgres initdb hangs. From the postgres user account, I cannot start ipc-daemon, I get Error 5 Access Denied. So from the login of user with administrative rights using the runas command i open the cygwin shell logged in as postgres. initdb still hangs with ipc-daemon running as well as without ipc-daemon running. I even tried running ipc-daemon as a non NT-service (i.e. $ ipc-daemon &) but to no avail.
What could be the reason for this peculiar problem. Please help as this is stalling the testing of our software which is well-past the deadline.
Thank you,
Richie
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
Andy Lowe <andyl@dmetrix.com> wrote:
-----Original Message-----
From: pgsql-cygwin-owner@postgresql.org [mailto:pgsql-cygwin-owner@postgresql.org] On Behalf Of Richard Pais
Sent: Thursday, November 14, 2002 1:26 PM
To: pgsql-cygwin@postgresql.org
Subject: Re: [CYGWIN] initdb hangsSince ipc-daemon is already running and initdb still hangs, could anyone familiar with the internals of initdb tell me what could be the possible reasons. Could it be memory leak, insufficient memory, config tweaking? i am no unix guru and this whole experience of installing postgres under W2K Pro for the past whole week with the same errors has been frustrating. The lack of error messages does not help either. The only clue I have is that Windows Task Manager shows the CPU usage as 100%.
My system has service pack 3 installed, AMD Athlon XP 1700+ processor with 1 GB RAM.
Thanks
RichieRichard Pais <chris_pais@yahoo.com> wrote:
Hi!
From the posts in the forum this seems to be the most common problem. From cygwin I installed postgres, cygrunsrv and bzip2 packages. I also downloaded and untared cygipc. I followed jason's instructions, and I get stuck on the initdb step.
I am running W2K professional. When I log in as postgres initdb hangs. From the postgres user account, I cannot start ipc-daemon, I get Error 5 Access Denied. So from the login of user with administrative rights using the runas command i open the cygwin shell logged in as postgres. initdb still hangs with ipc-daemon running as well as without ipc-daemon running. I even tried running ipc-daemon as a non NT-service (i.e. $ ipc-daemon &) but to no avail.
What could be the reason for this peculiar problem. Please help as this is stalling the testing of our software which is well-past the deadline.
Thank you,
Richie
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
Richard, On Thu, Nov 14, 2002 at 04:50:52PM -0800, Richard Pais wrote: > Thanks Andy. Installing cygipc 1.09 fixed the problem, though I > wonder if I am missing out on anything critical from 1.11. Downgrading is not generally a good long term solution. I would reinstall the lastest cygipc, remove /tmp/cygipc* and /tmp/MultiFile*, and then try again. I run Cygwin PostgreSQL under Windows 2000 without any problems. BTW, if Task Manager indicate 100% CPU usage, then most likely ipc-daemon is not really running. Jason -- PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6
Jason,
I really had no choice but to downgrade. I had even deleted everything from the /tmp directory. Like my previous email said, I tried it with and without ipc-daemon running and it still hung. I guess it's peculiar to my machine, because the same steps that i used on my machine worked on another machine without any problems. I'll try 1.13 and see if that helps.
Thanks,
Richard
Jason Tishler <jason@tishler.net> wrote:
Richard,
On Thu, Nov 14, 2002 at 04:50:52PM -0800, Richard Pais wrote:
> Thanks Andy. Installing cygipc 1.09 fixed the problem, though I
> wonder if I am missing out on anything critical from 1.11.
Downgrading is not generally a good long term solution. I would
reinstall the lastest cygipc, remove /tmp/cygipc* and /tmp/MultiFile*,
and then try again. I run Cygwin PostgreSQL under Windows 2000 without
any problems.
BTW, if Task Manager indicate 100% CPU usage, then most likely
ipc-daemon is not really running.
Jason
--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
Richard, On Fri, Nov 15, 2002 at 01:31:29PM -0800, Richard Pais wrote: > I really had no choice but to downgrade. I had even deleted > everything from the /tmp directory. Like my previous email said, I > tried it with and without ipc-daemon running and it still hung. I > guess it's peculiar to my machine, because the same steps that i used > on my machine worked on another machine without any problems. I'll > try 1.13 and see if that helps. What is the version of Cygwin on the problematic machine? There was a version of Cygwin (IIRC, 1.3.13) that caused ipc-daemon problems. If you are not using the latest Cygwin 1.3.15-2, please upgrade Cygwin too. BTW, you are not using the latest Cygwin PostgreSQL, 7.2.3-2, if initdb and/or postmaster hangs. Please upgrade PostgreSQL to the latest version too. Jason -- PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6