PostgreSQL Manual - Linux Server Administration Software HDE ...

arizonahoopleΔιαχείριση Δεδομένων

28 Νοε 2012 (πριν από 4 χρόνια και 9 μήνες)

220 εμφανίσεις

















PostgreSQL Manual















2 HDE Controller X PostgreSQL




























Please note that this user manual may be subjected to change due to
product upgrades without any prior notice.
HDE and HDE Controller is a registered trademark of HDE, Inc.
All group names and product names listed in this manual are registered
trademarks to each of the groups and products respectively.
This manual may only be copied by printing in PDF format. Any other
forms of copying, transferring, loaning, adapting, translating, or public
distribution of this manual is not allowed.
Reprinting or reproducing this manual without HDE's permission is
strictly forbidden.
© 2011 HDE, Inc.
File Server
3

How to Read this Manual
 About this Manual
The “HDE Controller Installation Manual” provides users with instructions
to installing OS and the HDE Controller (this Product) as well as steps
for configuring the initial settings of the Product.
Annotations are provided for any matters requiring special attention and
phrase supplements.


Any matters which
require special attention
are marked with this
"Alert" icon in bold frame.


Contents which provide
useful reference for using
HDE Controller are
marked with this "Hint"
icon.



4 HDE Controller X PostgreSQL

HDE Controller X

PostgreSQL


1. Basic Settings
PostgreSQL is an open-source RDBMS (Relational Database
Management System) which supports advanced features such as
SQL92/SQL99, etc.
The PostgreSQL feature on HDE Controller provides the users with an
easy tool to construct an operating environment by password
authentication of the database. Additionally, users are able to add/delete
databases, perform backup on databases and clusters, and perform
restore on the backup files.
Select the "PostgreSQL" – “Basic Settings” menu.
Configure the settings for database administrator (postgres).
Enter a password you wish to apply as the database administrator
password.
Click the "Configure" button to apply your settings.


Once the "Configure" button is pressed, any database
authentication via the UNIX main socket will be password
authenticated. Please be warned that you may not be able to
connect to any database if you were already using
PostgreSQL before using PostgreSQL management.
6 HDE Controller X PostgreSQL Manual

2. User Management
Add, delete, and edit user accounts used to connect to the database
server.


Please note that the user accounts here are exclusively for
accessing the database and have no association whatsoever
with the Linux user accounts.
You are not allowed to delete database owners.
Also, postgres users will be added automatically and cannot
be deleted/edited.
Click the “Add” button to add a new user.

Specify the "User Name", "Connection Password", "Roles for Creating
DB", and "Roles for Creating Users". You may not specify any existing
user names.
To edit the content of a user, click the edit button on the list of user
information.
PostgreSQL
7

You may make changes to the "Connection Password", "Roles for
Creating DB", and "Roles for Creating User" on the user edit screen.
To change the connection password, check the "Change password" box
and enter a new connection password.
To delete an existing user, click the "Delete" button on the user
information screen.
Click the "Configure" button to apply your settings.

8 HDE Controller X PostgreSQL Manual

3. Database Management
Add, delete, or edit databases. Please note that you may not add, delete,
or edit any database that begins with template.

Click the “Add” button to add a new database.
Enter the database name and select the database owner and click the
"OK" button. Please note that you may not specify the name of any
database that already exists.
To edit an existing database, click the "Edit" button on the database
information screen.



PostgreSQL
9

Follow the procedures mentioned for adding new databases to edit
existing databases.
To delete an existing database, click the "Delete" button on the database
information screen.

Click the "Configure" button to apply your settings.


10 HDE Controller X PostgreSQL Manual

4. Backup
Perform backup for the databases.
Select the backup target as either databases or clusters.
Select "Backup of Databases" if you wish to perform backup on
databases. You may not select this option if no databases currently exist.
Enter the "Directory Name" and "File Name" of the output backup file.

Click the "Execute" button to begin the backup procedure.


Please note that to restore data from the backup files, you
must perform restore using the same version of PostgreSQL
as the one used for creating the backup files.


Please be aware that OID and large objects are not backed
up.


Please note that since the pg_dump and the pg_dumpall
commands provided by the PostgreSQL are used for backing
up databases and clusters, you may not be able to perform
restore if you do not manually change to dump order due to
regulations set by pg_dump and pg_dumpall.


PostgreSQL
11

5. Restore
Restore databases from the backup files.
Select the restoration method.
 Creating a new database and restore data onto it
Please be warned that by selecting this option, all data currently present
on the database will be erased.
Additionally, the backup procedure will not be performed correctly if the
database owner does not exist. Please make sure that the owner of the
database containing the backup data exists before executing the restore
procedure. If database owner does not exist, please create an owner in
"Database User Management" before proceeding with the restore
procedure.
Also note that you cannot choose this option if no pre-existing database
is found (option will be hidden).
 Clear an existing database and restore data onto it
Creates a new database and restores the backup data onto the new
database. Please note that the backup procedure will not be executed
correctly if the database owner does not exist. Please make sure that the
owner of the database containing the backup data exists before
executing the restore procedure. If database owner does not exist,
please create an owner in "Database User Management" before
proceeding with the restore procedure.
12 HDE Controller X PostgreSQL Manual


 Restore Clusters
Restore the backup data on the clusters. Please be aware that any pre-
existing data on the clusters will be erased. Also, please note that the
backup procedure will not be executed correctly if the database owner
does not exist. Please make sure that the owner of the database
containing the backup data exists before executing the restore procedure.
If database owner does not exist, please create an owner in "Database
User Management" before proceeding with the restore procedure.
Specify the backup file created via the "Backup" menu.

Click the "Execute" button to start the restore process.


Please note that to restore data from the backup files, you
must perform restore using the same version of PostgreSQL
as the one used for creating the backup files.


Please note that since the pg_dump and the pg_dumpall
commands provided by the PostgreSQL are used for backing
up databases and clusters, you may not be able to perform
restore if you do not manually change to dump order due to
regulations set by pg_dump and pg_dumpall.


You must reconfigure the file postgresql.conf after the
restoration process if you are configuring specific settings
using postgresql.conf as the /var/lib/pgsql/data directory will
be deleted when restoring backup files on clusters.



PostgreSQL
13

























HDE Controller PRO / LG User Manual
April 30, 2011 1st Ed. 10.0-001

HDE, Inc.
16-28, Nanpeidaicho, Shibuya, TOKYO, 150-0036 JAPAN