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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-cygwin by date

  From Date Subject
Next Message mike g 2004-08-03 03:38:07 Re: Correct "db-stop" Script
Previous Message Daniel Secomb 2004-08-02 14:11:26 Re: Correct "db-stop" Script