Обсуждение: Just installed using Fink on OS X. Fails all over the place.

Did an install on OS X 10.2, using Fink with default settings.

First, it utterly ignores $PGDATA. I can do echo $PGDATA just fine,
but when I do

initdb

I get

initdb: You must identify where the the data for this database
system will reside.  Do this with either a -D invocation
option or a PGDATA environment variable.

So now I do

initdb -D ~/databases

which seems to run fine. Then I run the commands it tells me to run:

    sudo -u root sudo -u pgsql /sw/bin/pg_ctl \
        -D /Users/<me>/databases -l /sw/var/log/postgresql/logfile
start

and I get

shell-init: could not get current directory: getcwd: cannot access
parent directories: Permission denied
postmaster successfully started

alright; now I try all this as postgres:

su postgres

initdb ~/databases

which works fine. Then I do

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

and I get

postgres% shell-init: could not get current directory: getcwd: cannot
access parent directories: Permission denied
shell-init:: Too many arguments.
postmaster successfully started

There are other problems, but I'll start with this.

Thanks!

FYI ... PostgreSQL 7.3.x will compile and run on OS X 10.2.  A Fink install isn't necessary unless you want to use an
olderversion of PostgreSQL (even then, there are other options than Fink). 

I've made step-by-step instructions for a basic 7.3.2 install on OS X 10.2.  Contact me off-list if you want them.

- Jeff


>Did an install on OS X 10.2, using Fink with default settings.
>
>First, it utterly ignores $PGDATA. I can do echo $PGDATA just fine,
>but when I do
>
>initdb
>
>I get
>
>initdb: You must identify where the the data for this database
>system will reside.  Do this with either a -D invocation
>option or a PGDATA environment variable.
>
>So now I do
>
>initdb -D ~/databases
>
>which seems to run fine. Then I run the commands it tells me to run:
>
>    sudo -u root sudo -u pgsql /sw/bin/pg_ctl \
>        -D /Users/<me>/databases -l /sw/var/log/postgresql/logfile
>start
>
>and I get
>
>shell-init: could not get current directory: getcwd: cannot access
>parent directories: Permission denied
>postmaster successfully started
>
>alright; now I try all this as postgres:
>
>su postgres
>
>initdb ~/databases
>
>which works fine. Then I do
>
>    sudo -u root sudo -u pgsql /sw/bin/pg_ctl \
>        -D /Users/postgres/databases -l /sw/var/log/postgresql/logfile
>start
>
>and I get
>
>postgres% shell-init: could not get current directory: getcwd: cannot
>access parent directories: Permission denied
>shell-init:: Too many arguments.
>postmaster successfully started
>
>There are other problems, but I'll start with this.
>
>Thanks!
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org

--

Jeff Bohmer
VisionLink, Inc.
_________________________________
303.402.0170
www.visionlink.org
_________________________________
People. Tools. Change. Community.

On Fri, 2003-02-14 at 13:55, Jeffrey Bohmer wrote:
> FYI ... PostgreSQL 7.3.x will compile and run on OS X 10.2.  A Fink install isn't necessary unless you want to use an
olderversion of PostgreSQL (even then, there are other options than Fink). 

> >Did an install on OS X 10.2, using Fink with default settings.

You can try one of the packages too. I have had the most success with
the one from www.entropy.ch. It installs in /usr/local/pgsql and creates
a postgres user which means porting over a dump from Linux is as easy as
psql -d dbname -f /User/me/Documents/dump.out

There are issues with locale and the database system being UTF-8 (my
older databases being LATIN1 or LATIN9). But now my development server
runs on Mac OS X. pgaccess works just fine too.

Cheers

Tony Grant

--
www.tgds.net Library management software toolkit,
redhat linux on Sony Vaio C1XD,
Dreamweaver MX with Tomcat and PostgreSQL