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

I may be beating a dead horse here, but I just installed postgres using
fink.

The last line of the install process:

Success. You can now start the database server using:

sudo -u root sudo -u pgsql /sw/bin/pg_ctl \
-D /sw/var/postgresql/data -l /sw/var/log/postgresql/logfile
start

so to start it, type that. To start it with Liyanage's package, open
it up with whatever you want, and change the data directory to
/sw/var/postgresql/data and the executable part to /sw/bin/pg_ctl
instead of /use/local/pg_ctl. Glancing at the install log, it does
take care of all permissions modifications for you; you were just
pointing it at the wrong place.

I'm still going to recommend not using fink for this; the package is
out of date.

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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly