I work at TriMet as a programmer analyst. We have installed some open
source applications and on the process of implementing more open source
applications. During the process, we have stayed with postgresql
database as the backend. Recently, I recognized that we have to
consolidate all the separate postgresql databases for easy maintenance
while still keeping the development, test, and production environments.
My plan is to create 3 database servers as pgdev, pgtest, and pgprod.
Each database server will host multiple databases for their
applications. For example, a point of sales application will have a POS
database in pgdev, pgtest, and pgprod. While a CMS Plone application
will have a Plone database in pgdev, pgtest, and pgprod.
I am interested learning from you about the following:
1.) Size of the databases you have?
2.) Number of database users? Number of application users? Number of
3.) How you have set the size of shared memory of the database server?
Any other performance issues?
4.) Can you create cross database/schema reference in Postgresql?
similar like Oracle's synonymous.
5.) Have you tried convert Oracle PL/SQL into pgPL/SQL? How about
6.) Postgresql database backup and restore using text or non-text files?
Eg, psql dbname < backup_file vs. pg_restore
7.) Database vacuum flags, such as the one for the ANALYZE option, can
we use it during production hours?
8.) Any security features you may have implemented in addition to the
user, group or roles?
From: pdxpug-owner(at)postgresql(dot)org [mailto:pdxpug-owner(at)postgresql(dot)org]
On Behalf Of Jeff Davis
Sent: Thursday, January 03, 2008 5:27 PM
To: Selena Deckelmann
Cc: Postgresql PDX_Users
Subject: Re: [pdxpug] Call for meeting topics! Next meeting: January 17
On Thu, 2008-01-03 at 14:04 -0800, Selena Deckelmann wrote:
> Happy new year!!
> We have a meeting in exactly two weeks.
> Any projects you're working on that you'd like to share? Updates on
> projects you were working on last year? Some interesting topic from a
> class you can share? Please, send a meeting topic proposal.
> I'd love to create a list of presentations for the next several
> I can offer: PostgreSQL Version 8.3: 10 new things you can use right
I'd be interested to do a talk on the Relational Model (Note: not the
same as the Relational Algebra talk by James and Rafael, but related).
Is there any interest in that?
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
In response to
pdxpug by date
|Next:||From: Rich Shepard||Date: 2008-01-04 14:51:23|
|Subject: Aliases for Field Names in SELECT statements|
|Previous:||From: Jeff Davis||Date: 2008-01-04 01:48:51|
|Subject: Re: Call for meeting topics! Next meeting: January 17|