Re: Start of the Seattle Postgres Users Group (Seapug)

Personally the talks I'd be most interested in hearing are related to
database design and performance. As a programmer learning to be a dba
as I go the postgresql problems I run into most at work involve
keeping query times reasonable as the size of our database grows,
maybe not postgresql specific, but talks about topics like ranging
from the basic considerations when designing new database schemas, to
when and how to approach de-normalization of your data, partitioning,
sharding, materialized views,etc. Looking through pdxpug's notes on
past meetings it looks like they've had quite a few talks in this
genre. If you are interested and willing to talk about one of these
subjects Robert I think that would be awesome, otherwise maybe we
could convince some of pdxpug's previous speakers to come up here and
give their talks again.

Robert from your list below, I'd be most interested in learning more
about connection pooling with PGPool, thanks for offering to talk.
Doug

On Sun, Feb 14, 2010 at 1:29 PM, Robert Bernier <robert(at)pg-live(dot)info> wrote:
> Hi Lloyd,
>
> As per our conversation at last week's first ever SEAPUG, you asked what kind of talks I could offer for future meetings.
>
> I've got teaching material for virtually any and all basic PostgreSQL activities.  Although these days it's kinda hard to say what exactly constitute 'basic' since a lot of knowledge is required by the DBA before he even begins his foray into PostgreSQL.
>
> I'm pretty much open to any suggestions as to what you'd like me to offer in the way of presentation. Maybe we can get some input from the others who are currently subscribed to this mail list as to what they'd like to see.
>
> At the top of my head here's a list of topics that might pique your interest:
> Installing PostgreSQL
>        Unix/Linux/BSD Installation (Binary and Source)
>        Windows Installation
>        Configuration
>
> Server Startup and Shutdown
>        Command Line Invocation
>        Explicitly Installing and Running a Service
>        Shutting Down the Server
>        The Use of Signals in a UNIX environment
>
> Privileges, and Security
>        About Database Roles
>                Attributes
>                Privileges
>                Membership
>
>        Authentication techniques (editing the pg_hba.conf file)
>                Unix socket domains
>                How to use IDENT
>                How to use PAM
>                How to use KERBEROS
>
>        Encrypted sessions
>                port forwarding with SSH
>                Using SSL
>                Data Encryption
>
> Backup, Logging, and Recovery
>        Command line utilties
>        Point In Time Recovery
>
> Supporting projects
>        SLONY
>        PGPOOL
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> --
> Robert Bernier
>   PostgreSQL Business Intelligence Analyst
>   robert(at)pg-live(dot)info
>
>
> --
> Sent via seapug mailing list (seapug(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/seapug
>