postgreSQL install a small mind (to)

2010-12-29  来源:本站原创  分类:Database  人气:99 

Note: Transfer from saber7's blog

Installation environment windows7 32-bit systems



Before the first download a postgresql-8.4.2-1-windows version, this version is installed version, the installation process to continue to error, but barely finished loading, but can not connect to the database after Bahrain, reason should be win7 thing, in a virtual machine installation xpsp3 normal, but do not want to write the code every time the virtual machine when they are opened, they still want to find a way to install the win7 ... ...

And turn, finally succeeded in testing a lot of ways, and recorded:

1. First to download postgreSQL program, I downloaded the win x86-32 version 9.0.1-1 because I think the newer version should be compatible with it a little better ;

2. Download compressed package in the pgsql after the unzipped folder, for convenience, I directly into the D: \ pgsql, Green Edition (in fact, is not especially green), no installation, but need to set some environment variables ... ...

3. Write a simple batch it, any name, I've called inst.bat:

set PGHOME = d: \ pgsql
set PATH =% PGHOME% \ bin;% path%
set PGHOST = localhost
set PGLIB =% PGHOME% \ lib
set PGDATA =% PGHOME% \ data

This batch file will be copied to D: \ pgsql

4. Open cmd, switch to your pgsql directory, and I was D: \ pgsql, run the inst

C: \ Users \ Administrator> d:

D: \> cd D: \ pgsql

D: \ pgsql> inst

D: \ pgsql> set PGHOME = d: \ pgsql

D: \ pgsql> set PATH = d: \ pgsql \ bin; D: \ Python26 \ Scripts; D: \ Python26 \; C: \ Windows \ syste
m32; C: \ Windows; C: \ Windows \ System32 \ Wbem; C: \ Windows \ System32 \ WindowsPowerShell \ v1
.0 \; C: \ Program Files \ Common Files \ Thunder Network \ KanKan \ Codecs; C: \ Users \ Adminis
trator \ AppData \ Roaming \ Python \ Scripts; D: \ Program Files \ Google \ google_appengine \

D: \ pgsql> set PGHOST = localhost

D: \ pgsql> set PGLIB = d: \ pgsql \ lib

D: \ pgsql> set PGDATA = d: \ pgsql \ data

5. Initialize the database

D: \ pgsql> initdb - locale = C
Documents belonging to this database system host as user "Administrator".
This user must also be a host for the server process.
The database cluster will be initialized with locale C.
The default database encoding has accordingly set to SQL_ASCII.
The default text search configuration will be set to "english"

Create the directory d: / pgsql / data ... success ... success is creating a subdirectory to select the default maximum number of connection (max_connections) ... 100
Select the default shared buffer size (shared_buffers) ... 32MB
Success in creating a profile ... d: / pgsql/data/base/1 create template1 database ... pg_authid ... successfully initialized successfully initialized successfully create a system view dependencies ... ... success is loading system successfully created the object description ... ... success of the character set conversion is ... create a dictionary object successfully set permissions on the built-in success ...

Creating a successful information model ...
loading PL / pgSQL server-side language ... successfully clean up the database template1 template1 ... successfully copied to the copy template1 template0 ... success to the success of template0 ...

Warning: Connect launched for local "trust" authentication.
You can change by editing pg_hba.conf or using the next time you run initdb-A option.

Success. You can now use the following command to run the database server:

"" Postmaster-D "d: / pgsql / data"
"" Pg_ctl-D "d: / pgsql / data"-l logfile start

6. Start

D: \ pgsql> pg_ctl start
Starting the server process

D: \ pgsql> LOG: database system was shut down at 2010-12-13 13:41:20 HKT
LOG: autovacuum launcher started
LOG: database system is ready to accept connections

7. The cmd window instead of closing, and then open a cmd window

Create Database

D: \ pgsql> D: \ pgsql \ bin \ createdb-h mydb

Create User

D: \ pgsql> D: \ pgsql \ bin \ createuser-h s7
Whether the new role be a superuser? (Y / n) y

D: \ pgsql>

8. Open the graphical user interface management database D: \ pgsql \ bin \ pgAdmin3.exe

postgreSQL install a small mind (to)


postgreSQL install a small mind (to)

  • postgreSQL install a small mind (to) 2010-12-29

    Note: Transfer from saber7's blog Installation environment windows7 32-bit systems postgresql-9.0.1-1-windows-binaries ===== Before the first download a postgresql-8.4.2-1-windows version, this version is installed version, the installation process t

  • PostgreSQL install and simple to use (OS: ubuntu8) 2011-07-29

    1 Installation: Software is actually very simple to use Synaptic Package Manager to search for psql can be found postgresql-client-8.2 (both can be found to version 8.1, which can be), check - applications can be. Or type in a terminal xiaop @ localh

  • postgreSQL install a small note (rpm) 2010-12-29

    Note: Transfer from saber7's blog Installation environment windows7 32-bit systems postgresql-9.0.1-1-windows-binaries ===== Prior to first download a postgresql-8.4.2-1-windows version, this version is installed version, the installation process hav

  • install postgresql in ubuntu steps (rails environment) 2011-07-07

    First, run sudo aptitude search postgres view the machine have installed ps some of the packages. If the list showing the name of the C package with the following command-XXX sudo aptitude purge all uninstall (because I did not uninstall, install the

  • PostgreSQL installation problems 2011-10-01

    1, PostgreSQL install error Error reading file postgresql.conf solution (transfer) Recent projects need to use the PostgreSQL database, and a little fresh, but the installation was very depressed me, for a few directories are installed error (the las

  • When installing postgresql "An error occured executing the Microsoft VC + + runtime install" solution 2010-03-04

    In the XP install postgresql database pop-up "An error occured executing the Microsoft VC + + runtime installer" error message, specific solutions are as follows: 1. Open the Run dialog box, enter "C: \ WINDOWS \ inf" 2. In the inf dir

  • [Reprinted] Ubuntu install Postgresql 8.3 2010-03-08

    In the Ubuntu install Postgresql and pgAdmin3 sudo apt-get install postgresql-8.3 postgresql-client-8.3 postgresql-contrib-8.3 sudo apt-get install pgadmin3 These instructions to install the client and server, some additional tools, pgAdmin3 can work

  • opensuse install postgresql source 2010-03-14

    ubuntu 9.10 inexplicable failure to debug the final out of the main interface embodied in the ddd after the input box are not written. Helpless, he moved to opensuse 11.2. The following is the full source installation of postgresql process: 1 to post

  • Install PostgreSQL on CentOS 2010-08-12

    Install PostgreSQL on CentOS - Filed under: PostgreSQL, CentOS How to install PostgreSQL Server on CentOS 1. Download yum repository rpm for your arch and version you want to use: 2. Install

  • Mac OS install PostgreSQL for Rails 2010-09-08

    My official third-party PostgreSQL is installed through the package installation, so can not be found in the general psql console commands like, if not through this port should be asked to install it. For installation ruby_pg is very simple, as long

  • WindowsXP install PostgreSQL 8.4.2 database 2010-09-26

    In the software industry, software engineers are talking about free as long as the database, many programmers first thought is definitely MySQL, and MySQL does now used in many areas around the world, in particular, is the site set up side. But, in f

  • mac os x10.6 to install postgresql 9.0 2010-11-07

    Originally mac os x 10.6 snow leopard is very simple to install postgresql things official website to download 9.0.1 from the dmg file, and then have an installed I thought, the problem really is not that simple, dmg is very easy to fool installation

  • CentOS install PostgreSQL 2010-11-17

    Source code download page I chose v8.4.4 wget Extract tar xzvf postgresql-8.4.4.tar.gz Configure the default parameters c

  • XP win7 install Postgresql 9.0 problem running post-install step. 2010-11-18

    Chinese version of xp to install Postgresql error Problem running post-install step. Installation may not complete correctly. The database cluster initialisation failed. Need to uninstall, reinstall Postgresql and then select "Local" when the el

  • Instructions to install PostgreSQL on RedHat 2011-07-15

    Instructions to install PostgreSQL on RedHat System code is set to UTF8, or can not install Following the 9.0.4 version, for example, can also refer to the INSTALL file within the package. 1 Download the PostgreSQL source package, on any directory ht

  • Install postgresql error "An error occured executing the Microsoft VC + + runtime installe 2011-02-22

    Install postgresql error by aijcjo @ 20110111 Install postgresql error "An error occured executing the Microsoft VC + + runtime installer" There are two solutions: 1, Go to file% windir% \ inf \ wsh.inf, right click and select 'Install' 2, the a

  • CentOS install PostgreSQL graphic tutorials 2011-03-20

    PostgreSQL server package includes the program files used to create and run a PostgreSQL server, and also allows you to create and maintain PostgreSQL database server. PostgreSQL is an advanced relational database, PostgreSQL supports almost all of t

  • RedHat Linux Install PostgreSQL 8.4.2 2011-04-26

    Download and unpack $ Tar zxvf postgresql-8.2.4.tar.gz $ Cd postgresql-8.2.4 Configuration $. / Configure - prefix = / usr/local/pgsql-8.2.4 ... config.status: linking. / src / makefiles / Makefile.linux to src / Makefile.port Compilation $ Make ...

  • how to install PostgreSQL on ubuntu 2013-01-13

    1. This installs the database server/client, some extra utility scripts and the pgAdmin GUI application for working with the database. $ sudo apt-get install postgresql postgresql-client postgresql-contrib $ sudo apt-get install pgadmin3 2. Now we ne

  • postgresql 9.3 install centos6.x 2014-07-26

    系统:centos6.4 安装postgresql9.3 (防火墙需要开启5432端口) 添加yum源 yum install -y 安装postgresql yum install -y postgresql93-server postgresql93-contrib 更改默认安装目录为/data/pgsql (可选,默认为/var