PostgreSQL rc.d script outputting fortunes - Revision history

Tykling at 11:45, 3 January 2010

2010-01-03T11:45:48Z

← Older revision		Revision as of 11:45, 3 January 2010
Line 28:		Line 28:

	== Explanation ==		== Explanation ==
	This happens because the postgresql rc.d script switches user to the postgresql ''pgsql'' user before executing the actual start/stop commands. For some reason, and only on this specific machine, the user switch with su called ''.profile'' which in turn ran the fortune system.		This happens because the postgresql rc.d script switches user to the postgresql ''pgsql'' user before executing the actual start/stop commands. For some reason, and only on this specific machine, the user switch with su called ''.profile'' which in turn ran the fortune system. The reason is probably that I always install "minimal" (in sysinstall) FreeBSD machines these days. The machine that had this problem is older and was installed as "standard" (in sysinstall). This means that /usr/games/fortune/ exists on this machine and not on a lot of my newer machines. The fortune line from .profile will only run if the fortunes are installed, of course.

Tykling: moved Postgres fortunes to PostgreSQL rc.d script outputting fortunes

2009-12-20T09:47:03Z

moved Postgres fortunes to PostgreSQL rc.d script outputting fortunes

← Older revision	Revision as of 09:47, 20 December 2009
(No difference)

Tykling at 09:23, 20 December 2009

2009-12-20T09:23:25Z

← Older revision		Revision as of 09:23, 20 December 2009
Line 1:		Line 1:
			[[category:postgres]]
	I've been having a weird problem with the postgresql rc.d script in a FreeBSD jail. I finally figured out today how to fix it and wanted to put it on here so I dont forget.		I've been having a weird problem with the postgresql rc.d script in a FreeBSD jail. I finally figured out today how to fix it and wanted to put it on here so I dont forget.

Tykling: /* The solution */

2009-12-20T09:22:24Z

The solution

← Older revision		Revision as of 09:22, 20 December 2009
Line 20:		Line 20:

	And now I don't get the any tips when using the postgresql rc.d script:		And now I don't get the any tips when using the postgresql rc.d script:
			<pre>
	[root@wackbox163 /usr/local/pgsql]# /usr/local/etc/rc.d/postgresql restart		[root@wackbox163 /usr/local/pgsql]# /usr/local/etc/rc.d/postgresql restart
	server stopped		server stopped
	[root@wackbox163 /usr/local/pgsql]#		[root@wackbox163 /usr/local/pgsql]#
			</pre>

	== Explanation ==		== Explanation ==
	This happens because the postgresql rc.d script switches user to the postgresql ''pgsql'' user before executing the actual start/stop commands. For some reason, and only on this specific machine, the user switch with su called ''.profile'' which in turn ran the fortune system.		This happens because the postgresql rc.d script switches user to the postgresql ''pgsql'' user before executing the actual start/stop commands. For some reason, and only on this specific machine, the user switch with su called ''.profile'' which in turn ran the fortune system.

Tykling: Created page with 'I've been having a weird problem with the postgresql rc.d script in a FreeBSD jail. I finally figured out today how to fix it and wanted to put it on here so I dont forget. == T…'

2009-12-20T09:22:05Z

Created page with 'I've been having a weird problem with the postgresql rc.d script in a FreeBSD jail. I finally figured out today how to fix it and wanted to put it on here so I dont forget. == T…'

New page

I've been having a weird problem with the postgresql rc.d script in a FreeBSD jail. I finally figured out today how to fix it and wanted to put it on here so I dont forget.

== The problem ==
Whenever I call the postgresql rc.d script to start/stop/restart/whatever the postgres server I would get a fortune from freebsd-tips like when you log in:

<pre>
[root@wackbox163 /usr/local/pgsql]# /usr/local/etc/rc.d/postgresql restart
Any user that is a member of the wheel group can use "su -" to simulate
a root login. You can add a user to the wheel group by editing /etc/group.
-- Konstantinos Konstantinidis <kkonstan@duth.gr>
server stopped
[root@wackbox163 /usr/local/pgsql]#
</pre>

== The solution ==
I have been completely unable to figure out why this was happening, until a friend of mine reminded me to check .profile. I opened up ''/usr/local/pgsql/.profile'' and commented out the following line:
<pre>
[ -x /usr/games/fortune ] && /usr/games/fortune freebsd-tips
</pre>

And now I don't get the any tips when using the postgresql rc.d script:
[root@wackbox163 /usr/local/pgsql]# /usr/local/etc/rc.d/postgresql restart
server stopped
[root@wackbox163 /usr/local/pgsql]#

== Explanation ==
This happens because the postgresql rc.d script switches user to the postgresql ''pgsql'' user before executing the actual start/stop commands. For some reason, and only on this specific machine, the user switch with su called ''.profile'' which in turn ran the fortune system.