PostgreSql (8.4.1 ok) sous Debian
Aller dans le gestionnaire de Paquet Synaptic et taper Postgresql dans la recherche. Appliquer l'installation ensuite dans la console :
sudo -s -u postgres Password:
ensuite tapez,
psql
maintenant vous devriez avoir afficher ça :
postgres=#
Pour éviter les failles de sécurité il faut créer un nouvel utilisateur ( ne faite pas les commandes avant d'avoir lu jusqu'à rôle) :
postgres=# CREATE USER xxxx ;
et
ALTER USER xxxx WITH ENCRYPTED PASSWORD 'mon_mot_de_passe' ;ou pour taper une seule commande et éviter les problème de cast :
createuser -P ;Pour prendre en compte les changements
/etc/init.d/postgresql-8.3 restart
Les rôles :
tapez :
postgres=# ALTER ROLE WITH CREATEDB;
Pour insataller le client graphique :
sudo apt-get install pgadmin3
qui sera normalement trouvé ici :
Applications -> Programmation -> pgAdminIII
Pour installer le client phppgadmin :
Aller dans le gestionnaire de Paquet Synaptic et taper phppgadmin dans la recherche
puis,
sudo ln -s /usr/share/phppgadmin/ /var/www/
si ça marche pas (mais normalement plus besoin) -> rajouter la ligne "extension=pgsql.so" à la main (après celle sur mysql) dans le fichier "/etc/php5/apache2/php.ini".
enfin,
sudo ln -s /etc/phppgadmin/apache.conf /etc/apache2/conf.d/phppgadmin.conf
n'oubliez de faire un reload de apache..
pour quitter postgres dans la console faite :
postgres=# \q postgres@ubuntu:~$ exit
May 3rd, 2010 - 03:52
Awesome
August 22nd, 2010 - 15:28
nice!
September 20th, 2010 - 12:40
XXodwz hi all ?heey ? http://avtozastivxux.sweb.cz
February 4th, 2011 - 04:49
Postgresql 8 4 1 ok sous debian.. Great!
February 19th, 2011 - 21:37
Postgresql 8 4 1 ok sous debian.. He-he-he
March 9th, 2011 - 22:11
Postgresql 8 4 1 ok sous debian.. I like it
March 16th, 2011 - 04:27
Postgresql 8 4 1 ok sous debian.. Awesome
April 21st, 2011 - 17:11
Hi, i just needed to come here to inform you of a very inexpensive service that posts comments such as this on millions of Wordpress blogs. Just why you might ask, well you might wish to sell a product or service and target webmasters or simply just increase the amount of backlinks your web site has that will improve your Google rankins which will then bring your web site much more visitors and money. Take a fast look at this web site for more information. http://hellomotow.net/backlinks
April 22nd, 2011 - 17:40
Postgresql 8 4 1 ok sous debian.. Great idea
May 16th, 2011 - 19:31
That’s 2 clveer by half and 2×2 clever 4 me. Thanks!
June 2nd, 2011 - 10:09
The pills administered to treat erectile dysfunction work by inhibiting an enzyme in the corpus cavern sum of the penis, the Fosfodiasterasi type 5, thus facilitating erection. In addition to sildenil, substances that were released a few years ago, vardenail and tadalail, came to fill the data. Propecia In the past, most doctors didn’t rate the importance of the female orgasm very highly.
Buy
June 4th, 2011 - 12:24
Postgresql 8 4 1 ok sous debian.. Dandy
July 11th, 2011 - 23:56
Our body, psyche and they are connected to the system of sexual behavior are very complex and interconnected system, and as such is prone to instability on the basis of seemingly minor disturbances. Buying Propecia Online My girlfriend has been on the pill for about three months now and so far she’s never missed a day.
Buy