Long time no post. Today I am starting a series where I will be installing a full Java development environment on my home network. Today I will be installing Postgresql on my home server.
Commands used in this blog| Command | Description
|
|---|
| zypper | OpenSuSE package manager command-line tool.
|
| vim | Not explicitly listed, but I use the VIM text editor to modify configuration files.
|
| psql | Command-line client for PostgreSQL.
|
| /etc/init.d/* | Not really a command, but the directory in most Linux distributions where services are started, stopped, and restarted.
|
First, I use the zypper repository tool to see what packages are available:
Breaking down the
zypper command line:
zypper
- -- The binary. You should be root or using sudo to run this.
se
- -- se is short for search.
postgresql
- -- The string, or substring, to look for in the package names.
Pacifica:/home/phardin # zypper se postgresql
Retrieving repository 'Mozilla' metadata [done]
Building repository 'Mozilla' cache [done]
Loading repository data...
Reading installed packages...
S | Name | Summary | Type
--+----------------------------------------+----------------------------------------------------+-----------
| CDnavigator-postgresql | Postgresql files for CDnavigator | package
| Io-language-postgresql | Io postgresql bindings | package
| OpenOffice_org-base-drivers-postgresql | PostgreSQL Database Driver for OpenOffice.org | package
| VdrAssistant-postgresql | VdrAssistant database package | package
| gambas2-gb-db-postgresql | The postgresql driver for the Gambas database co-> | package
| libqt4-sql-postgresql | Qt 4 PostgreSQL plugin | package
| mono-data-postgresql | Database connectivity for Mono | package
| pdns-backend-postgresql | PostgreSQL backend for pdns | package
| postfix-postgresql | Postfix plugin to support PostgreSQL maps | package
| postgresql | Basic Clients and Utilities for PostgreSQL | package
| postgresql | Basic Clients and Utilities for PostgreSQL | srcpackage
| postgresql | postgresql: security update | patch
| postgresql-contrib | Contributed Extensions and Additions to PostgreSQL | package
| postgresql-devel | PostgreSQL development header files and libraries | package
| postgresql-docs | HTML Documentation for PostgreSQL | package
| postgresql-jdbc | JDBC Drivers for PostgreSQL | package
| postgresql-libs | Shared Libraries Required for PostgreSQL Clients | package
| postgresql-plperl | The PL/Tcl, PL/Perl, and PL/Python procedural l-> | package
| postgresql-plpython | The PL/Python Procedural Languages for PostgreSQL | package
| postgresql-pltcl | PL/Tcl Procedural Language for PostgreSQL | package
| postgresql-server | The Programs Needed to Create and Run a PostgreS-> | package
| python-storm-postgresql | PostgreSQL backend for python-storm | package
| qt3-postgresql | A PostgreSQL Plug-In for Qt | package
| rekall-postgresql | Rekall PostgreSQL Database Backend | package
| tntdb1-postgresql | Tntdb is a c++-class-library for easy database-a-> | package
I want the documents, the postgres package, and the contrib. I'll be installing a mediawiki, written in php and run through an apache server. I don't see any packages I need to worry about for that end. So:
Pacifica:/home/phardin # zypper in postgresql
Retrieving repository 'openSUSE BuildService - Virtualization (VirtualBox)' metadata [done]
Building repository 'openSUSE BuildService - Virtualization (VirtualBox)' cache [done]
Loading repository data...
Reading installed packages...
Resolving package dependencies...
The following NEW packages are going to be installed:
libgda-3_0-postgres libgda-4_0-postgres postgresql postgresql-libs
Overall download size: 1.3 M. After the operation, additional 5.1 M will be used.
Continue? [YES/no]:
Retrieving package postgresql-libs-8.3.8-0.1.1.i586 (1/4), 175.0 K (560.0 K unpacked)
Retrieving: postgresql-libs-8.3.8-0.1.1.i586.rpm [done]
Installing: postgresql-libs-8.3.8-0.1.1 [done]
Retrieving package libgda-3_0-postgres-3.1.2-82.42.i586 (2/4), 47.0 K (119.0 K unpacked)
Installing: libgda-3_0-postgres-3.1.2-82.42 [done]
Retrieving package postgresql-8.3.8-0.1.1.i586 (3/4), 1.0 M (4.2 M unpacked)
Retrieving: postgresql-8.3.8-0.1.1.i586.rpm [done (260.4 K/s)]
Installing: postgresql-8.3.8-0.1.1 [done]
Retrieving package libgda-4_0-postgres-4.0.1-22.9.i586 (4/4), 68.0 K (230.0 K unpacked)
Retrieving: libgda-4_0-postgres-4.0.1-22.9.i586.rpm [done]
Installing: libgda-4_0-postgres-4.0.1-22.9 [done]
Pacifica:/home/phardin # zypper in postgresql-contrib
Loading repository data...
Reading installed packages...
Resolving package dependencies...
The following NEW packages are going to be installed:
postgresql-contrib postgresql-server
Overall download size: 3.3 M. After the operation, additional 13.5 M will be used.
Continue? [YES/no]:
Retrieving package postgresql-server-8.3.8-0.1.1.i586 (1/2), 3.0 M (12.4 M unpacked)
Retrieving: postgresql-server-8.3.8-0.1.1.i586.rpm [done (413.9 K/s)]
Installing: postgresql-server-8.3.8-0.1.1 [done]
Additional rpm output:
Updating etc/sysconfig/postgresql...
Retrieving package postgresql-contrib-8.3.8-0.1.1.i586 (2/2), 297.0 K (1.1 M unpacked)
Retrieving: postgresql-contrib-8.3.8-0.1.1.i586.rpm [done]
Installing: postgresql-contrib-8.3.8-0.1.1 [done]
Pacifica:/home/phardin # zypper in postgresql-docs
Loading repository data...
Reading installed packages...
Resolving package dependencies...
The following NEW package is going to be installed:
postgresql-docs
Overall download size: 1.4 M. After the operation, additional 8.5 M will be used.
Continue? [YES/no]:
Retrieving package postgresql-docs-8.3.8-0.1.1.i586 (1/1), 1.4 M (8.5 M unpacked)
Retrieving: postgresql-docs-8.3.8-0.1.1.i586.rpm [done (171.1 K/s)]
Installing: postgresql-docs-8.3.8-0.1.1 [done]
Pacifica:/home/phardin #
Now, I should have some new files, directories, and controls installed.
Starting and stopping may be done with the script:
/etc/init.d/postgresql The data repository is in:
/var/lib/pgsql/ The server has a new user:
postgres and a new group:
postgres.
The primary package and contrib are in
/usr/share/postgresql and the documentation package has left a nice fat directory in
/usr/share/doc/postgresql.
The following applications have been added, as seen in this listing of
/usr/bin:
Pacifica:/home/phardin # ls /usr/bin/pg_*
/usr/bin/pg_controldata /usr/bin/pg_dump /usr/bin/pg_resetxlog /usr/bin/pg_standby
/usr/bin/pg_ctl /usr/bin/pg_dumpall /usr/bin/pg_restore
Now read the file
/usr/share/doc/packages/postgresql/README.SuSE.en to get some good advice and a bit of the lay of the land according to SuSE. This is a good start, but we still don't have a running database.
As root type in the following to launch your database engine:
/etc/init.d/postgresql startNow, you're still root, change your user to postgres:
su postgresStart up the postgresql shell:
Pacifica:/home/phardin/Documents # su postgres
postgres@Pacifica:/home/phardin/Documents> psql
Welcome to psql 8.3.8, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
postgres=# Woot!!
Last thing... and this is IMPORTANT! Change the password for postgres:
postgres=# alter user postgres with password 'bingo;';
ALTER ROLE
postgres=#
Now, run to your browser and cranke up a local documentation page, which you downloaded with postgresql
file:///usr/share/doc/packages/postgresql/html/index.html. Read about architecture, sql, data types, and other great things.
Next we will install the adminpack from the contrib directory and then we will load up an administration tool to help us manage users, databases, tables, roles, and permissions.
We now have a database that we can log into while we are user postgres. This is a good proof of concept, but more work is obviously needed. But, for now, this is all we need.
Next I will move on to getting apache2 web server installed. My goal here is to be able to server up a subversion code repository and to serve up a mediawiki instance for documentation and notes.
Hope this helps someone,
LandShark
