Thread: Re: initdb...

Re: initdb...

From
"Daniel Secomb"
Date:
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@iname.com [mailto:zuhans@iname.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


Re: initdb...

From
mike g
Date:
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@iname.com [mailto:zuhans@iname.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@postgresql.org)