Re: initdb...

mike g <[email protected]>
Newsgroups gmane.comp.db.postgresql.cygwin
Message-ID <[email protected]>
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: [email protected] [mailto:[email protected]]
> 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 [email protected])

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.