Re: [Fink-beginners] Any way to get in psql with postgresql82

2009-04-10 Thread Eriksen Costa
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

Re: [Fink-beginners] Any way to get in psql with postgresql82

2009-04-09 Thread Benjamin Reed
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"? Si

Re: [Fink-beginners] Any way to get in psql with postgresql82

2009-04-09 Thread Eriksen Costa
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 fr

Re: [Fink-beginners] Any way to get in psql with postgresql82

2009-04-08 Thread Benjamin Reed
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 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 fo

Re: [Fink-beginners] Any way to get in psql with postgresql82

2009-04-08 Thread Alexander Hansen
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 > acce

Re: [Fink-beginners] Any way to get in psql with postgresql82

2009-04-08 Thread Alexander Hansen
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 t

[Fink-beginners] Any way to get in psql with postgresql82

2009-04-07 Thread Eriksen Costa
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 accep