Install postgresql 9.1




















Doing so is not hard and it can be a good exercise. PostgreSQL can be installed by any unprivileged user; no superuser root access is required. If you are installing PostgreSQL yourself, then refer to Chapter 15 for instructions on installation, and return to this guide when the installation is complete.

Be sure to follow closely the section about setting up the appropriate environment variables. If your site administrator has not set things up in the default way, you might have some more work to do. For example, if the database server machine is a remote machine, you will need to set the PGHOST environment variable to the name of the database server machine. If using GCC, all programs and libraries are compiled with code coverage testing instrumentation.

When run, they generate files in the build directory with code coverage metrics. See Section This option is for use only with GCC and when doing development work.

If using GCC, all programs and libraries are compiled so they can be profiled. On backend exit, a subdirectory will be created that contains the gmon. Enables assertion checks in the server, which test for many "cannot happen" conditions. This is invaluable for code development purposes, but the tests can slow down the server significantly.

Also, having the tests turned on won't necessarily enhance the stability of your server! The assertion checks are not categorized for severity, and so what might be a relatively harmless bug will still lead to server restarts if it triggers an assertion failure.

This option is not recommended for production use, but you should have it on for development work or when running a beta version. Enables automatic dependency tracking. With this option, the makefiles are set up so that all affected object files will be rebuilt when any header file is changed. This is useful if you are doing development work, but is just wasted overhead if you intend only to compile once and install. At present, this option only works with GCC.

For example, using the GCC compiler:. If you prefer a C compiler different from the one configure picks, you can set the environment variable CC to the program of your choice. By default, configure will pick gcc if available, else the platform's default usually cc. You can specify environment variables on the configure command line, for example:. Full path name of the Perl interpreter. Full path name of the Python interpreter. Full path name of the Tcl interpreter.

Remember to use GNU make. The build will take a few minutes depending on your hardware. The last line displayed should be:. If you want to build everything that can be built, including the documentation HTML and man pages , and the additional modules contrib , type instead:.

If you want to test the newly built server before you install it, you can run the regression tests at this point. The regression tests are a test suite to verify that PostgreSQL runs on your machine in the way the developers expected it to. This won't work as root; do it as an unprivileged user. Chapter 30 contains detailed information about interpreting the test results. You can repeat this test at any later time by issuing the same command. Note: If you are upgrading an existing system be sure to read Section This will install files into the directories that were specified in step 1.

Make sure that you have appropriate permissions to write into that area. Normally you need to do this step as root. Alternatively, you can create the target directories in advance and arrange for appropriate permissions to be granted. You can use gmake install-strip instead of gmake install to strip the executable files and libraries as they are installed. This will save some space. If you built with debugging support, stripping will effectively remove the debugging support, so it should only be done if debugging is no longer needed.

The standard installation provides all the header files needed for client application development as well as for server-side program development, such as custom functions or data types written in C.

Prior to PostgreSQL 8. Client-only installation: If you want to install only the client applications and interface libraries, then you can use these commands:. Registering eventlog on Windows : To register a Windows eventlog library with the operating system, issue this command after installation:.

Uninstallation: To undo the installation use the command gmake uninstall. However, this will not remove any created directories. Cleaning: After the installation you can free disk space by removing the built files from the source tree with the command gmake clean.

This will preserve the files made by the configure program, so that you can rebuild everything with gmake later on.

To reset the source tree to the state in which it was distributed, use gmake distclean. If you are going to build for several platforms within the same source tree you must do this and re-configure for each platform. Alternatively, use a separate build tree for each platform, so that the source tree remains unmodified. If you perform a build and then discover that your configure options were wrong, or if you change anything that configure investigates for example, software upgrades , then it's a good idea to do gmake distclean before reconfiguring and rebuilding.

Without this, your changes in configuration choices might not propagate everywhere they need to. Development Versions: devel. Unsupported versions: 9. Community Bot 1 1 1 silver badge. Thanks for the reply! For some reason, I didn't see the reply notification until now. This does not work for me, the postgres I am running Ubuntu I already ran aptitude update. Sign up or log in Sign up using Google. Sign up using Facebook.

Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses.



0コメント

  • 1000 / 1000