PostgreSQL 9 Admin Cookbook - Riggs, Sim.epub

Table of Contents PostgreSQL 9 Administration Cookbook Credits About the Authors About the Reviewers Preface What this book covers What you need for this book Who this book is for Conventions Reader feedback Customer support Errata Piracy Questions 1. First Steps Introduction Introducing PostgreSQL 9 What makes PostgreSQL different? Getting PostgreSQL How to do it... How it works... There's more... Connecting to PostgreSQL server Getting ready How to do it... How it works... Inspecting your connection information See also Enabling access for network/remote users How to do it... How it works... There's more... See also Using graphical administration tools How to do it... How it works... There's more... See also Using psql query and scripting tool Getting ready How to do it... How it works... There's more... See also Changing your password securely How to do it... How it works... Avoiding hardcoding your password Getting ready How to do it... How it works... There's more... Using a connection service file How to do it... How it works... Troubleshooting a failed connection How to do it... The......