WHERE IS POSTMASTER INITIALIZED?

[buxaman]

I Want to initialize postmaster with -i option but I don't know where. Is that the only thing to add before using jdbc besides JDK and classpath?

 

[rycamor]

What operating system are you using?

 

[buxaman]

Sorry. I´m using Linux and Postgresql 7.x.

 

[rycamor]

Well, I was hoping for specifically which Linux dist., since they can have slightly different initialization methods, but most likely you want to look in /etc/rc.d, and inside there you will have folders for each runlevel. Inside either runlevel 1 or 3, I believe you will find a symbolic link starting with the name "pg_ctl" or "post"-something or other. (Sorry, I am more familiar with FreeBSD)

If you don't find anything there, look inside a file called /etc/rc.local, or /etc/rc.d/rc.local. There you might find a reference to either postmaster, pg_ctl or some other "post" something script, which will be the postgres startup script.

IOW, often postmaster is not started directly, but is started through short shell script. Usually it is a script that can be run from the command line, in this manner:

pg_ctl start {options}
pg_ctl stop
pg_ctl restart

etc...

If this is the script, then you simply want to call it with the following arguments:

pg_ctl start -o -i -{whatever other options are already there}

If you look inside that script it will explain more, but you need -o to tell the script you are passing other parameters, such as the -i.

(hehe) Confused yet? This is why MySQL is much more popular ;-). But stick with it, because PostgreSQL is quite simply awesome, once you get it under control.

Also, perhaps you can help me, because I am going the other direction: I have Postgres installed and working fine, and connecting to PHP and Perl, but I am just starting to mess around with Jakarta, to start playing with servlets and JSP, and so I need to get jdbc working also, and learn how to set all that CLASSPATH stuff, which still has me somewhat confused. How about it?