1 / 6

APNEE-TU DATABASES

APNEE-TU DATABASES. Instalation Problems Solutions. INSTALATION I. We install Postgresql packages with rpm utility in a Linux OS Red-Hat 7.2 We create a new user to administrate databases( typical name for user postgres) We create the database cluster with the instruction

min
Download Presentation

APNEE-TU DATABASES

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. APNEE-TU DATABASES • Instalation • Problems • Solutions

  2. INSTALATION I • We install Postgresql packages with rpm utility in a Linux OS Red-Hat 7.2 • We create a new user to administrate databases( typical name for user postgres) • We create the database cluster with the instruction initdb –D /usr/local/pgsql/data

  3. INSTALATION II • We start postmaster process postmaster –D /usr/local/pgsql/data –i > logfile & • We create a empty databases one for andalucia and one for canarias createdb canarias createdb andalucia • We execute the script built by SICE that create the tables with psql postgres client.

  4. Problems • New initial data for the databases • Database schema doesn’t support for more than one lenguage

  5. Solutions I • Problem: new initial data for the database • We modify the script that entries the initial data and execute it with psql postgres client

  6. Solutions II • Problem: Database schema doesn’t support more than one lenguage. Solutions: two possible solutions 1.- We can modify the database to let a user to choose spanish or english (this require to change the web pages’s java classes and the database. 2.- We can create a database in english and one in spanish. More easy to do.Don´t need to know torque , turbine and velocity.

More Related