PostgreSQL 9 Administration Cookbook: LITE Edition
|Also available on:|
- Learn the basics of working with PostgreSQL; connect to a server, explore the database, and adjust the size of your database to the space available.
- Amend your database with the addition or removal of columns, schemas and tablespaces
- Part of Packt's Cookbook series: Each recipe is a carefully organized sequence of instructions to complete the task as efficiently as possible
Table of ContentsPreface
Chapter 1: First Steps
Chapter 2: Exploring the Database
Chapter 3: Database Administration
- Chapter 1: First Steps
- Introducing PostgreSQL 9
- Getting PostgreSQL
- Connecting to PostgreSQL server
- Enabling access for network/remote users
- Using graphical administration tools
- Using psql query and scripting tool
- Changing your password securely
- Avoiding hardcoding your password
- Using a connection service file
- Troubleshooting a failed connection
- Chapter 2: Exploring the Database
- What version is the server?
- What is the server uptime?
- Locate the database server files
- Locate the database server message log
- List databases on this database server?
- How many tables in a database?
- How much disk space does a database use?
- How much disk space does a table use?
- Which are my biggest tables?
- How many rows in a table?
- Quick estimate of the number of rows in a table
- Understanding object dependencies
- Chapter 3: Database Administration
- Writing a script that either all succeeds or all fails
- Writing a psql script that exits on first error
- Performing actions on many tables
- Adding/Removing the columns of a table
- Changing datatype of a column
- Adding/Removing schemas
- Moving objects between schemas
- Adding/Removing tablespaces
- Moving objects between tablespaces
- Accessing objects in other PostgreSQL databases
- Making views updateable
Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.
Sorry, there are currently no downloads available for this title.
Lite EditionLearn more
Full EditionLearn more
|Learn the basics of working with PostgreSQL; connect to a server, explore the database, and adjust the size of your database to the space available.
|Amend your database with the addition or removal of columns, schemas and tablespaces|
|eBook available as PDF downloads|
|eBook available as ePub downloads|
|Available on PacktLib|
|Monitor your database ensuring that it performs as quickly as possible|
|Tips for backup and recovery of your database|
What you will learn from this book
- Explore your database and discover where your server files and server message logs are stored, how much disk space your database is using, and what your object dependencies are
- Advanced technical tips and scripts for experienced users
- Add or remove new columns, schemas, or tablespaces
- Move your objects between tablespaces and access them in other PostgreSQL databases
- Best practice for planning and designing live databases
PostgreSQL is a powerful, open source, enterprise database.
This PostgreSQL 9 Administration Cookbook LITE book describes key aspects of the PostgreSQL open source database system. The book will help a sysadmin or DBA to get started with key administration issues in PostgreSQL, going from an initial connection to a server, finding out about where your server stores vital information, to removing, adding, or moving objects and changing database schema. This hands-on guide will assist developers working on live databases supporting web or enterprise software applications.
To find out more about upgrading to the full edition, visit www.packtpub.com/lite-editions and log into your account for offers and help. If you don’t have an account on PacktPub.com, visit today and set one up!
Written in the cookbook style, this book offers learning and techniques through recipes. It contains step-by-step instructions for administrators and developers to manage databases in PostgreSQL. The book is designed in such a way that you can read it chapter by chapter or refer to recipes in no particular order.
Who this book is for
This book is for Sysadmins, Database Administrators, Architects, Developers, and anyone with an interest in planning for or running live production databases.