pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Eimar Koort <eimar@vykk.vil.ee>
To: pgsql-admin@postgresql.org
Subject: Starting PostgreSQL on FreeBSD
Date: Tue, 6 Jan 2004 08:17:22 +0200 (EET)
Message-ID: <20040105200914.F60144@dragon.vykk.vil.ee> (raw)
In-Reply-To: <000201c3cf74$4db995f0$a30110ac@OMKAR>
References: <000201c3cf74$4db995f0$a30110ac@OMKAR>


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@vykk.vil.ee )




Message-ID: <20040105200914.F60144@dragon.vykk.vil.ee>
Permalink:  ../20040105200914.F60144@dragon.vykk.vil.ee/
Also on:    postgresql.org/message-id/20040105200914.F60144@dragon.vykk.vil.ee

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: eimar@vykk.vil.ee
  Subject: Re: Starting PostgreSQL on FreeBSD
  In-Reply-To: <20040105200914.F60144@dragon.vykk.vil.ee>
  References: <000201c3cf74$4db995f0$a30110ac@OMKAR> <20040105200914.F60144@dragon.vykk.vil.ee>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox