Tags » PostgreSQL

Postgresql Basic Commands

Login to postgresql:
psql -d mydb -U myuser -W
psql -h myhost -d mydb -U myuser -W
psql -U myuser -h myhost “dbname=mydb sslmode=require” # ssl connection… 366 more words


How to install Postgresql 9.2 and enable Remote Connection

Installing Postgresql 9.2 zip file and Remote Configuration

Requirement for Postgresql Installation

1. Microsoft Visual C++ 2008 redisbutable

2. postgresql-9.2.9-1-windows-binaries.zip

Setup the PostgreSQL

1. Unzip the postgresql-9.2.9-1-windows-binaries.zip file in the C:\Program Files directory. 229 more words

Windows Server

EnterpriseDB Webinar: Using EDB Postgres with Containers

Date: Wednesday, February 10th, 2016
Presenter: Phil Vacca, Senior Database Consultant, EnterpriseDB
Times: 8:00am and 1:00pm Eastern Standard US Time
Duration: 1 Hour

The use of containers to simplify and speed the deployment and development of applications is taking off. 135 more words


Wildfly - PostgreSQL Driver Install

  1. Environnement:
    • Wildfly 10
    • Java JDK 8.xx
    • Postgresql 9.4
  2. Download Postgresql driver. See: https://jdbc.postgresql.org/download.html
  3. Run ./jboss-cli.sh from wildfly/bin
  4. From jboss-cli command-line:
    #add module
    module add --name=org.postgres --resources=/tmp/postgresql-9.4.1207.jar --dependencies=javax.api,javax.transaction.api
    # add driver to subsystem datasources
    # declare datasource: here: server is on localhost, and db is postgres_db
    # username is postgres and password is posgres
    data-source add --jndi-name=java:jboss/datasources/PostGreDS --name=PostgrePool --connection-url=jdbc:postgresql://localhost/postgres_db --driver-name=postgres --user-name=postgres --password=postgres

List and get postgresql views definitions

Get a schema views list

select schemaname,viewname,viewowner from pg_views where schemaname = 'public';

Get the definition of these views

select definition from pg_views where schemaname = 'public';
125 more words


RDS OS update

I’ve some more info for the AWS RDS OS update I mentioned last week.

The announcement states that this update will take an outage. In my experience, it’ll be the usual failover time for a Multi-AZ instance (a minute or so), and 8-10 minutes for no-Multi-AZ instances. 396 more words


Let's select!

The select statement is a statement that’s used for nearly everything in a database. Luckily its also the simplest statement.

A select statement is as simple as clicking this select script. 138 more words