Re: [GENERAL] Starting Postmaster
"Scott Gritton" [EMAIL PROTECTED] writes: I've installed postgresql on a Linux-Mandrake 7.0.2 box with everything installing correctly. But when I try to start postmaster I get the following: DEBUG: Data Base System is in production state at Mon Mar 26 (and so forth) I know that there is a simple answer but I haven't been able to find it in documentation or faqs. Ummm... You haven't included anything that actually indicates an error. The message above is basically saying "I'm alive and happy." How about some actual error messages? -Doug ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [GENERAL] Starting Postmaster
On Monday 26 March 2001 03:49 pm, Doug McNaught wrote: "Scott Gritton" [EMAIL PROTECTED] writes: I've installed postgresql on a Linux-Mandrake 7.0.2 box with everything installing correctly. But when I try to start postmaster I get the following: DEBUG: Data Base System is in production state at Mon Mar 26 (and so forth) I know that there is a simple answer but I haven't been able to find it in documentation or faqs. Ummm... You haven't included anything that actually indicates an error. The message above is basically saying "I'm alive and happy." How about some actual error messages? Also - look at your process list - is the postmaster running? Can you use psql? Michelle Michelle Murrain, Ph.D. President Norwottuck Technology Resources [EMAIL PROTECTED] http://www.norwottuck.com ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
Re: [GENERAL] Starting Postmaster
On Mon, 26 Mar 2001, Scott Gritton wrote: I've installed postgresql on a Linux-Mandrake 7.0.2 box with everything installing correctly. But when I try to start postmaster I get the following: DEBUG: Data Base System is in production state at Mon Mar 26 (and so forth) I know that there is a simple answer but I haven't been able to find it in documentation or faqs. Your postmaster if functioning perfectly, you just need to direct its output to a logfile and put it into the background. Here is how I usually startup postmaster: nohup postmaster [options] logfile 21 -- Brett http://www.chapelperilous.net/btfwk/ Humor in the Court: Q: Now, you have investigated other murders, have you not, where there was a victim? ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] Starting postmaster at boot
At 03:20 PM 9/14/00 -0400, Adam Lang wrote: I'm still having difficulties getting postgres to start on boot. Any chance someone can give me an example of how they have it on their system? (Seemed to have been lost in the list being down). Adam Lang Systems Engineer Rutgers Casualty Insurance Company Haven't done much looking into it for efficiency or anything like that, but here's what I have in my rc.local file (FreeBSD 3.2). Hope it helps! #!/bin/sh [ -x /usr/local/pgsql/bin/postmaster ] { su -l postgres -c 'exec /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data -S -o -F -N 48 -B 96 /home/postgres/postgres.log' echo -n ' postgres' } David Veatch - [EMAIL PROTECTED] "Many people would sooner die than think. In fact, they do." - Bertrand Russell
Re: [GENERAL] Starting postmaster at boot
Does it work the same for linux? Adam Lang Systems Engineer Rutgers Casualty Insurance Company - Original Message - From: "David Veatch" [EMAIL PROTECTED] To: "Adam Lang" [EMAIL PROTECTED]; "PGSQL General" [EMAIL PROTECTED] Sent: Thursday, September 14, 2000 3:29 PM Subject: Re: [GENERAL] Starting postmaster at boot At 03:20 PM 9/14/00 -0400, Adam Lang wrote: I'm still having difficulties getting postgres to start on boot. Any chance someone can give me an example of how they have it on their system? (Seemed to have been lost in the list being down). Adam Lang Systems Engineer Rutgers Casualty Insurance Company Haven't done much looking into it for efficiency or anything like that, but here's what I have in my rc.local file (FreeBSD 3.2). Hope it helps! #!/bin/sh [ -x /usr/local/pgsql/bin/postmaster ] { su -l postgres -c 'exec /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data -S -o -F -N 48 -B 96 /home/postgres/postgres.log' echo -n ' postgres' } David Veatch - [EMAIL PROTECTED] "Many people would sooner die than think. In fact, they do." - Bertrand Russell
Re: [GENERAL] Starting postmaster at boot
At 03:31 PM 9/14/00 -0400, Adam Lang wrote: Does it work the same for linux? It's basic sh, so I can only assume that it does, though I should stress that I don't run Linux, and haven't sat at a Linux command prompt in over a year... so I can't say it does with 100% certainty. The sh syntax should port, and if the Linux port of Postgres supports the same arguments as the FreeBSD port, then that should work as well... David Veatch - [EMAIL PROTECTED] "Many people would sooner die than think. In fact, they do." - Bertrand Russell
Re: [GENERAL] Starting postmaster at boot
I didn't directly use your method, but you nonetheless solved my problem. From the beginning everyone was telling me to put this into my rc.local: su postgres -c "/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data -i /usr/local/pgsql/postgres.log 21 " It was never working. I noticed you had a tag "-l" in yours for su. I looked up the reason for it and gave it a try. So the script: su -l postgres -c "/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data -i /home/postgres/postgres.log 21 " does work. I still don't understand the point of the 1's and 2's in the command though. Why is everyone else's script working without the -l and mine wasn't? Thanks. Adam Lang Systems Engineer Rutgers Casualty Insurance Company - Original Message - From: "David Veatch" [EMAIL PROTECTED] To: "Adam Lang" [EMAIL PROTECTED]; "PGSQL General" [EMAIL PROTECTED] Sent: Thursday, September 14, 2000 3:29 PM Subject: Re: [GENERAL] Starting postmaster at boot At 03:20 PM 9/14/00 -0400, Adam Lang wrote: I'm still having difficulties getting postgres to start on boot. Any chance someone can give me an example of how they have it on their system? (Seemed to have been lost in the list being down). Adam Lang Systems Engineer Rutgers Casualty Insurance Company Haven't done much looking into it for efficiency or anything like that, but here's what I have in my rc.local file (FreeBSD 3.2). Hope it helps! #!/bin/sh [ -x /usr/local/pgsql/bin/postmaster ] { su -l postgres -c 'exec /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data -S -o -F -N 48 -B 96 /home/postgres/postgres.log' echo -n ' postgres' } David Veatch - [EMAIL PROTECTED] "Many people would sooner die than think. In fact, they do." - Bertrand Russell
Re: [GENERAL] Starting postmaster at boot
* Adam Lang [EMAIL PROTECTED] [000914 13:21] wrote: I didn't directly use your method, but you nonetheless solved my problem. From the beginning everyone was telling me to put this into my rc.local: su postgres -c "/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data -i /usr/local/pgsql/postgres.log 21 " It was never working. I noticed you had a tag "-l" in yours for su. I looked up the reason for it and gave it a try. So the script: su -l postgres -c "/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data -i /home/postgres/postgres.log 21 " does work. I still don't understand the point of the 1's and 2's in the command though. It tells the shell to hook the child's stderr to stdout so that all output should go to /home/postgres/postgres.log. Why is everyone else's script working without the -l and mine wasn't? Check su's manpage. -- -Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]] "I have the heart of a child; I keep it in a jar on my desk."
Re: [GENERAL] Starting postmaster at boot
Adam Lang wrote: I didn't directly use your method, but you nonetheless solved my problem. From the beginning everyone was telling me to put this into my rc.local: su postgres -c "/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data -i /usr/local/pgsql/postgres.log 21 " It was never working. I noticed you had a tag "-l" in yours for su. I looked up the reason for it and gave it a try. So the script: su -l postgres -c "/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data -i /home/postgres/postgres.log 21 " does work. I still don't understand the point of the 1's and 2's in the command though. it's a method for redirecting STDERR -- STDOUT this is especially usefull in scripts normally I use [scriptname /dev/null 21] to send any unwanted output to /dev/null Why is everyone else's script working without the -l and mine wasn't? '-l' uses the login profile for the su'd user... this is similar to a 'simuated login', without it , it was only referencing variables from your roo profile ... (ie. no PGDATA,etc..) -- Dale Walker [EMAIL PROTECTED] Independent Computer Retailers (ICR) http://www.icr.com.au ICRnet http://www.icr.net.au
Re: [GENERAL] Starting postmaster at boot
oh... so since I did a su -l, I could have just used the command, postmaster -i postgres.log 21 ? Since I had the appropriate variables in postgres's .bash_profile? Adam Lang Systems Engineer Rutgers Casualty Insurance Company - Original Message - From: "Dale Walker" [EMAIL PROTECTED] To: "Adam Lang" [EMAIL PROTECTED] Cc: "PGSQL General" [EMAIL PROTECTED] Sent: Thursday, September 14, 2000 4:33 PM Subject: Re: [GENERAL] Starting postmaster at boot Adam Lang wrote: I didn't directly use your method, but you nonetheless solved my problem. From the beginning everyone was telling me to put this into my rc.local: su postgres -c "/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data -i /usr/local/pgsql/postgres.log 21 " It was never working. I noticed you had a tag "-l" in yours for su. I looked up the reason for it and gave it a try. So the script: su -l postgres -c "/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data -i /home/postgres/postgres.log 21 " does work. I still don't understand the point of the 1's and 2's in the command though. it's a method for redirecting STDERR -- STDOUT this is especially usefull in scripts normally I use [scriptname /dev/null 21] to send any unwanted output to /dev/null Why is everyone else's script working without the -l and mine wasn't? '-l' uses the login profile for the su'd user... this is similar to a 'simuated login', without it , it was only referencing variables from your roo profile ... (ie. no PGDATA,etc..) -- Dale Walker [EMAIL PROTECTED] Independent Computer Retailers (ICR) http://www.icr.com.au ICRnethttp://www.icr.net.au
Re: [GENERAL] Starting postmaster at boot
The reason I didn't have to use the -l is that I have everything PostgreSQL needs (as far as environment variables) already set, because this machine is a dedicated PostgreSQL server. Sorry, should have thought about that before I replied but it seems you have it running now, that's great.. Good luck! -Mitch - Original Message - From: "Dale Walker" [EMAIL PROTECTED] To: "Adam Lang" [EMAIL PROTECTED] Cc: "PGSQL General" [EMAIL PROTECTED] Sent: Thursday, September 14, 2000 1:33 PM Subject: Re: [GENERAL] Starting postmaster at boot Adam Lang wrote: I didn't directly use your method, but you nonetheless solved my problem. From the beginning everyone was telling me to put this into my rc.local: su postgres -c "/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data -i /usr/local/pgsql/postgres.log 21 " It was never working. I noticed you had a tag "-l" in yours for su. I looked up the reason for it and gave it a try. So the script: su -l postgres -c "/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data -i /home/postgres/postgres.log 21 " does work. I still don't understand the point of the 1's and 2's in the command though. it's a method for redirecting STDERR -- STDOUT this is especially usefull in scripts normally I use [scriptname /dev/null 21] to send any unwanted output to /dev/null Why is everyone else's script working without the -l and mine wasn't? '-l' uses the login profile for the su'd user... this is similar to a 'simuated login', without it , it was only referencing variables from your roo profile ... (ie. no PGDATA,etc..) -- Dale Walker [EMAIL PROTECTED] Independent Computer Retailers (ICR) http://www.icr.com.au ICRnethttp://www.icr.net.au
Re: [GENERAL] Starting postmaster at boot
OH! I get it. Whereas I have the environment variables in postgres's .bash_profile, you have it set where those variables are loaded for all users, correct? But the part that I don't get is that (typing it at console) I can start postgresql (while logged in as postgres) with the command: postmaster -i because I have the variables for the location of postmaster and pgdata set. But, I would assume that typing the absolute paths would have gotten around that for when I was doing the su. Are there other environment variables I didn't take insto consideration? Adam Lang Systems Engineer Rutgers Casualty Insurance Company - Original Message - From: "Mitch Vincent" [EMAIL PROTECTED] To: "Adam Lang" [EMAIL PROTECTED] Cc: "PGSQL General" [EMAIL PROTECTED] Sent: Thursday, September 14, 2000 4:40 PM Subject: Re: [GENERAL] Starting postmaster at boot The reason I didn't have to use the -l is that I have everything PostgreSQL needs (as far as environment variables) already set, because this machine is a dedicated PostgreSQL server. Sorry, should have thought about that before I replied but it seems you have it running now, that's great.. Good luck! -Mitch - Original Message - From: "Dale Walker" [EMAIL PROTECTED] To: "Adam Lang" [EMAIL PROTECTED] Cc: "PGSQL General" [EMAIL PROTECTED] Sent: Thursday, September 14, 2000 1:33 PM Subject: Re: [GENERAL] Starting postmaster at boot Adam Lang wrote: I didn't directly use your method, but you nonetheless solved my problem. From the beginning everyone was telling me to put this into my rc.local: su postgres -c "/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data -i /usr/local/pgsql/postgres.log 21 " It was never working. I noticed you had a tag "-l" in yours for su. I looked up the reason for it and gave it a try. So the script: su -l postgres -c "/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data -i /home/postgres/postgres.log 21 " does work. I still don't understand the point of the 1's and 2's in the command though. it's a method for redirecting STDERR -- STDOUT this is especially usefull in scripts normally I use [scriptname /dev/null 21] to send any unwanted output to /dev/null Why is everyone else's script working without the -l and mine wasn't? '-l' uses the login profile for the su'd user... this is similar to a 'simuated login', without it , it was only referencing variables from your roo profile ... (ie. no PGDATA,etc..) -- Dale Walker [EMAIL PROTECTED] Independent Computer Retailers (ICR) http://www.icr.com.au ICRnethttp://www.icr.net.au