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
