Category : postgresql

I’m new to Amazon Web Service (AWS). I already created a PostgreSQL from AWS RDS: Endpoint: database-1.XXX.rds.amazonaws.com Port: 5432 Public accessibility: Yes After that, I will push my application that using the database to AWS (maybe deploy to EKS). However, I want to try testing the database server from my local computer first. I haven’t ..

Read more

I am new to Rust, and I wanted to try Diesel with Postgres. I have followed the steps described here: https://diesel.rs/guides/getting-started But unfortunately, when it comes do diesel setup, nothing happens. I receive no output, no error messages, nothing. I have installed diesel_cli with the command install diesel_cli –no-default-features –features postgres , I have Postgres ..

Read more

I’m following the docs on installing and initiating datacube: https://datacube-core.readthedocs.io/en/latest/ops/db_setup.html I’ve gotten to the step where it says After installing, launch PostgreSQLPortable.exe (and place a shortcut in the windows Startup menu). To prepare the database for first use, enter the following commands in the PostgrSQL Portable window, substituting “u12345” with your windows login user-ID: create ..

Read more

I simply use the following command to get backup of my PostgreSql database in a Docker container: cmd /c "docker exec -t postgres-container pg_dumpall -c -U postgres > C:postgresqlbackupdump_`date +%d-%m-%Y’_’%H_%M_%S`.sql" However, I cannot add the date values to the backup file created via this script. I have tried at least 15 different versions of the ..

Read more

I simply use the following command to get backup of my PostgreSql database in a Docker container: cmd /c "docker exec -t postgres-container pg_dumpall -c -U postgres > C:postgresqlbackupdump_`date +%d-%m-%Y’_’%H_%M_%S`.sql" However, I cannot add the date values to the backup file created via this script. I have tried at least 15 different versions of the ..

Read more