Thread: initdb carrying on forever/problems with Postgresql setup on Cygwin

initdb carrying on forever/problems with Postgresql setup on Cygwin

From
"Vipul Vij"
Date:
Hi list,

I have managed to install Cygwin version and Cygipc version 1.14-1 on my
Win XP Pro Box. Now, when I initialize the db using the command: "initdb
-W -D /cygdrive/d/apps/cygwin/usr/local/pgsql/data" this process goes on
forever. Believe me, I have been trying to fix this all day, with not
very much success :-(( I have already looked at similar postings on this
mailing list - but that hasn't solved the problem.

I would appreciate any help/advice.

Regards,


Vipul K. Vij
+44 (0) 7866 554266 (m)





Re: initdb carrying on forever/problems with Postgresql setup on Cygwin

From
Jason Tishler
Date:
Vipul,

On Sat, Aug 30, 2003 at 06:32:34PM +0100, Vipul Vij wrote:
> I have managed to install Cygwin version and Cygipc version 1.14-1 on
> my Win XP Pro Box. Now, when I initialize the db using the command:
> "initdb -W -D /cygdrive/d/apps/cygwin/usr/local/pgsql/data" this
> process goes on forever. Believe me, I have been trying to fix this
> all day, with not very much success :-(( I have already looked at
> similar postings on this mailing list - but that hasn't solved the
> problem.

The above seems to indicate that you are using an older version of
PostgreSQL.  What version are you using?  What is the output of initdb
before the hang occurs.  Does CPU utilization hit 100%?  If so, what is
the offending process.

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 carrying on forever/problems with Postgresql setup on Cygwin

From
Jason Tishler
Date:
Vipul,

On Tue, Sep 02, 2003 at 03:35:00PM +0100, Vipul Vij wrote:
> Thanks for getting back to me.

You are welcome.

> > The above seems to indicate that you are using an older version of
> > PostgreSQL.  What version are you using?
>
> 7.2.4.

Bingo!  Please upgrade to the latest version:

Note that you need to install cygipc 2.01-2 too:

    http://cygwin.com/ml/cygwin-announce/2003-09/msg00036.html

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 carrying on forever/problems with Postgresql setup on Cygwin

From
"Vipul Vij"
Date:
Jason,

Thanks for getting back to me.

> The above seems to indicate that you are using an older version of
PostgreSQL.  What version are you using?

7.2.4. I am using the following instructions to setup PostgreSQL on
Cygwin: (http://www.ejip.net/faq/postgresql_win_setup_faq.jsp)
I have used other instructions. As I don't have a "D:\" and the same
folder structure on my machine as in these instructions, I am not
following the instructions entirely. After starting "ipc-daemon &", I
then invoke "initdb -D /usr/share/postgresql/data".
The messages that I get are:

'The files belonging to this database system will be owned by "Vipul
Vij".
The user must also own the server process.

Fixing permissions on existing directory /usr/share/postgresql/data ....
ok
Creating dir /usr/share/postgresql/data/base ... ok
"         "          "   "   "      "   global... ok
"         "          "   "   "      "   px_xlog ...ok
"         "          "   "   "      "   pg_clog ... ok
"         template1 database in /usr/share/postgresql/data/base/1.... '

This is the point at which it hangs.

> Does CPU utilization hit 100%?
Yes

> If so, what is
the offending process.
"postgres.exe"

I am using cygipic version 1.14.1. This was the only version I could
find. The link:
http://www.neuro.gatech.edu/users/cwilson/cygutils/V1.1/cygipc/ is never
available.

I look forward to hearing from you.


Vipul K. Vij
+44 (0) 7866 554266 (m)


-----Original Message-----
From: Jason Tishler [mailto:jason@tishler.net]
Sent: 02 September 2003 13:17
To: Vipul Vij
Cc: pgsql-cygwin@postgresql.org
Subject: Re: [CYGWIN] initdb carrying on forever/problems with
Postgresql setup on Cygwin

Vipul,

The above seems to indicate that you are using an older version of
PostgreSQL.  What version are you using?  What is the output of initdb
before the hang occurs.  Does CPU utilization hit 100%?  If so, what is
the offending process.

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