Skip site navigation (1) Skip section navigation (2)

Re: initdb...

From: mike g <mike(at)thegodshalls(dot)com>
To: Daniel Secomb <dan(at)ds-d(dot)com>
Cc: zuhans(at)iname(dot)com, pgsql-cygwin(at)postgresql(dot)org
Subject: Re: initdb...
Date: 2004-08-03 03:35:26
Message-ID: 1091504126.16772.10.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-cygwin
Possibly,

The output from what I suggested writes and log output to a logfile
rather than to the screen (so you can reuse the open cygwin window).

You can do ps -a to see if postmaster shows up in the process list,
check the log file or try to connect to the database using psql.

Mike


On Mon, 2004-08-02 at 01:54, Daniel Secomb wrote:
> YES!! I think I've figured it out! In the "db-start" script, I've replaced
> this line:
> 
> postmaster -i -D /var/postgresql/data &
> 
> With this line (that Mike G suggested):
> 
> /usr/local/pgsql/bin/postmaster -D /var/postgresql/data >logfile 2>&1 &
> 
> And I got the following result:
> 
> [2] 459255
> $ps -f
>      UID	   PID    PPID	TTY	   STIME	COMMAND
> Daniel S	882779	 1	con	16:24:21	/usr/bin/BASH
> Daniel S 177286207  882779	con	16:27:21	/USR/SBIN/CYGSERVER
> Daniel S	465255  882779	con	16:31:08	/usr/bin/PS
> [2]+ Exit 127						/usr/local/pgsql/bin/postmaster -D /var/postgresql/data
> >logfile 2>&1
> $
> 
> Does this mean that it's working???
> 
> Please let me know.
> 
> Thanks once again.
> 
> Dan
> 
> -----Original Message-----
> From: zuhans(at)iname(dot)com [mailto:zuhans(at)iname(dot)com]
> Sent: Saturday, July 31, 2004 3:11 AM
> To: Daniel Secomb
> Subject: initdb...
> 
> 
> hi dan,
> 
> what i forgot to say:
> if you really type in one command after the other (so as to learn what's
> going on), then - instead of typing in "./db-stop" - you have to type in
> all commands from my "db-stop"-script-lines.
> 
> but then the "kill..."-line won't work! instead just type in "ps -f",
> then you get the list of all processes running at the moment, remember
> the process-number of cygserver (very left coloumn of ps - output) and
> then type in: "kill <process-number>" (e.g. kill 3024). this makes a
> shutdown of cygserver.
> 
> hope that helps!
> hans
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

In response to

pgsql-cygwin by date

Next:From: mike gDate: 2004-08-03 03:38:07
Subject: Re: Correct "db-stop" Script
Previous:From: Daniel SecombDate: 2004-08-02 14:11:26
Subject: Re: Correct "db-stop" Script

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group