Hi there, My mistake. I had edited the postgresql.conf and enabled the following directive:
unix_socket_directory = '/sw/tmp' Just commented (I think the original file is commented but dont remember). Restarted and now I got in in full glory =) Thanks Alexander and Benjamin, Eriksen Costa On Thu, Apr 9, 2009 at 9:57 AM, Benjamin Reed <[email protected]> wrote: > And is it running? > > Have you enabled it on startup or started it manually? > > Sin:~ ranger$ sudo -u postgres /sw/bin/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"? > Sin:~ ranger$ ps auxwww > Sin:~ ranger$ sudo /sw/bin/pgsql.sh start > pg_ctl-8.3: another server might be running; trying to start server anyway > server starting > Sin:~ ranger$ sudo -u postgres /sw/bin/psql > Welcome to psql 8.3.5, the PostgreSQL interactive terminal. > > Type: \copyright for distribution terms > \h for help with SQL commands > \? for help with psql commands > \g or terminate with semicolon to execute query > \q to quit > > postgres=# > > > On Thu, Apr 9, 2009 at 8:22 AM, Eriksen Costa <[email protected]> wrote: >> I got the same result: >> >> $ sudo -u postgres /sw/bin/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"? >> >> I will uninstall it (it's the binary version), selfupdate, install >> from source and try again. >> >> Thanks. >> >> On Wed, Apr 8, 2009 at 10:32 AM, Benjamin Reed <[email protected]> wrote: >>> sudo probably loses your PATH, so you'd need to do: >>> >>> sudo -u postgres /sw/bin/psql >>> >>> On Wed, Apr 8, 2009 at 9:00 AM, Alexander Hansen >>> <[email protected]> wrote: >>>> That's right: we don't create postgres with a home directory. >>>> >>>> I don't actually use it directly myself, so I don't know that much about >>>> it. I'm forwarding you on to the maintainer. >>>> >>>> >>>> >>>> Eriksen Costa wrote: >>>>> Hi Alexander, >>>>> >>>>> It's running. I checked with ps aux | grep postgres and also can >>>>> access througth pgAdmin. >>>>> >>>>> Do you can get in psql? I can't su - postgres since this user seem not >>>>> have a home directory (I get a warn about something to /dev/null, >>>>> can't remember because now I am not on my mac). >>>>> >>>>> >>>>> Thanks, >>>>> Eriksen >>>>> >>>>> On Wed, Apr 8, 2009 at 7:58 AM, Alexander Hansen >>>>> <[email protected]> wrote: >>>>> >>>>>> Eriksen Costa wrote: >>>>>> >>>>>>> Hi there, >>>>>>> >>>>>>> I am trying to get in psql. I've installed postgresql82, running ok (I >>>>>>> can access throught pgAdmin). The only thing I miss is the psql >>>>>>> access: >>>>>>> >>>>>>> $ sudo -u postgres psql -U postgres >>>>>>> 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"? >>>>>>> >>>>>>> Tried this (same question but postgresql80): >>>>>>> http://www.mail-archive.com/[email protected]/msg19954.html >>>>>>> >>>>>>> The service is started with daemonic. >>>>>>> >>>>>>> Thanks, >>>>>>> Eriksen >>>>>>> >>>>>>> >>>>>>> >>>>>> But is it actually running? daemonic only sets it up to run at boot >>>>>> time, and so the daemon will only be running if you've rebooted or >>>>>> started it yourself. >>>>>> >>>>>> -- >>>>>> Alexander Hansen >>>>>> Fink User Liaison >>>>>> >>>>>> >>>>>> >>>> >>>> >>>> -- >>>> Alexander Hansen >>>> Fink User Liaison >>>> >>>> >>> >>> >>> >>> -- >>> Benjamin Reed a.k.a. Ranger Rick >>> Fink, KDE, and Mac OS X development >>> >>> Blog: http://www.raccoonfink.com/ >>> Music: http://music.raccoonfink.com/ >>> >> > > > > -- > Benjamin Reed a.k.a. Ranger Rick > Fink, KDE, and Mac OS X development > > Blog: http://www.raccoonfink.com/ > Music: http://music.raccoonfink.com/ > ------------------------------------------------------------------------------ This SF.net email is sponsored by: High Quality Requirements in a Collaborative Environment. Download a free trial of Rational Requirements Composer Now! http://p.sf.net/sfu/www-ibm-com _______________________________________________ Fink-beginners mailing list [email protected] http://news.gmane.org/gmane.os.apple.fink.beginners
