Postgres Pro
Downloads
Home   >   mailing lists

Thread: initdb hangs

initdb hangs

From
Richard Pais
Date:

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

Re: initdb hangs

From
Richard Pais
Date:

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

Re: initdb hangs

From
"Andy Lowe"
Date:
I ran into the same problem last night on an XP Pro box.  I was using version 1.11 of cygipc.  Going back to version 1.09 fixed the problem.  I haven't had a chance to try with 1.13 yet.
 
Anyone else seen this?
 
Andy
-----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 hangs

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

Re: initdb hangs

From
Richard Pais
Date:
Thanks Andy.  Installing cygipc 1.09 fixed the problem, though I wonder if I am missing out on anything critical from 1.11.

 

 Andy Lowe <andyl@dmetrix.com> wrote:

I ran into the same problem last night on an XP Pro box.  I was using version 1.11 of cygipc.  Going back to version 1.09 fixed the problem.  I haven't had a chance to try with 1.13 yet.
 
Anyone else seen this?
 
Andy
-----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 hangs

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


Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site

Re: initdb hangs

From
Jason Tishler
Date:
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

Re: initdb hangs

From
Richard Pais
Date:

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

Re: initdb hangs

From
Jason Tishler
Date:
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