Linked Questions
22 questions linked to/from What is the format for the PostgreSQL connection string / URL?
0
votes
0
answers
70
views
Docker - URL syntax [duplicate]
I came accross a URL syntax in a config file, but I don't get the meaning of some of it:
DATABASE_URL=postgresql://myuser:myuser@db:5432/db_prod
More specifically:
the //myuser:myuser part. This is ...
766
votes
12
answers
893k
views
How do I specify a password to 'psql' non-interactively?
I am trying to automate database creation process with a shell script and one thing I've hit a road block with passing a password to psql.
Here is a bit of code from the shell script:
psql -U $...
662
votes
13
answers
584k
views
Copying PostgreSQL database to another server
I'm looking to copy a production PostgreSQL database to a development server. What's the quickest, easiest way to go about doing this?
14
votes
8
answers
29k
views
Error Relation does not exist
I am getting a [error: relation "causes" does not exist] error from my node app. The relation does exist, I'm not sure what the problem is.
I created the table with
CREATE TABLE causes (
cause_id ...
4
votes
1
answer
12k
views
How to connect to database through JDBC in pgAdmin?
I have database connection settings and pgAdmin (it is all that i have). Can I connect to the database through the pgAdmin to make the necessary changes in the database using these settings? If so, ...
0
votes
1
answer
6k
views
How to let other people in my office access my databse?
I need to share my database from PostgreSQL in my PC with my colleagues in the same office (in the same network). I did some research but I still have some questions regarding it.
A bit background ...
1
vote
1
answer
3k
views
Liquibase can not read jdbc postegresql connection string with username and password
The documentation on the Liquibase website says that I can use the full connection string in the --url parameter such as
jdbc:postgresql://host:port/database?user=user&password=secret
yet when I ...
0
votes
1
answer
2k
views
How to make PostgreSQL database accessible all the time from different computers?
I've created simple PostgreSQL database on my localhost and connected it to my project. I want to pass the project to someone else and share the same database. Also i want my db to run 24h per day and ...
1
vote
3
answers
2k
views
Can't get Django to use Postgres
I am trying to switch a local Django project from the default sqlite3 database to a postgres v.14 database. I've been through several tutorials but nothing seems to work and I'm not sure what I'm ...
0
votes
1
answer
2k
views
trouble getting the right driver for postgres db in eclipse
I am new to enterprise java. I'm trying to get eclipse to connect to a postgres db. I've downloaded postgresql-9.2-1002.jdbc4.jar and postgresql-9.2-1002.jdbc3.jar and put them both in the plugins ...
1
vote
3
answers
1k
views
my postgres is unable to connect ever since heroku did a maintenance update 12 hours ago
anyone facing something similar? sadly I'm on a free plan so I can't open a ticket... does anyone know of a way to restart the service/machine of the DB? maybe that would just solve it...
0
votes
2
answers
611
views
Dockerizing a Rails application with docker-compose
Hi I am trying to adapt my-app to docker.
My app stack is
Ruby 2.4.0
Rails 5.0.1
Postgres 9.5.8
I created a Dockerfile to create an image of my-app
FROM ruby:2.4
RUN apt-get update && apt-...
0
votes
1
answer
1k
views
Docker java.lang.UnsupportedOperationException: Database name postgresql not supported
I created application spring + postgeSQL +docker
application.properties
spring.datasource.password=rfnfdfcbz123!
spring.datasource.username=postgres
spring.datasource.driver-class-name=org....
2
votes
1
answer
708
views
PostgreSQL connection string error on Payload cms
Payload Version
"payload": "^2.0.0"
Node Version
node:18.8-alpine
Next.js Version
"next": "13.5.2"
Bug
When I run yarn build I got this error:
[12:41:39] ERROR (...
0
votes
0
answers
476
views
How to implement a connection Master/slave PostgresSQL using Databases FastAPI
Good day The official documentation uses the line to connect "postgresql://user:password@postgresserver,postgresserver,postgresserver/db".
How to implement a connection Master/slave? if you ...