Download as PDF, PPTX
Uploaded byEDB
Hello World with EDB Postgres
The document outlines the features and installation process of the EDB Postgres platform, including the EDB Postgres Advanced Server and EDB Postgres Enterprise Manager. It highlights various components that ensure high performance, ACID compliance, and support for multiple programming languages and connectors. Additionally, it provides resources for training and certification to aid developers and DBAs in successful Postgres implementation.
Hello World with EDB Postgres
- 1. © 2016 EDB.All rights reserved. 1 Hello World with EDB Postgres
- 2. © 2016 EDB.All rights reserved. 2 • EDB Postgres Platform • Install EDB Postgres Advanced Server and EDB Postgres Enterprise Manager • Connect to the database • Working with EDB Postgres Enterprise Manager − Create a database − Use the SQL editor • Configure Postgres to allow connections • Summary • Resources • Q&A Agenda
- 3. © 2016 EDB.All rights reserved. 3 Enterprise Postgres: The EDB Postgres Platform
- 4. © 2016 EDB.All rights reserved. 4 • High performance (and getting faster with each release) • ACID compliance • Rich and extensible set of data types • Rich and extensible index types • Stored procedures, function packages, triggers • PL/SQL, PL/Java, PL/Perl, PL/Python, PL/V8, and more • Connectors for Java, ODBC, Perl, Python, PHP, and more • Foreign data support (reach out to Oracle, SQL Server, …) EDB Postgres Features
- 5. © 2016 EDB.All rights reserved. 5 1. Download Installer (see resources) 2. Log in as root (or use su/sudo) 3. Unpack the installer 4. Run the installer 5. Select components Install EDB Postgres Advanced Server
- 6. © 2016 EDB.All rights reserved. 6 • EDB Postgres Enterprise Manager • Command-line client (psql) • Oracle-compatible command line client (edbplus) Connect to the Database
- 7. © 2016 EDB.All rights reserved. 7 • Creating a new database • Creating a new table • Using the SQL Tool (and graphical EXPLAIN) • Using the graphical query builder Working with EDB Postgres Enterprise Manager
- 8. © 2016 EDB.All rights reserved. 8 • $PGDATA/pg_hba.conf • Determines which hosts can authenticate • Determines the authentication mechanism for each host/database/connection type/user • Example: # TYPE DATABASE USER ADDRESS METHOD local all alice trust host postgres all 192.168.12.10/32 md5 host all all 192.168.54.1/32 reject Configure Postgres to allow connections
- 9. © 2016 EDB.All rights reserved. 9 • EDB Postgres Advanced Server is easy to install • EDB Postgres Enterprise Manager allows you to create and manage Postgres databases in a GUI • The SQL editor and graphical query builder help write and execute SQL • Your EDB Postgres database is up and running and ready to be used in just a few minutes Summary
- 10. © 2016 EDB.All rights reserved. 10 Download EDB Postgres Advanced Server http://www.enterprisedb.com/downloads/ postgres-postgresql-downloads Learn more about EDB Postgres Advanced Server http://www.enterprisedb.com/ds-advanced-server Resources
- 11. © 2016 EDB.All rights reserved. 11 Resources: Getting Started with EDB Postgres Comprehensive bundle of a Developer license, Training & Consulting, helping to make development projects successful. • EDB Postgres Developer Subscription • On-Demand Training (2 classes) • Consulting (2 days-remote) EDB Developer Kick Start Comprehensive package for groups of 2-4 developers & DBAs in support of mission-critical production Postgres implementations, along with expert guidance for Year 1. • EDB Postgres Developer Subscription • On-Demand Training (4 classes) • Consulting (5 days, remote) • RemoteDBA (1 year, 8 instances) EDB Postgres Group Success with RemoteDBA
- 12. © 2016 EDB.All rights reserved. 12 Resources: Postgres Skills Development Assistance World-class training that delivers the education, experience, and excellence needed to be successful • Training that fits your learning needs: classroom, online, and onsite • eSubscriptions - access to all on-demand Training in an annual subscription • DBA and developer course tracks available • Courses cover administration, migration, performance tuning and more EDB is the industry-recognized global standard for Postgres Certification Develop and validate in-house Postgres skill and expertise • DBMSs covered include: − PostgreSQL − EDB Postgres Advanced Server • Associate & Professional levels • Convenient online exams EDB Training provides: EDB Certification provides:
- 13. © 2016 EDB.All rights reserved. 13