20294 – PostgreSQL 7.3.x can't use other data directory because of misstake in start/stop-script

Bug 20294 - PostgreSQL 7.3.x can't use other data directory because of misstake in start/stop-script

Summary: PostgreSQL 7.3.x can't use other data directory because of misstake in start/...

Status:	RESOLVED FIXED

Alias:	None

Product:	Gentoo Linux
Classification:	Unclassified
Component:	Current packages (show other bugs)
Hardware:	x86 Linux

Importance:	High normal (vote)
Assignee:	Masatomo Nakano (RETIRED)

URL:
Whiteboard:
Keywords:

Depends on:
Blocks:

Reported:	2003-05-01 17:13 UTC by tuXXer
Modified:	2007-09-22 23:12 UTC (History)
CC List:	1 user (show)

See Also:
Package list:
Runtime testing required:	---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description tuXXer 2003-05-01 17:13:14 UTC

I've wondered why changing of the config file in /etc/conf.d/postgresql have no effect 
on starting of PostgreSQL. I ever became the message: can't change to directory 
"/var/lib/postgresql".  
 
I've found the solution of the problem: 
 
The lines in "start", "stop" and "restart" begins with: 
 
 su - $PGUSER -c "/usr/bin/pg_ctl start -D '$PGDATA'... 
 
It doesn't shall read "su - $PGUSER", because su can't change to $PGUSER. The 
command is invalid and pg_ctl starts with default parameters. The line must only begin 
with: 
 
su $PGUSER....   !!!!!!!!!!!!!!!!!!!!!!!!!!

Comment 1 Masatomo Nakano (RETIRED) gentoo-dev

2003-06-06 14:31:11 UTC

It looks fine at the moment.
If there is still any problem, please reopen this bug.