Thread: Wrong startup script of PostgreSQL 9.1.2 under OpenBSD 5.1
On page http://www.postgresql.org/docs/9.1/interactive/server-start.html was published a wrong startup script for automatic starting PostgeSQL during boot under OpenBSD. Here is a working one which should be placed into /etc/rc.local file: if [ -x /usr/local/bin/pg_ctl -a -x /usr/local/bin/postgres ]; then su - _postgresql -c '/usr/local/bin/pg_ctl -D /var/postgresql/data start -l /var/postgresql/logfile -s' echo -n 'postgresql' fi Please correct your manual pages ASAP in order to prevent spending time to fix it. Denis
Denis Lapshin <deniza956@gmail.com> writes: > On page http://www.postgresql.org/docs/9.1/interactive/server-start.html > was published a wrong startup script for automatic starting PostgeSQL > during boot under OpenBSD. > Here is a working one which should be placed into /etc/rc.local file: > if [ -x /usr/local/bin/pg_ctl -a -x /usr/local/bin/postgres ]; then > su - _postgresql -c '/usr/local/bin/pg_ctl -D /var/postgresql/data > start -l /var/postgresql/logfile -s' > echo -n 'postgresql' > fi Right offhand it's not apparent to me that either of these can be said to be "right" or "wrong". You are making different assumptions about the installation directory and user name than what is in the documentation, but your assumptions aren't more right than the docs'. As stated there, the examples use generic choices that may need to be adjusted for particular systems. regards, tom lane
Hello there, I have already posted this problem several months ago, there was no change in the documentation since then. It's not about the installation directory or username, under the new OpenBSD's the parameter ordering of 'su' differs from the older versions, the right order is like Denis writes. Gábor Hidvégi ----- Original Message ----- From: "Tom Lane" <tgl@sss.pgh.pa.us> To: "Denis Lapshin" <deniza956@gmail.com> Cc: <pgsql-docs@postgresql.org> Sent: Tuesday, September 25, 2012 7:02 PM Subject: Re: [DOCS] Wrong startup script of PostgreSQL 9.1.2 under OpenBSD 5.1 > Denis Lapshin <deniza956@gmail.com> writes: >> On page http://www.postgresql.org/docs/9.1/interactive/server-start.html >> was published a wrong startup script for automatic starting PostgeSQL >> during boot under OpenBSD. > >> Here is a working one which should be placed into /etc/rc.local file: > >> if [ -x /usr/local/bin/pg_ctl -a -x /usr/local/bin/postgres ]; then >> su - _postgresql -c '/usr/local/bin/pg_ctl -D /var/postgresql/data >> start -l /var/postgresql/logfile -s' >> echo -n 'postgresql' >> fi > > Right offhand it's not apparent to me that either of these can be said > to be "right" or "wrong". You are making different assumptions about > the installation directory and user name than what is in the > documentation, but your assumptions aren't more right than the docs'. > As stated there, the examples use generic choices that may need to be > adjusted for particular systems. > > regards, tom lane > > > -- > Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-docs >
=?iso-8859-2?Q?Hidv=E9gi_G=E1bor?= <gaborca@webvision.hu> writes:
> I have already posted this problem several months ago, there was no change
> in the documentation since then. It's not about the installation directory
> or username, under the new OpenBSD's the parameter ordering of 'su' differs
> from the older versions, the right order is like Denis writes.
Ah, okay (and I confirmed this with a bit of googling). Will fix,
thanks for the explanation.
regards, tom lane
=?iso-8859-2?Q?Hidv=E9gi_G=E1bor?= <gaborca@webvision.hu> writes:
> I have already posted this problem several months ago, there was no change
> in the documentation since then. It's not about the installation directory
> or username, under the new OpenBSD's the parameter ordering of 'su' differs
> from the older versions, the right order is like Denis writes.
BTW, a little further googling turns up the information that this isn't
OpenBSD-specific; there are a number of platforms where "su -c" doesn't
act like it does on Linux. But "su username -c 'command'" works the
same everywhere. I'll adjust the generic text as well as the OpenBSD
paragraph in light of this.
regards, tom lane