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