Tags » PostgreSQL

How to setup Apache to work with Ruby on Rails, Passenger Phusion and also to setup Postgresql database to work with them

                                                                     
                                                                     
                                                                     
                                             
yum update
to update the server

yum install mod_ssl
yum install ruby  ruby-devel
yum install make
yum install gcc
yum install curl-devel
yum install openssl-devel
yum install httpd-devel
yum install gcc-c++
yum install zlib-devel

yum install rubygems


gem install passenger

download and installe NODE.js from  nodejs.org. 397 more words
Passenger Phusion

PostgreSQL 9.3 : Create dblink

After read this post from Mr. solaimurugan.v, I wanna add some detail only on creating dblink :

  1. First change your pg_hba.conf : host all all 127.0.0.1/32 trust…
  2. 47 more words
Daily Snippet

Execute this commands as postgres (root user on the DB), in order to change the ownership of a table:

ALTER table  owner to ;
 6 more words
How To

Execute these commands as postgres (root user on the DB).

Privilege to be granted: All
Object Affected: Tables of a Schema

GRANT ALL ON ALL TABLES IN SCHEMA  to ;
… 27 more words
How To

Install Postgres On Ubuntu

Start with Installing PostgreSql
sudo apt-get install postgresql postgresql-contrib

next to do : Login with admin user    sudo -u postgres psql

\du : to check user available in postgressql… 48 more words

Home Page