I installed postgresql via homebrew on my 10.7.3. The install seemed successful and I was able to start up the server. However when I try to access psql I get the following error:
psql: FATAL: role "larson" does not exist
In this case larson is my username. Does anybody know what the issue is and what I can do to address it?
What's the location of the sysctl.conf file on lion? In Snow Leopard it was in /etc/sysctl.conf but now that folder doesn't contain it anymore. Searching for the file in spotlight yields no results.
Have the shared memory settings been moved to a different conf file? What is it's name?
EDIT
I am trying to modify the kernel shared memory settings of the machine. When I didn't find the sysctl.conf file in the right place, I created my own with the recommended settings and put into /etc directory. However running sysctl -a still shows me that the old memory settings are in place.
How do I go about modifying these settings on a lion install?
I am trying to setup pg on a relatively clean lion install and it's not being successful.
First I successfully installed homebrew, and installed postgresql without any errors.
Then I tried to run a rails app, got an error. Tried running this script: http://nextmarvel.net/blog/2011/09/brew-install-postgresql-on-os-x-lion/
in order to hide the default system postgres install, but now I am getting the following error:
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"?
When I try to run the postgres script in the bin directory I get the following error:
larson:~ larson$ /usr/local/Cellar/postgresql/9.1.3/bin/postgres ; exit;
postgres does not know where to find the server configuration file.
You must specify the --config-file or -D invocation option or set the PGDATA environment variable.
logout
It's clear that postgres cannot start because it is not configured correctly. Does anybody have any advice on the proper way to configure it so it starts?
I tried to install the taps gem on my rvm, but got the following result:
larson:~ larson$ rvm gem install taps
Successfully installed taps-0.3.23
1 gem installed
Installing ri documentation for taps-0.3.23...
Installing RDoc documentation for taps-0.3.23...
larson:~ larson$ ruby -S gem which taps
ERROR: Can't find ruby library file or shared library taps
The strange thing is that taps still appears in my gem list. What does this error mean and will it prevent me from using Heroku's db:push commands?