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