Date: Tue, 8 Apr 2003 14:42:11 +0200 From: Francesco Casadei <fcasadei@inwind.it> To: Wayne Pascoe <freebsd@penguinpowered.org.uk> Cc: freebsd-questions@freebsd.org Subject: Re: Postgres + MD5 Auth Message-ID: <20030408124211.GA1579@goku.kasby> In-Reply-To: <20030407093923.GB604@marvin.penguinpowered.org.uk> References: <20030407093923.GB604@marvin.penguinpowered.org.uk>
next in thread | previous in thread | raw e-mail | index | archive | help
--UugvWAfsgieZRqgk Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Mon, Apr 07, 2003 at 10:39:23AM +0100, Wayne Pascoe wrote: > Hi all, >=20 > Sorry to bug twice on one day, but does anyone know what I have to > change in the startup scripts for PostgreSQL (010.pgsql.sh) to make it > work with password authentication? >=20 > I've setup pg_hba.conf to use encrypted passwords (md5), but then > starting Postgres prompts for a password. This is not great for when the > machine reboots and no-one is around to enter this. >=20 > Is there any way of passing pgsql's password to the script ?=20 >=20 > Thanks, >=20 > --=20 > Wayne Pascoe > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.o= rg" > end of the original message =46rom man pg_ctl: [...] -w Wait for the start or shutdown to complete. Times out after 60 seconds. This is the default for shut- downs. -W Do not wait for start or shutdown to complete. This is the default for starts and restarts. [...] So, this is how I start up PostgreSQL with password authentication (note the capitol letter -W, not -w): [...] start) [ -d ${PREFIX}/lib ] && /sbin/ldconfig -m ${PREFIX}/lib touch /var/log/pgsql chmod 600 /var/log/pgsql chown pgsql:pgsql /var/log/pgsql [ -x ${PGBIN}/pg_ctl ] && { su -l pgsql -c \ '[ -d ${PGDATA} ] && exec /usr/local/bin/pg_ctl start -s -W -l /var= /log/pgsql' echo -n ' pgsql' } ;; [...] Francesco Casadei --=20 You can download my public key from http://digilander.libero.it/fcasadei/ or retrieve it from a keyserver (pgpkeys.mit.edu, wwwkeys.pgp.net, ...) Key fingerprint is: 1671 9A23 ACB4 520A E7EE 00B0 7EC3 375F 164E B17B --UugvWAfsgieZRqgk Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (FreeBSD) iD8DBQE+ksOjfsM3XxZOsXsRAgxzAJwKsmkEiWxh2J8T/J5hKhJmPxCoZgCdGYOl 5gJuazdCkN9/kSYIlPcv6e4= =YV/w -----END PGP SIGNATURE----- --UugvWAfsgieZRqgk--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20030408124211.GA1579>