* [EMAIL PROTECTED] <[EMAIL PROTECTED]> [1153 22:53]:
> In /usr/local/etc/rc.d I find 010.pgsql.sh to start the service but
> "/usr/local/etc/rc.d/010.pgsql.sh start"
> doesn't look to do anything.
>
> if I "su - pgsql" then try to "createdb" an error of missing server pops
> up.
> Could you please help in a straightforward way how to set postgresql straight?
less ~pgsql/post-install-notes
you want
su -l pgsql -c initdb
initdb creates the postgres system catalogs etc, you can't use createdb without
them (since createdb makes databases by copying the template1 database).
> By the way how can I tell FreeBSD I want the postgresql to be started at
> boot time?
'/usr/local/etc/rc.d/010.pgsql.sh start' should work after you've run that.
Once the postmaster starts, then createdb will work.
--
Aww, you know what always cheers me up? Laughing at other people's misfortunes. -
Bender
Rasputin :: Jack of All Trades - Master of Nuns
___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "[EMAIL PROTECTED]"
