You shouldn't post to multiple lists at one time. It is rude for very many
reasons.
This is the line I use to start postgres from rc.local (watch the word
wrap). Password is irrelevant. If I understand correctly, root is what
runs the rc.local and root never needs a password to su to another user.
Log in as root and su to a user. You'll see. Very possible your comand is
failing for other reasons.
# Start Postgresql
su -l <username for which postgres runs under> -c "<location of
postmaster> -i -D <postgres data directory> >> <path to postgres log file>
2>>1 &"
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
----- Original Message -----
From: "Julio Cuz, Jr." <jcuz@rccd.cc.ca.us>
To: <pgsql-php@postgresql.org>; <php-db@lists.php.net>
Sent: Thursday, January 04, 2001 9:55 PM
Subject: [PHP] Autologin problem
> Hi--
>
> I'm trying to run the following command on the "/etc/rc.local" so it will
> run everytime (RedHat 7/PHP4/PostgreSQL):
>
> nohup su -c 'postmaster -i -D /usr/local/pgsql/data \
> </dev/null >>server.log 2>>1 &' <username>
>
> The problem is that <username> has a password set, and since Linux doesn't
> ask for it when it's on the rc.local file, my command fails.
>
> Is there a way to include the password with the "su" command?
>
> Is there a way to CLEAR a user's password and set it to NULL?
>
> Julio Cuz, Jr.
> Riverside Community College
> jcuz@rccd.cc.ca.us
