Thread: initdb hangs
Hi all, I've just installed the binary only cygwin today and I'm trying to get postgesql working. I've had a quick look at the readme and the archives and I think I've done everything I need to (set PGDATA=/usr/share/postgressql/data, made sure I've got entries in passwd and group etc.) When I run initdb (with the -D param and without), it hangs on the bottom line of the extract below. There is no disk activity and it doesn't matter how long I leave it. Anyone got any ideas? gary@ladvent ~ $ initdb The files belonging to the database system will be owned by user "gary". This user bust also own the server process. Fixing permissions on existing directory /usr/share/postgresql/data... ok creating directory /usr/share/postgresql/data/base... ok creating directory /usr/share/postgresql/data/global... ok creating directory /usr/share/postgresql/data/pg_xlog... ok creating directory /usr/share/postgresql/data/pg_clog... ok creating template1 database in /usr/share/postgresql/data/base/1... -- Gary Stainburn This email does not contain private or confidential material as it may be snooped on by interested government parties for unknown and undisclosed purposes - Regulation of Investigatory Powers Act, 2000
Hello Gary, Hanging in this spot on initdb usually means you do not have the ipc-daemon.exe process running (from cygipc). Make sure you have that running and you should be fine. Cheers, Mike -----Original Message----- From: Gary Stainburn To: pgsql-cygwin@postgresql.org Sent: 10/25/2002 8:54 AM Subject: [CYGWIN] initdb hangs Hi all, I've just installed the binary only cygwin today and I'm trying to get postgesql working. I've had a quick look at the readme and the archives and I think I've done everything I need to (set PGDATA=/usr/share/postgressql/data, made sure I've got entries in passwd and group etc.) When I run initdb (with the -D param and without), it hangs on the bottom line of the extract below. There is no disk activity and it doesn't matter how long I leave it. Anyone got any ideas? gary@ladvent ~ $ initdb The files belonging to the database system will be owned by user "gary". This user bust also own the server process. Fixing permissions on existing directory /usr/share/postgresql/data... ok creating directory /usr/share/postgresql/data/base... ok creating directory /usr/share/postgresql/data/global... ok creating directory /usr/share/postgresql/data/pg_xlog... ok creating directory /usr/share/postgresql/data/pg_clog... ok creating template1 database in /usr/share/postgresql/data/base/1... -- Gary Stainburn This email does not contain private or confidential material as it may be snooped on by interested government parties for unknown and undisclosed purposes - Regulation of Investigatory Powers Act, 2000 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
On Friday 25 Oct 2002 4:57 pm, Mike Schroepfer wrote: > Hello Gary, > > Hanging in this spot on initdb usually means you do not have > the ipc-daemon.exe process running (from cygipc). Make sure you have > that running and you should be fine. > > Cheers, > > Mike Hi Mike, I had seen the mention about the cygipc in the readme, but I don't seem to have it installed and when I looked it up I saw a comment about it being depreciated and being replaced by functionality in the cygwin DLL. I therefore didnt' bother with it. How do I go about installing it? I've had a couple of looks at installing it through setup.exe but I can't find it in any of the categories. (I've got cygutils installed which I thought contained it) Thanks, Gary > > > -----Original Message----- > From: Gary Stainburn > To: pgsql-cygwin@postgresql.org > Sent: 10/25/2002 8:54 AM > Subject: [CYGWIN] initdb hangs > > Hi all, > > I've just installed the binary only cygwin today and I'm trying to get > postgesql working. I've had a quick look at the readme and the archives > and > I think I've done everything I need to (set > PGDATA=/usr/share/postgressql/data, made sure I've got entries in passwd > and > group etc.) > > When I run initdb (with the -D param and without), it hangs on the > bottom > line of the extract below. There is no disk activity and it doesn't > matter > how long I leave it. > > Anyone got any ideas? > > > gary@ladvent ~ > $ initdb > The files belonging to the database system will be owned by user "gary". > This user bust also own the server process. > > Fixing permissions on existing directory /usr/share/postgresql/data... > ok > creating directory /usr/share/postgresql/data/base... ok > creating directory /usr/share/postgresql/data/global... ok > creating directory /usr/share/postgresql/data/pg_xlog... ok > creating directory /usr/share/postgresql/data/pg_clog... ok > creating template1 database in /usr/share/postgresql/data/base/1... -- Gary Stainburn This email does not contain private or confidential material as it may be snooped on by interested government parties for unknown and undisclosed purposes - Regulation of Investigatory Powers Act, 2000
Hey Gary, Download from here and follow the readme: http://www.neuro.gatech.edu/users/cwilson/cygutils/cygipc/#LATEST Cygipc is deprecated but not yet replaced. Cheers, Mike -----Original Message----- From: Gary Stainburn To: Mike Schroepfer; 'pgsql-cygwin@postgresql.org ' Sent: 10/25/2002 9:01 AM Subject: Re: [CYGWIN] initdb hangs On Friday 25 Oct 2002 4:57 pm, Mike Schroepfer wrote: > Hello Gary, > > Hanging in this spot on initdb usually means you do not have > the ipc-daemon.exe process running (from cygipc). Make sure you have > that running and you should be fine. > > Cheers, > > Mike Hi Mike, I had seen the mention about the cygipc in the readme, but I don't seem to have it installed and when I looked it up I saw a comment about it being depreciated and being replaced by functionality in the cygwin DLL. I therefore didnt' bother with it. How do I go about installing it? I've had a couple of looks at installing it through setup.exe but I can't find it in any of the categories. (I've got cygutils installed which I thought contained it) Thanks, Gary > > > -----Original Message----- > From: Gary Stainburn > To: pgsql-cygwin@postgresql.org > Sent: 10/25/2002 8:54 AM > Subject: [CYGWIN] initdb hangs > > Hi all, > > I've just installed the binary only cygwin today and I'm trying to get > postgesql working. I've had a quick look at the readme and the archives > and > I think I've done everything I need to (set > PGDATA=/usr/share/postgressql/data, made sure I've got entries in passwd > and > group etc.) > > When I run initdb (with the -D param and without), it hangs on the > bottom > line of the extract below. There is no disk activity and it doesn't > matter > how long I leave it. > > Anyone got any ideas? > > > gary@ladvent ~ > $ initdb > The files belonging to the database system will be owned by user "gary". > This user bust also own the server process. > > Fixing permissions on existing directory /usr/share/postgresql/data... > ok > creating directory /usr/share/postgresql/data/base... ok > creating directory /usr/share/postgresql/data/global... ok > creating directory /usr/share/postgresql/data/pg_xlog... ok > creating directory /usr/share/postgresql/data/pg_clog... ok > creating template1 database in /usr/share/postgresql/data/base/1... -- Gary Stainburn This email does not contain private or confidential material as it may be snooped on by interested government parties for unknown and undisclosed purposes - Regulation of Investigatory Powers Act, 2000
On Friday 25 Oct 2002 5:09 pm, Mike Schroepfer wrote: > Hey Gary, > > Download from here and follow the readme: > > http://www.neuro.gatech.edu/users/cwilson/cygutils/cygipc/#LATEST > > Cygipc is deprecated but not yet replaced. Cheers, Thanks for that Mike. I've now got a working postgresql database on my laptop, and all I had to do was change the path to the pgpsql handler and my database imported perfectly. All I need to do now is get apache/perl/PHP and gvim working and I'm laughing. Gary > > Mike > > > -----Original Message----- > From: Gary Stainburn > To: Mike Schroepfer; 'pgsql-cygwin@postgresql.org ' > Sent: 10/25/2002 9:01 AM > Subject: Re: [CYGWIN] initdb hangs > > On Friday 25 Oct 2002 4:57 pm, Mike Schroepfer wrote: > > Hello Gary, > > > > Hanging in this spot on initdb usually means you do not have > > the ipc-daemon.exe process running (from cygipc). Make sure you have > > that running and you should be fine. > > > > Cheers, > > > > Mike > > Hi Mike, > > I had seen the mention about the cygipc in the readme, but I don't seem > to > have it installed and when I looked it up I saw a comment about it being > > depreciated and being replaced by functionality in the cygwin DLL. I > therefore didnt' bother with it. > > How do I go about installing it? I've had a couple of looks at > installing it > through setup.exe but I can't find it in any of the categories. (I've > got > cygutils installed which I thought contained it) > > Thanks, > > Gary > > > -----Original Message----- > > From: Gary Stainburn > > To: pgsql-cygwin@postgresql.org > > Sent: 10/25/2002 8:54 AM > > Subject: [CYGWIN] initdb hangs > > > > Hi all, > > > > I've just installed the binary only cygwin today and I'm trying to get > > postgesql working. I've had a quick look at the readme and the > > archives > > > and > > I think I've done everything I need to (set > > PGDATA=/usr/share/postgressql/data, made sure I've got entries in > > passwd > > > and > > group etc.) > > > > When I run initdb (with the -D param and without), it hangs on the > > bottom > > line of the extract below. There is no disk activity and it doesn't > > matter > > how long I leave it. > > > > Anyone got any ideas? > > > > > > gary@ladvent ~ > > $ initdb > > The files belonging to the database system will be owned by user > > "gary". > > > This user bust also own the server process. > > > > Fixing permissions on existing directory /usr/share/postgresql/data... > > ok > > creating directory /usr/share/postgresql/data/base... ok > > creating directory /usr/share/postgresql/data/global... ok > > creating directory /usr/share/postgresql/data/pg_xlog... ok > > creating directory /usr/share/postgresql/data/pg_clog... ok > > creating template1 database in /usr/share/postgresql/data/base/1... -- Gary Stainburn This email does not contain private or confidential material as it may be snooped on by interested government parties for unknown and undisclosed purposes - Regulation of Investigatory Powers Act, 2000
On Fri, Oct 25, 2002 at 06:36:27PM +0100, Gary Stainburn wrote: > I've now got a working postgresql database on my laptop, and all I had > to do was change the path to the pgpsql handler and my database > imported perfectly. > > All I need to do now is get apache/perl/PHP and gvim working and I'm > laughing. Isn't Cygwin amazing? Jason