pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
start-up script for OpenBSD
2+ messages / 2 participants
[nested] [flat]

* start-up script for OpenBSD
@ 2016-12-29 14:33  azopane@gmail.com
  0 siblings, 1 reply; 2+ messages in thread

From: azopane@gmail.com @ 2016-12-29 14:33 UTC (permalink / raw)
  To: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.5/static/index.html
Description:

Hi.

I have just installed OpenBSD 6.0 with the postgresql package (pg 9.5.3)

Section 17.3 of the postgresql documentation gives a recommended startup
script for OpenBSD to be put into /etc/rc.local

The path is incorrect for pg_ctl and postgres. These are located in
/usr/local/bin and not /usr/local/pgsql/bin as given. Naturally this does
not allow postgresql to start at boot.

Also I used '-l logfile' which will write into the postgres user home
directory as the /var/postgresql directory shown, although present, would
have to have permissions or ownership changed to allow a write (I did not
pursue that but dmesg clearly shows an error).

Else the documentation is as always a great help.

Ian



-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: start-up script for OpenBSD
@ 2016-12-29 23:28  Tom Lane <tgl@sss.pgh.pa.us>
  parent: azopane@gmail.com
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2016-12-29 23:28 UTC (permalink / raw)
  To: azopane@gmail.com; +Cc: pgsql-docs

azopane@gmail.com writes:
> I have just installed OpenBSD 6.0 with the postgresql package (pg 9.5.3)

> Section 17.3 of the postgresql documentation gives a recommended startup
> script for OpenBSD to be put into /etc/rc.local

> The path is incorrect for pg_ctl and postgres. These are located in
> /usr/local/bin and not /usr/local/pgsql/bin as given. Naturally this does
> not allow postgresql to start at boot.

Well, /usr/local/pgsql/bin *is* where they're installed if you build PG
from source without modifications.  The OpenBSD packager evidently changed
that to conform with local custom, which is entirely reasonable --- many
other platforms change the install location too.  But we can't document
what other people do.  It's the responsibility of the platform packager
to provide documentation saying what they changed.  Most packagers also
provide suitably customized startup scripts ... did you check?

			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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2016-12-29 23:28 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-12-29 14:33 start-up script for OpenBSD azopane@gmail.com
2016-12-29 23:28 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox