You should really use the port. it has a working startup
script, and it creates a pgsql/.profile for you. Using su -m is
more error prone IMHO. It will export locales and such, that
you really don't want to export to postmaster.


Vivek Khera wrote:
> I installed the sample startup script for postgres for FreeBSD, but it
> reports the following error upon running:
> # /usr/local/etc/rc.d/ start
> pg_ctl: no database directory or environment variable $PGDATA is specified
> Try 'pg_ctl --help' for more information.
> I see clearly that PGDATA is set and exported.  I'm suspecting that
> the "su -l" causes the environment to disappear.  My guess is that
> whomever wrote this script has PGDATA set in the ~/.profile (or
> equivalent) in the postgres user's home directory.
> Thus, it is pointless to set PGDATA in the script.  Setting and
> exporting PGDATA in the ~/.profile file lets postgres start as
> expected.
> The commentary says to copy the file to /usr/local/etc/rc.d/postgresql
> but this is not useful; the file must in '.sh' and be executable or
> FreeBSD will ignore it on boot.
> Also, the following line in the start action of the sript is useful:
>         /sbin/ldconfig -m $prefix/lib
> --
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> Vivek Khera, Ph.D.                Khera Communications, Inc.
> Internet: [EMAIL PROTECTED]       Rockville, MD       +1-240-453-8497
> AIM: vivekkhera Y!: vivek_khera
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?

         Partitur Informationsteknik AB    
Wenner-Gren Center             +46 8 566 280 02  
113 46 Stockholm               +46 70 785 86 02  
Sweden                         [EMAIL PROTECTED]

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to