Tags » PostgreSQL

PostgreSQL - Faire de la réplication entre 2 serveurs

Divers : 

Serveur maitre : 192.168.250.111

Serveur esclave : 192.168.250.112

/!\ Dans les fichiers supprimer le “#” pour décommenter la ligne

Pré requis :

Arrêter le service postgresql sur les 2 serveurs… 180 more words

PostgreSQL

Speeding up Ruby on Rails

…with less sql queries

A Rails application will make a large number of sql queries per page unless steps are taken to mitigate this. This is bad because it degrades the performance of your app, affects your ability to scale, and will cost you money. 251 more words

Rails 4.1

INSTALLATION OF POSTGRESQL 9.3.2 ON LINUX

About PostgreSQL
PostgreSQL is oracle like database and worlds most advanced open source RDBMS.this is widely used for transaction reporting or BI purposes throughout the world. 402 more words

Enterprisedb

My PostgresOpen schedule

We had so many good submissions for Postgres Open this year, we had to make some very difficult choices. While I haven’t quite achieved Dan Langille’s (of… 359 more words

PostgreSQL

Local PostgreSQL Setup

Shell configuration (~/.bashrc, ~/.zshrc, …)

export PGDATA=~/anywhere/postgresql_data # PostgreSQL data directory
export PGHOST="/tmp"
alias pgstart="pg_ctl start"
alias pgstop="pg_ctl stop"

Initial setup

$ initdb -A md5 -E UTF8 -U $USER -W

$ vim $PGDATA/postgresql.conf

listen_addresses = 'localhost'

$ vim $PGDATA/pg_hba.conf

# TYPE DATABASE USER ADDRESS METHOD
# ADD THE FOLLOWING LINE AND REPLACE 'YOUR_USER' by $USER
local all YOUR_USER trust
… 45 more words
Setup

PostgreSQL - Set and Get Timezone

There is a timezone configuration on PostgreSQL server. If you want to change the default globally, you can edit the postgresql.conf. On Ubuntu, it is located at… 105 more words

Ubuntu

Configuring Replicated vPostgres for vCAC 6.x

This is the second in my series for building a fully distributed vCAC deployment. In this part, we’re building the vPostgres database server with replication for use with vCAC 6.x. 1,246 more words

VCloud Suite