Tags » PostgreSQL

To list all the indexes of a database

When we create a pk in PostgreSQL, an index named table_name_pkey is automatically created.

The following script gives all indexes, those created by the pk’s and the others. 209 more words


PostgreSQL Redeploys with Juju Storage

New features and improvements to Juju 2.3’s storage feature provide new mechanisms for server migrations. A PostgreSQL deployment can be made with the data stored on an attached volume, such as a Ceph mount or Amazon EBS volume. 1,074 more words


AWS Kinesis Stream In Detail Review

I am new to AWS. I have implemented some functionalities in aws using java. My requirement is to insert a csv of 50MB to RDS PostgreSQL instance at a time. 216 more words


Servicio API REst con Spring Data

Creamos un Proyecto Nuevo en https://start.spring.io/

Elegiremos Maven para la creación del ejemplo.

En la sección SQL elegimos JPA y PostgreSQL.

En la sección WEB elegimos Web y Rest Repositories… 984 more words

How to safely delete records ?

To collect accurate data is expensive !

To structure data is very expensive !

To record accurate structured data is very very expensive !

Then… 575 more words


PostgreSQL basics

To login to prompt

#psql -h myhost -d mydb -U myuser -W

To create user

psql#CREATE USER anoop WITH password ‘tmppassword’;

To create database

 CREATE DATABASE db1 WITH OWNER anoop; 15 more words


Trying to connect to database using Postgres but it isn't able to translate the address on Amazon server to Amazon database

Getting this error when trying to connect to a database on Amazon. This is from an Amazon server.

psycopg2.OperationalError: could not translate host name “domain-stg-postgres.caxdkvuertc9.us-west-1.rds.amazonaws.com/projectname_dev” to address: Name or service not known…

68 more words