Re: Anyone using postgreSQL on Mac OS X installed by Fink?

Hi, Mat -

Check out Marc Liyanage's page at
http://www.entropy.ch/software/macosx/postgresql/

He has a StartupItem that should do nicely.  It installs as a package
(as does his excellent 7.3 binary).  The script, located at
/Library/StartupItems/PostgreSQL/PostgreSQL can be examined with
TextEdit, and is _almost_ self-explanatory.

sudo /Library/StartupItems/PostgreSQL/PostgreSQL { start | stop }

does the trick.

D

On Sunday, December 15, 2002, at 09:19  AM, Mat Rice wrote:

> I have checked with the Fink lists, to no avail. So I thought I'd try
> here.
>
> I have just installed the latest postgreSQL from the unstable tree in
> Fink.
> The info file says:
>
> "You can start the PostgreSQL server manually using 'postmaster' as
> pgsql
> (since pgsql has a shell of /dev/null by default, you must run it as
> sudo -u
> pgsql postmaster) or you can run 'daemonic enable postgresql' as root
> to
> create a StartupItem for it"
>
> However when I try that, I get:
>
> mat% sudo daemonic enable postgresql
> No matching service found for "postgresql", skipping.
>
> mat% sudo -u pgsql postmaster
> postmaster does not know where to find the database system data.
> You must specify the directory that contains the database system
> either by specifying the -D invocation option or by setting the
> PGDATA environment variable.
>
> So then I try:
>
> mat% sudo -u pgsql postmaster -D /Volumes/Files/sw/bin
> FATAL 1:  data directory /Volumes/Files/sw/bin has group or world
> access;
> permissions should be u=rwx (0700)
>
> Now I'm a little leery of changing permissions on that directory as
> everything else seems to be working fine with it the way it is.
>
> I'm sure it's something simple I'm missing, does anybody have my clue?
>
> Thanks,
>
> Mat
>
> Latest Fink via CVS
> postgreSQL 7.2.3
> OS X 10.2.2
> Latest developer tools
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
>
--
David C. Oshel               mailto:dcoshel@inav.net
Cedar Rapids, Iowa       http://soli.inav.net/~dcoshel
``I think most pleasantly in metaphors, and smoking brings metaphors to
mind." - Augustus Srb, in Alexei Panshin's  _Star Well_