[:fr]Voici quelques notes sur l’installation d’une base de données PostgreSQL

  • Source : https://www.howtoforge.com/tutorial/postgresql-on-ubuntu-15-04/
  • Etat : Terminé mais a traduire

Mémo PostgreSQL

Logiciel de monitoring : https://github.com/dalibo/temboard

http://www.ixany.org/docs/PostgreSQL_commandes_mysql.html
  • \l = liste des bases
  • \d = liste des tables
  • \dn = Liste des schémas
  • \q = quitter
  • \h = aide
  • \c = Changer la base de donnée courante
  • \q = Quitter
  • \d mytable
    

    \u = Liste des utilisateurs

  • \l = Liste des bases de données
    \dp = Droit utilisateurs
  • \?

Step 1 – Installing PostgreSQL, phpPgAdmin and Apache2

PostgreSQL and PhpPgAdmin are available in the Ubuntu repository. So you just need to install them with the apt command.

sudo apt-get install postgresql postgresql-contrib phppgadmin

The above command will automatically install all packages needed by PostgreSQL, like Apache, PHP etc.

Step 2 – Configure PostgreSQL user

PostgreSQL uses role for user authentication and authorization, it just like Unix-Style permissions. By default, PostgreSQL creates a new user called « postgres » for basic authentication. To use PostgreSQL, you need to login to the « postgres » account, you can do that by typing:

sudo su
su – postgres

Now you can access the PostgreSQL prompt with the command:

psql

And then change the password for postgres role by typing :

\password postgres

ENTER YOUR PASSWORD

Setting User PostgreSQL

Step 3 – Configure Apache2

You need to configure apache for phpPgAdmin. Edit the file /etc/apache2/conf-available/phppgadmin.conf with nano by typing:

cd /etc/apache2/conf-available/
nano phppgadmin.conf

Comment out the line #Require local by adding a # in front of the line and add below the line allow from all so that you can access from your browser.

Allow All User

Step 4 – Configure phpPgAdmin

Edit the file /etc/phppgadmin/config.inc.php by typing :

cd /etc/phppgadmin/
nano config.inc.php

Find the line $conf[‘extra_login_security’] = true; and change the value to false so you can login to phpPgAdmin with user postgres.

Enable Login Web Base

Step 5 – Restart PostgreSQL and Apache2

systemctl restart postgresql
systemctl restart apache2

Step 6 – Testing

Now access phppgadmin with your browser http://yourip/phppgadmin/.

Phppgadmin

and then try login to with user postgres and your password.

Login with Postgres

After logging in you will get this interface:

After Login

Conclusion

PostgreSQL is an advanced object-relational database management system (ORDBMS), it is Open Source and has a large and active Community. PostgreSQL provides the psql command line program as primary front-end, which can be used to enter SQL queries directly, or execute them from a file. phpPgAdmin is a web-based administration tool for PostgreSQL written in PHP that make the administration of Postgres databases easier.[:en]Voici quelques notes sur l’installation d’une base de données PostgreSQL

  • Source : https://www.howtoforge.com/tutorial/postgresql-on-ubuntu-15-04/
  • Etat : Terminé mais a traduire

Step 1 – Installing PostgreSQL, phpPgAdmin and Apache2

PostgreSQL and PhpPgAdmin are available in the Ubuntu repository. So you just need to install them with the apt command.

sudo apt-get install postgresql postgresql-contrib phppgadmin

The above command will automatically install all packages needed by PostgreSQL, like Apache, PHP etc.

Step 2 – Configure PostgreSQL user

PostgreSQL uses role for user authentication and authorization, it just like Unix-Style permissions. By default, PostgreSQL creates a new user called « postgres » for basic authentication. To use PostgreSQL, you need to login to the « postgres » account, you can do that by typing:

sudo su
su – postgres

Now you can access the PostgreSQL prompt with the command:

psql

And then change the password for postgres role by typing :

\password postgres

ENTER YOUR PASSWORD

Setting User PostgreSQL

Step 3 – Configure Apache2

You need to configure apache for phpPgAdmin. Edit the file /etc/apache2/conf-available/phppgadmin.conf with nano by typing:

cd /etc/apache2/conf-available/
nano phppgadmin.conf

Comment out the line #Require local by adding a # in front of the line and add below the line allow from all so that you can access from your browser.

Allow All User

Step 4 – Configure phpPgAdmin

Edit the file /etc/phppgadmin/config.inc.php by typing :

cd /etc/phppgadmin/
nano config.inc.php

Find the line $conf[‘extra_login_security’] = true; and change the value to false so you can login to phpPgAdmin with user postgres.

Enable Login Web Base

Step 5 – Restart PostgreSQL and Apache2

systemctl restart postgresql
systemctl restart apache2

Step 6 – Testing

Now access phppgadmin with your browser http://yourip/phppgadmin/.

Phppgadmin

and then try login to with user postgres and your password.

Login with Postgres

After logging in you will get this interface:

After Login

Conclusion

PostgreSQL is an advanced object-relational database management system (ORDBMS), it is Open Source and has a large and active Community. PostgreSQL provides the psql command line program as primary front-end, which can be used to enter SQL queries directly, or execute them from a file. phpPgAdmin is a web-based administration tool for PostgreSQL written in PHP that make the administration of Postgres databases easier.[:]