Le blog de Jean David TECHER, un Réunionnais à Saint-Priest/Lyon

Aller au contenu | Aller au menu | Aller à la recherche


< 1 2 3 4 >

vendredi 27 décembre 2013

PostgreSQL 9.1 and pgsql_fdw

  • Get the sources
     git clone git://git.code.sf.net/p/interdbconnect/code interdbconnect-code
Tips ti know
  • If you got this error
    biotricks=# ALTER SERVER remote_biopacs_production VERSION '1.0'  OPTIONS ( host '10.1.0.244', port '5433', dbname 'biopacs_production');
    ERROR:  option "host" provided more than once
    then use set
    biotricks=# ALTER SERVER remote_biopacs_production   OPTIONS ( SET host '10.1.0.244');
    ALTER SERVER
    biotricks=# ALTER SERVER remote_biopacs_production   OPTIONS ( SET port '5433');
    ALTER SERVER
    biotricks=# ALTER SERVER remote_biopacs_production   OPTIONS ( SET dbname 'biopacs_production' );
    ALTER SERVER

vendredi 5 juillet 2013

PPAS 9.1: Download postgresplusas-9.1.9.16-1-linux-x64.run

Download it manually
wget "http://sbp.enterprisedb.com/getfile.jsp?fileid=2907" -O postgresplusas-9.1.9.16-1-linux-x64.run

samedi 20 avril 2013

Install PostgreSQL Plus Advanced Server 9.1 without subscribing....

1. Install PPAS 9.1 64-Bit on Linux Mint 14 without credentials

If you don't have a X server (terminal only) then use the option --mode text

Now reboot your system or remove the iptables rule.

2. Stackbuilder hangs asking for credentials...Install a first package manually

3. Stackbuilder hangs asking for credential...Install other packages manually

dimanche 14 octobre 2012

EnterpriseDB PPAS 9.1.2.2 and 9.1.6.10-1

wget -q  http://get.enterprisedb.com/ga/ppasmeta-9.1.2.2-linux-x64.tar.gz
wget -q http://sbp.enterprisedb.com/getfile.jsp?fileid=2558 -O postgresplusas-9.1.6.10-1-linux-x64.run