* [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]