Shulou(Shulou.com)06/01 Report--

This article introduces the relevant knowledge of "how to install the postgresql8.3 version of Ubuntu9.10". Many people will encounter such a dilemma in the operation of actual cases, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Ubuntu9.10 after a long period of development, here I would like to publish a personal understanding, here is to talk about the art Ubuntu9.10. Installation of Ubuntu9.10 postgresql

I personally tested the postgresql version 8.3 U installed on Ubuntu9.10. Depressed for several days, finally ok. Sudo apt-get install postgresql-8.3 postgresql-client-8.3 postgresql-contrib-8.3 and then add to / etc/profile

Export POSTGRES_HOME=/usr/lib/postgresql/8.3 export PGLIB=$POSTGRES_HOME/lib export PGDATA=$POSTGRES_HOME/database export MANPATH=$MANPATH:$POSTGRES_HOME/man export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$PGLIB

Ubuntu9.10 starts the database engine at the terminal source / etc/profile and then switches to the postgres user sudo su postgres. / initdb-D $PGDATA starts the database pg_ctl start-l logfile will start the server in the background and put the output in the specified log file. The Ubuntu9.10-D option has the same meaning as when you run postmaster directly. Pg_ctl can also be used to shut down the server. Note that to switch back to the globus user su globus, the next step is to set the database user and permissions. The first step is to get a Shell of the superuser postgres, which can be obtained here in the following ways:

$sudo-u postgres sh creates a database user that is the same as your user in this Shell. Here I use globus, because this is also my login Ubuntu user name $createuser-A-D-P globus and then create a database for that user. Here I take mydb as an example $createdb-O globus mydb notice that the above operations are done in the user postgres's Shell, and then exit the user's Shell environment and enter their own user's Shell. $exit now uses globus users, Ubuntu9.10 you can connect to your mydb database with the following command $psql mydb exit / Q and you can install pgadmin3 graphical management postgres at the same time

This is the end of "how to install the postgresql8.3 version of Ubuntu9.10". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.