PostgreSQL Quick Start
How to install and configure the PostgreSQL server in Ubuntu
PostgreSQL is a powerful relational database management system, which is released in accordance with the BSD license [1. PostgreSQL contains many advanced features with good performance and good applicability.
PostgreSQL is bound to many programming languages, such as C, C ++,
Python, Java, PHP, Ruby, etc. It can operate many things, from simple web applications to a large database with millions of records.
Run the following command to install PostgreSQL:
sudo apt-get install postgresql
Pgadmin III is a convenient PostgreSQL graphics client. It is suitable for beginners. You can run the following command on the terminal to install pgadmin III:
sudo apt-get install pgadmin3
You can also install these packages through the system> System Management> xinlide Package Manager.
Basic server settings
Sudo/etc/init. d/postgresql-8.4 start (PostgreSQL installed in 10.04 is 8.4 by default, if it is 10.10, no version is required)
sudo /etc/init.d/postgresql-8.4 stop
After the installation is complete, we need to change the password of Postgres user, otherwise we will not be able to use this database server. Run the Psql command as the Postgres user. Enter the following in the terminal:
sudo su postgres -c psql template1
At this time, a new prompt will appear. Enter the following two commands and replace them with the new password <*** password ***>:
ALTER USER postgres WITH PASSWORD ' <***password***> ';
Set the Postgres User Password
sudo passwd postgres
Then enter your password.
Create a database
Create the first database and name it "mydb". Enter:
Transferred to Postgres user.
An error will be reported when using this method.
sudo su postgres -c createdb mydb
After the user logs in to Postgres, execute
Use the pgadmin iii gui client
To understand what PostgreSQL can do, you must first learn to use a GUI client and enter:
You are now on the main interface of pgadmin III and click "add database connection" (in the upper left corner ). In the displayed dialog box, enter the address 127.0.0.1, server description, default database "mydb", and your password.
Through this graphic interface, you can create databases, tables, and other objects, query databases, add data, and execute SQL statements. Connect with pgadmin 3
Manage database servers
Manage Users and permissions
PostgreSQL does not have a simple way to manage users. You must Edit
/etc/postgres/pg_hba.confAnd modify its default configuration (the security of the default configuration is very high), you want
postgresTo manage its users (not related to system users), you need to add the following lines:
8<-------------------------------------------# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD# rezo localhost all all 10.0.0.0 255.255.255.0 password8<-------------------------------------------
It means to use your local network (replace 10.0.0.0/24 with your local network !), Postgres users can connect to the database using the traditional "User Name + password" method.
To create a database and create a user with all permissions for the database, run the following command:
sudo su postgres -c createuser -D -A -P myusersudo su postgres -c createdb -O myuser mydb
The first command is to create a new user. This user has no permission to create a database (-D), and has no permission to create a new user (-). When creating a user, you will be prompted to enter the password. The second command is to create a database'Mydb,'Myuser'As its owner.
This small example can meet most of your needs. For more information, see the help documentation or online documentation.
If you are not familiar with the SQL language, you may want to study this powerful language in depth, although some simple PostgreSQL applications may not use this knowledge (such as a simple Django
The PostgreSQL official website contains a lot of information about how to use this database.