Restore a postgres backup file using the command line?

I'm new to postgresql, and locally, I use pgadmin3. On the remote server, however, I have no such luxury. I've already created the backup of the database and copied it over, but, is there a way...

How to import CSV file data into a PostgreSQL table?

How can I write a stored procedure that imports data from a CSV file and populates the table?

Copy a few of the columns of a csv file into a table

I have a CSV file with 10 columns. After creating a PostgreSQL table with 4 columns, I want to copy some of 10 columns into the table. the columns of my CSV table are like: x1 x2 x3 x4 x5 x6 x7 x8...

How to use php artisan migrate command of Laravel4 in Heroku?

I am suing Heroku dev plan for creating database using PostgreSQL. Database is created in Heroku. After running heroku pg:info command $ heroku pg:info === HEROKU_POSTGRESQL_XXX_URL Plan: ...

Can I automatically create a table in PostgreSQL from a csv file with headers?

I'm running PostgreSQL 9.2.6 on OS X 10.6.8. I would like to import data from a CSV file with column headers into a database. I can do this with the COPY statement, but only if I first manually...

insert additional column values(not available in file) in postgresql table using COPY

Table columns: col1, col2, col3, fname, lname CSV file contains values like: col1,col2,col3 val1,val2,val3 val1,val2,val3 I want to add data from csv along with additional data i.e....

javax.el.ELException: Provider com.sun.el.ExpressionFactoryImpl not found

Despite a lot of problem solutions I have stuck on the problem with ELException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'tilesConfigurer' defined in...

Sonarqube integration and startSonar.bat failed Error(0x2)

Yesterday I started a new Unreal Engine Project on Visual Studio Team Service, I decided to learn by myself the art of videogames programming. Anyway the best thing I wanted to use for this...

Where is the Postgres username/password being created in this Dockerfile?

So I was following this tutorial: https://realpython.com/blog/python/django-development-with-docker-compose-and-machine/ I have everything up and running, however theres a few things going on that...

PostgreSQL COPY FROM PROGRAM using ImageMagick

I have 1000 images, and thanks to ImageMagick I can retrieve a lot of information regarding an image by writing "identify -verbose [PATH OF IMAGE]" in the cmd. I installed ImageMagick with 'legacy...

Importing zipped CSV file into PostgreSQL

I have a big compressed csv file (25gb) and I want to import it into PostgreSQL 9.5 version. Is there any fast way to import zip or qzip file into postgres without extracting the file?

PostgreSQL data provider missing from wizard in Visual Studio 2015

I've spent a day trying to migrate an Entity Framework 6 SQL Server CE to PostgreSQL. I've copied the database over fine, but I can't seem to get the data provider to work. Firstly I tried the...

Postgres SQL - error: must be superuser to copy to or from a file

I have copied function(from one of the webportal and modified accordingly) to copy data from csv file to table. create or replace function public.load_csv_file ( target_table text, csv_path...

Postgresql COPY empty string as NULL not work

I have a CSV file with some integer column, now it 's saved as "" (empty string). I want to COPY them to a table as NULL value. With JAVA code, I have try these: String sql = "COPY " + tableName +...

Relation does not exist error in Django

I know there are many questions about this problem, I looked through the solutions and unfortunately none of them worked for me. I created a new app called "usermanagement", and added a model to...

Docker: Empty response from server

I am having trouble to connect docker container, server returns empty response however the configuration seems to be correct. When i use docker-compose up command everything seems fine and working...

How run composer install from dockerfile in php container

Good day I have php container which seting up in Dockerfile I am trying to run composer install with this command WORKDIR '/app' RUN curl -sS https://getcomposer.org/installer | \ php...

WaitForFirstConsumer PersistentVolumeClaim waiting for first consumer to be created before binding

I setup a new k8s in a single node, which is tainted. But the PersistentVolume can not be created successfully, when I am trying to create a simple PostgreSQL. There is some detail information...

Docker Ruby SSL_connect returned=1 errno=0 state=error: wrong signature type

I have ruby 2.7 in a Docker container running a rather simple HTTP client using Faraday: conn = Faraday.new("https://jinio.com.ph") conn.post("/tracker", {p: @code}.to_json, {"Content-Type" =>...

What is the best way to use Docker for Entity Framework core update with Postgres?

Background I am building an API to hold user info in a Postgres DB, using dotnet core and EF core. I do not think it has any impact on the question following but for a background explanation, I am...

Airflow: DockerOperator fails with Permission Denied error

I'm trying to run a docker container via Airflow but getting Permission Denied errors. I have seen a few related posts and some people seem to have solved it via sudo chmod 777...

How to get rid of cryptography build error?

I am trying to build a dockerfile but the problem is when it trying to build specifically cryptography is not building. MY Dockerfile FROM python:3.7-alpine ENV PYTHONUNBUFFERED 1 RUN apk update...

Docker: Cannot use ImageField because Pillow is not installed

I have a problem with my Docker. In my dev version of Docker it's working but when I've created prod version it says that Pillow is not installed. I've been searching for solution since yesterday,...

Running Sequelize Migration in Docker Compose

I am trying to figure out how I can run a Sequelize database migration with my docker compose set up and so far have failed with two different approaches. The first attempt I tried to run npx...

PostgreSQL 13 + Python 3.7.9 + plpython3u: 'psql: server closed the connection unexepectedly.' + 'The application has lost the database connection.'

I have added all of the details I could find, with all of the links, and there is no way to get plpython3u to work on Windows in PostgreSQL 13, it seems. Better do not read through this long...

docker-compose build -> many "PermissionError: [Errno 13] Permission denied" error's

I am trying to run an instance of a docker container (django project) on my synology nas DS220+. After: docker-compose build I get this error: traceback (most recent call last): File...

DockerFile in ./docker/8.0 vs DockerFile in ./vendor/laravel/sail/runtimes/8.0

Good day, I got stumbled to a peculiar issue. I'm a newbie in Laravel Sail with Docker. When I change the laravel service context to point to DockerFile in ./docker/8.0 which I used to add some...

Running local ansible to create local docker Image

Directory Structure build ├── docker-compose.dev.yml ├── playbooks │   ├── deploy-deps.yml │   └── setup-local-registry.yml ├── postgres │   └──...

Wrong Python version running in Docker

No matter what I try, my Docker container is using Python 3.10 rather than what I need and specify, which is Python 3.7. How can I force Docker to use 3.7 for a specific image/container? I'm a...

How to COPY into one PostgreSQL table in parallel without lock?

As I see in pg_stat_activiry, only one of COPY command executes at once. Other queries are in Lock state as I see in wait_event_type column. How can I run several COPY mytable FROM STDIN in...