Appliance:PostgreSQL Appliance
From rPath Wiki
|
An appliance that bundles up PostgreSQL and the rPath Appliance Platform to provide a self-contained, turn-key, updateable database appliance.
Download
Download page on rBuilder Online.
Installation
The fastest way to get started is to download one of the virtual appliance images and boot it. Alternatively, you can download the ISO images and complete the graphical installation to install PostgreSQL appliance on a dedicated system.
 | For more information on using rPath-based appliances with various virtual machine technologies, see Using rBuilder Images with Virtual Machines |
Configuration
- Login to the rPath Appliance Platform interface and complete the wizard. rAP will be at
https://<your_ip>:8003/orhttp://<your_ip>:8004/. - Set a password for
webaccount, it will be used to access web-interface to database. - The PostgreSQL database service starts automatically upon first boot, no additional configuration required.
Configure networking
By default, this appliance is set to use DHCP to obtain its network address automatically.
To change the network configuration for this appliance, you can use the rPath Appliance Platform web-based configuration UI. See the rPath Appliance Platform User Guide for detailed instructions.
Configure PostgreSQL
- Point your browser to
http://<your_ip>/phpPgAdmin/, login with user nameweband the password you set in the rAP wizard. - After logging in, you will need to login to PostgreSQL with user name
postgresand a blank password.
Security Tips
- Use secure
httpsprotocol instead of plainhttpto access rAP or phpPgAdmin. - By default, you can access database with user
postgresand blank password from localhost only. If you create new users and open access to PostgreSQL from other hosts, do not forget to secure yourpostgresaccount.
Passwords
| purpose | username | default password | how to change |
|---|---|---|---|
| console access | root | empty |
|
| rAP access | admin | password |
|
| phpMyAdmin access | web | not set |
|
| PostgreSQL super-user | postgres | empty | use phpPgAdmin web-interface or psql command-line front-end to manage PostgreSQL users
|
Updates
Unlike software appliances based on "snapshot" techniques, appliances built with rPath technologies can updated incrementally as new features are added by the development team. Launch updates during remote administration through the rPath™ Appliance Platform, or bypass the rPath Appliance Platform to use a direct command.
Update with rPath Appliance Platform
If you have updated to at least version 8.1.4 (December 14, 2006) of this appliance, you can use the rPath Appliance Platform Agent to update remotely using a web interface. The rPath Appliance Platform Agent interface can be accessed using:
https://<appliance_ip_or_hostname>:8003/
See the rPath Appliance Platform User Guide for full instructions.
 | Please note that if you have added additional packages using conary update, these packages will be removed by a rPath Appliance Platform update. To preserve this custom update of the appliance software, do not use the rPath Appliance Platform Agent. Instead, use conary updateall command line (see next section). Alternatively, you can change rPath Appliance Platform Agent's default behavior by modifying /etc/raa/prod.cfg file and change the line updatetroves.migrate = True to updatetroves.migrate = False |
Update with Conary Commands
If you have downloaded a version of the appliance without the rPath Appliance Platform, login to your appliance as root and issue the command:
conary updateall
This command will update the appliance, including adding the rPath Appliance Platform. If you have added other packages using conary update, they will remain on the system.
Support
PostgreSQL Appliance is a community supported project. Questions about PostgreSQL Appliance should be raised on the PostgreSQL Appliance discussion list
You can also discuss the project using the discussion tab in this wiki.