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"? - Mailing list pgsql-general

-bash-4.2$ psql -U postgres 

psql (9.4.4)

Type "help" for help.

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:

But here is the weird thing:

When I try to run:

Please tell me what Im doing wrong?

And another question, if I want to specify remote postgres DB's in the .ini file. How do I do that?

Thanks

Ali.

You should specify pgbouncer with “-d” option:

-bash-4.2$ psql -p 6432 –d pgbouncer

Regards,

Igor Neyman