Hi friends.
I'm on osX 10.8.5 and cannot seem to get postgreSQL running properly, which may
be due to having previously installed with macports.
Here's the story:
$ postgres
postgres cannot access the server configuration file
"/sw/var/postgresql-9.3/data/
$ sudo -u postgres psql
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
macbookpro1:postgresql-9.3 mikekilmer$ sudo tail -f
/sw/var/postgresql-9.3/pgsql.log
dyld: DYLD_ environment variables being ignored because main executable
(/usr/bin/sudo) is setuid or setgid
Password:
LOG: autovacuum launcher started
LOG: received fast shutdown request
LOG: aborting any active transactions
LOG: autovacuum launcher shutting down
LOG: shutting down
LOG: database system is shut down
postgres cannot access the server configuration file
"/sw/var/postgresql-9.3/postgresql.conf": No such file or directory
postgres cannot access the server configuration file
"/sw/var/postgresql-9.3/postgresql.conf": No such file or directory
LOG: could not open configuration file
"/sw/var/postgresql-9.3/postgresql.conf": Permission denied
FATAL: configuration file "/sw/var/postgresql-9.3/postgresql.conf" contains
errors
root# su postgres
shell-init: error retrieving current directory: getcwd: cannot access parent
directories: Permission denied
bash-3.2$ pg_ctl -D /sw/var/postgresql-9.3/ -l /sw/var/log/pgsql-9.3.log start
could not identify current directory: Permission denied
could not identify current directory: Permission denied
could not identify current directory: Permission denied
The program "postgres" is needed by pg_ctl but was not found in the
same directory as "pg_ctl".
Check your installation.
bash-3.2$ pwd
pwd: error retrieving current directory: getcwd: cannot access parent
directories: Permission denied
bash-3.2$ cd /
chdir: error retrieving current directory: getcwd: cannot access parent
directories: Permission denied
bash-3.2$ exit
$grep postgres /etc/passwd
_postgres:*:216:216:PostgreSQL Server:/var/empty:/usr/bin/false
root# su postgres
bash-3.2$ pwd
/etc
bash-3.2$ pg_ctl -D /sw/var/postgresql-9.3/ -l /sw/var/log/pgsql-9.3.log start
server starting
bash-3.2$ sh: /sw/var/log/pgsql-9.3.log: Permission denied
macbookpro1:etc root# open "/System/Library/CoreServices/Directory Utility.app"
Shows NFSHomeDirectory of PostgreSQL as /Library/PostgreSQL/9.2, which doesn't
exist.
And for PostgreSQL Server it's: /var/empty
A friend who is experienced with Postgres on Debian says permissions are all
messed up and recommended abandoning this route and using a virtual box, but
I'd like to get this working.
Hoping you might be able to offer some insight? I'd like to avoid a clean OS
install if possible.
Thanks a bunch and have a great one.
Mike
Michael Kilmer
Media Zoo
Music, Theater, Multimedia and Web Development
[email protected]
201-679-4168
www.mZoo.org
www.madhappy.com
www.explorepensacolahistory.com
www.rivka.com
------------------------------------------------------------------------------
_______________________________________________
Fink-beginners mailing list
[email protected]
List archive:
http://news.gmane.org/gmane.os.apple.fink.beginners
Subscription management:
https://lists.sourceforge.net/lists/listinfo/fink-beginners
