Date: Sat, 6 Nov 2004 00:43:05 +0000 From: Dick Davies <rasputnik@hellooperator.net> To: v.demartino2@virgilio.it Cc: FreeBSD Questions <freebsd-questions@freebsd.org> Subject: Re: Postgresql not starting... Message-ID: <20041106004305.GB1091@lb.tenfour> In-Reply-To: <41536B850007F193@ims3e.cp.tin.it> References: <41536B850007F193@ims3e.cp.tin.it>
next in thread | previous in thread | raw e-mail | index | archive | help
* v.demartino2@virgilio.it <v.demartino2@virgilio.it> [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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20041106004305.GB1091>