All Questions
Tagged with unix-socket postgresql
13 questions
1
vote
0
answers
124
views
confusion in unix socket to use for query in postgresql through php
i try to build website in ubuntu vps using nginx, php7.4, and PostgreSQL.
my goal is using unix socket to communicate through ajax-phpfpm-postgresql to execute query sql in PHP program.
i have change ...
- 91
1
vote
1
answer
894
views
Connecting to PostgreSQL on Google Cloud Platform using Unix Sockets and SQLAlchemy
I am trying to connect to a PostgreSQL database hosted on a Google Cloud Platform instance using unix sockets and the SQLAlchemy library. My database instance is configured to accept unix socket ...
0
votes
1
answer
2k
views
Unix socket connection in postgres docker
I'm using flyway to version the state of my DB and the postgres docker. I'm trying to run a script in /docker-entrypoint-initdb.d/ that I want to run before postgres listens on TCP. The script creates ...
- 181
3
votes
2
answers
9k
views
Connecting DBeaver to remote PostgreSQL DB via Unix socket
I recently installed https://dbeaver.io/ on a Windows PC and wish to access a database on a remote Linux server from it.
My Linux username is my_username and I also have a system user psql_user. I ...
- 26.4k
0
votes
1
answer
5k
views
could not create Unix-domain socket in directory "/var/run/postgresql"
I try to uncomment 'unix_socket_directories = '/var/run/postgresql' in postgresql.conf.
But after doing that, when I try to restart postgresql, I receive
Job for postgresql.service failed because ...
- 1,354
2
votes
1
answer
3k
views
Connect to PostgreSQL-base by Unix-Socket
I use TCP-connection to a remote PostgreSQL using:
DriverManager.getConnection("jdbc:postgresql://remotehost.com/test_psql", "admin", "password");
And it working successfully.
But I cant use UNIX-...
- 1,354
0
votes
1
answer
10k
views
How use /var/run/docker.sock inside running docker-compose container?
I have docker-compose.yml like this:
version: '3'
services:
zabbix-agent:
image: zabbix/zabbix-agent
ports:
- "10050:10050"
- "10051:10051"
volumes:
- /var/run/docker....
- 717
27
votes
1
answer
11k
views
Connect to a database over a unix socket using SQLAlchemy
I'm trying to connect to my Cloud SQL DB using SQLAlchemy from my cloud function but I can't seem to work out the correct connection string.
DATABASE_URL=postgres://$DB_USER:$_DB_PWD@/$DB_NAME?...
- 2,496
8
votes
0
answers
3k
views
Sequelize connect to Postgres over Unix socket
I would like to connect to Postgres using Sequelize over Unix socket (not over localhost).
Postgres is configured to accept Unix socket connections from user pgdba. All works from command line with ...
- 7,773
0
votes
0
answers
748
views
Connect to Postgres over UNIX socket running under root
I'm trying to connect to Postgres in a C program using libpq. When I'm running under my own username (which is the same as the username I've created for my Postgres database) everything is fine. When ...
- 4,155
0
votes
1
answer
1k
views
Unix socket error postgresql 9.4
I just installed postgresql 9.4 on a brand new 15.04 ubuntu install and I'm unable to start the psql server. Every time I try to run sudo -u postgres psql, it gives me the following error:
psql: ...
- 414
8
votes
1
answer
18k
views
psql can connect to a unix domain socket, but py-postgresql with the same parameters gets 'Permission denied'
Problem description:
My system user is milosz, which is mapped to the PostgreSQL user project_great in pg_ident.conf. I am using peer authentication to connect to a PostgreSQL database over a unix ...
- 3,074
0
votes
1
answer
346
views
MediaWiki installation script does not create tables
First - I'm not sure if that's the correct place to post my question hence if I'm wrong doing it here please just let me know and I'll re-post somewhere else.
Also I spent whole weekend trying to find ...
- 1,079