First Steps

In this chapter, we will cover the following recipes:

• Getting PostgreSQL
• Connecting to the PostgreSQL server
• Enabling access for network/remote users
• Using graphical administration tools
• Using the psql query and scripting tool
• Changing your password securely
• Avoiding hardcoding your password
• Using a connection service file
• Troubleshooting a failed connection