postgresql and domain sockets

From: Monique Y. Herman (spam_at_bounceswoosh.org)
Date: 12/15/03

  • Next message: Karsten M. Self: "Re: kernel expolit. is 2.4.18-bf2.4 affected?" 
    To: debian-user@lists.debian.org
Date: Mon, 15 Dec 2003 01:01:26 -0700

    What have I missed?

    ( postgresql 7.3.4-9 on unstable )

    I just installed this package. When I try to do, well, anything, it
    says:

    psql: could not connect to server: No such file or directory
            Is the server running locally and accepting
            connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.0"?

    Here's what *is* in the directory after firing up the app:

    home:~# ls -l /var/run/postgresql/
    total 4.0K
    srwxrwxrwx 1 postgres postgres 0 Dec 15 00:38 .s.PGSQL.5432=
    -rw------- 1 postgres postgres 28 Dec 15 00:38 .s.PGSQL.5432.lock

    I see no .s.PGSQL.0, so I guess the obvious question is, how do I get
    one?

    The comments in pg_hba.conf say:

    # This default configuration allows any local user to connect as himself
    # without a password, either through a Unix socket or through TCP/IP;
    # users on other machines are denied access.

    I poked around in /usr/doc/postgresql as well as in /etc/postgresql ,
    but I seem to have missed something important here. Attempting to run
    initdb states that I already have files in place.

    home:/var/lib/postgres/data/base# ls
    1/ 16975/

    Any help would be greatly appreciated! 

    -- 
monique
-- 
To UNSUBSCRIBE, email to debian-user-request@lists.debian.org 
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
  • Next message: Karsten M. Self: "Re: kernel expolit. is 2.4.18-bf2.4 affected?"

    Relevant Pages