From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | Ali Aktar <aktarali(at)gmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: PgBouncer error - 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.6432"? |
Date: | 2015-07-06 17:42:14 |
Message-ID: | CAKFQuwYAFDhHaepy3X3MACXdaa5ZAMPpVab-PJgh3EJiY3yz8g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Cursory observations below...
On Mon, Jul 6, 2015 at 11:04 AM, Ali Aktar <aktarali(at)gmail(dot)com> wrote:
> Hi Guys;
>
> Can I please get some assistance:
>
> I have postgres server running on the localhost:
> -bash-4.2$ telnet localhost 5432
> Trying ::1...
> Connected to localhost.
> Escape character is '^]'.
>
> -bash-4.2$ psql -U postgres
> psql (9.4.4)
> Type "help" for help.
>
You are connecting to a unix socket and not a TCP/IP port...
> postgres=# \list
> List of databases
> Name | Owner | Encoding | Collate | Ctype | Access
> privileges
>
> -----------+----------+----------+-------------+-------------+-----------------------
> postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
> template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
> +
> | | | | |
> postgres=CTc/postgres
> template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
> +
> | | | | |
> postgres=CTc/postgres
> test | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
> (4 rows)
>
> pgbouncer.ini:
> [databases]
> template1 = host=127.0.0.1 port=5432 dbname=template1
>
haven't proved PostgreSQL is listening on 127.0.0.1:5432 yet; only proved
it is listing on the local unix socket...
[pgbouncer]
> listen_port = 6432
> listen_addr = 127.0.0.1
> auth_type = trust
> auth_file = /etc/pgbouncer/userslist.txt
> logfile = /var/log/pgbouncer.log
> pidfile = /var/run/pgbouncer/pgbouncer.pid
> admin_users = postgres
>
> -bash-4.2$ telnet localhost 6432
> Trying ::1...
> telnet: connect to address ::1: Connection refused
> Trying 127.0.0.1...
> Connected to localhost.
> Escape character is '^]'.
>
Listening on a tcp/ip port...(ip4 only)
> 2015-07-06 15:02:00.233 11993 DEBUG C-0x2549910: (nodb)/(nouser)@
> 127.0.0.1:44274 P: got connection: 127.0.0.1:44274 -> 127.0.0.1:6432
>
> But here is the weird thing:
> When I try to run:
> -bash-4.2$ psql -p 6432 pgbouncer
>
...but attempting to connect to a unix socket
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.6432"?
>
> Please tell me what Im doing wrong?
>
Try specifying "--host=localhost" or "--host=127.0.0.1"
> And another question, if I want to specify remote postgres DB's in the
> .ini file. How do I do that?
>
>
[databases]
name = host=remote_ip_address etc...
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Paul Jungwirth | 2015-07-06 17:58:12 | Re: Average New Users Per DOW |
Previous Message | Robert DiFalco | 2015-07-06 17:41:10 | Average New Users Per DOW |