Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
PostgreSQL DBA hands-on certification Camp
Date: 2007-05-21 – 2007-05-25
(This is a training event)
Location: Toronto, ON, Canada
I. Getting Started
1. Installing PostgreSQL
Compiling and Installing PostgreSQL on Linux/Unix
Post-Installation Setup
The PostgreSQL 8.2.1 Windows Installer
2. Creating a Database and Testing the Server
Initializing a Cluster
Creating a Database
Starting the Database Server
The psql Client
Startup Failures and Client Connection Problems
II. Basic PostgreSQL Administration
3. Overview of PostgreSQL Architecture
Configuration Files
Physical Storage and File Layout
Tablespaces
System Catalogs
Logging Parameters
4. Roles and Privileges
Roles and Their Attributes
Privileges
Role Membership
5. Security
Securing TCP Connections with SSL
Create Secure SSH Tunnels
Client Authentication
Encryption Options
6. Backup and Recovery
Overview of Backup Methods
Performing an SQL Dump and Restore
Filesystem Backup
7. Maintenance and Monitoring
Routine Maintenance Tasks
Monitoring Database Activity
Monitoring Disk Usage
8. Client Connections
pgsqlODBC and OpenOffice
Windows ODBC and Microsoft Access
Perl DBI
III. Advanced Administration Topics
9. Peformance Tuning
10. Continuous Backup and PITR
11. Warm Standby Servers for High Availability
12. Asynchronous Replication with Slony-I
13. Procedural Languages
14. Contrib Modules
Posted on 2007-02-07
Posted by info@CertFirst.com
Location: Toronto, ON, Canada
I. Getting Started
1. Installing PostgreSQL
Compiling and Installing PostgreSQL on Linux/Unix
Post-Installation Setup
The PostgreSQL 8.2.1 Windows Installer
2. Creating a Database and Testing the Server
Initializing a Cluster
Creating a Database
Starting the Database Server
The psql Client
Startup Failures and Client Connection Problems
II. Basic PostgreSQL Administration
3. Overview of PostgreSQL Architecture
Configuration Files
Physical Storage and File Layout
Tablespaces
System Catalogs
Logging Parameters
4. Roles and Privileges
Roles and Their Attributes
Privileges
Role Membership
5. Security
Securing TCP Connections with SSL
Create Secure SSH Tunnels
Client Authentication
Encryption Options
6. Backup and Recovery
Overview of Backup Methods
Performing an SQL Dump and Restore
Filesystem Backup
7. Maintenance and Monitoring
Routine Maintenance Tasks
Monitoring Database Activity
Monitoring Disk Usage
8. Client Connections
pgsqlODBC and OpenOffice
Windows ODBC and Microsoft Access
Perl DBI
III. Advanced Administration Topics
9. Peformance Tuning
10. Continuous Backup and PITR
11. Warm Standby Servers for High Availability
12. Asynchronous Replication with Slony-I
13. Procedural Languages
14. Contrib Modules
Posted on 2007-02-07
Posted by info@CertFirst.com