Starting PostgreSQL on FreeBSD

From: Eimar Koort <eimar(at)vykk(dot)vil(dot)ee>
To: pgsql-admin(at)postgresql(dot)org
Subject: Starting PostgreSQL on FreeBSD
Date: 2004-01-06 06:17:22
Message-ID: 20040105200914.F60144@dragon.vykk.vil.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Hi,

PostgreSQL 7.3.4 on i386-portbld-freebsd4.9, compiled by GCC 2.95.4
pg_hba.conf has following entry:
#
local all pgsql md5
#
hostname# /usr/local/etc/rc.d/010.pgsql.sh start
Password:
^C

So. If i try to start postgre (or machine boots up), it asks password.
/usr/local/etc/rc.d/010.pgsql.sh contains following:

case $1 in
start)
touch ${logfile}
chmod 600 ${logfile}
chown pgsql:pgsql ${logfile}
[ -x ${PGBIN}/pg_ctl ] && {
su -l pgsql -c \
"[ -d \${PGDATA} ] && exec ${PREFIX}/bin/pg_ctl start -s -w -l ${logfile}"
echo -n ' pgsql'
}
;;

Solution is to remove '-w' option.
"[ -d \${PGDATA} ] && exec ${PREFIX}/bin/pg_ctl start -s -l ${logfile}"

Hope it helps, if somebody get's stuck.

---
Eimar Koort
( eimar(at)vykk(dot)vil(dot)ee )

In response to

  • PG_DUMP at 2003-12-31 08:01:18 from omkar prabhu

Browse pgsql-admin by date

  From Date Subject
Next Message Nicky Mutinda 2004-01-06 15:48:46 Business Objects and Postgresql
Previous Message Tsirkin Evgeny 2004-01-05 22:37:52 Re: postgresql crushed with XLogWrite error