[ADMIN] upgrade 8.0.3 -> 8.2.4

2007-05-09 Thread Steve Holdoway
Are there any gotchas? I've got the opportunity to move to another database server for this application and yould like to take the opportunity to upgrade at the same time. tia, Steve ---(end of broadcast)--- TIP 7: You can help support the Postgr

[ADMIN] gotchas upgrading 8.0.3 to 8.2.4??

2007-05-09 Thread Steve Holdoway
I'm in the enviable position of migrating postgres database from the current machine to a dedicated server platform. I would also like to take the opportunity to upgrade the version of postgres to current. Does anyone know of any gotchas in this process that I should be especially looking out f

Re: [ADMIN] finding fragmented tables

2007-05-09 Thread Dan Harris
Dan Harris wrote: Carin Westblom wrote: How can I easily find specific tables and/or databases with a lot of space that may be reclaimed w a vacuum full? I picked up this tip on the list a while ago: SELECT pg_namespace.nspname, pg_class.relname, pg_class.reltuples, pg_class.relpages, roww

Re: [ADMIN] finding fragmented tables

2007-05-09 Thread Dan Harris
Carin Westblom wrote: How can I easily find specific tables and/or databases with a lot of space that may be reclaimed w a vacuum full? I picked up this tip on the list a while ago: SELECT pg_namespace.nspname, pg_class.relname, pg_class.reltuples, pg_class.relpages, rowwidths.avgwidth, cei

[ADMIN] finding fragmented tables

2007-05-09 Thread Carin Westblom
How can I easily find specific tables and/or databases with a lot of space that may be reclaimed w a vacuum full? Thanks Carin Westblom

Re: [ADMIN] Revoking usage of pg_catalog

2007-05-09 Thread John DeSoi
On May 9, 2007, at 2:09 PM, Daniel Cristian Cruz wrote: It's a web application user. I was trying to make some database magic, hardening SQL injections... But its wrong, the application must be secure. Unfortunelly I can't have a database user for each web user... I don't see the issue if use

Re: [ADMIN] Revoking usage of pg_catalog

2007-05-09 Thread Daniel Cristian Cruz
2007/5/9, Scott Marlowe <[EMAIL PROTECTED]>: On Wed, 2007-05-09 at 08:05, Daniel Cristian Cruz wrote: > Hi there! > > Is it possible to revoke usage of pg_catalog for a specific user? > > The reason is to secure PostgreSQL. If a user can connect to a > database, it could query pg_class, pg_attrib

Re: [ADMIN] Revoking usage of pg_catalog

2007-05-09 Thread Scott Marlowe
On Wed, 2007-05-09 at 08:05, Daniel Cristian Cruz wrote: > Hi there! > > Is it possible to revoke usage of pg_catalog for a specific user? > > The reason is to secure PostgreSQL. If a user can connect to a > database, it could query pg_class, pg_attribute, pg_proc search for > specific tables and

Re: [ADMIN] Revoking usage of pg_catalog

2007-05-09 Thread Tom Lane
"Daniel Cristian Cruz" <[EMAIL PROTECTED]> writes: > Is it possible to revoke usage of pg_catalog for a specific user? No, not if you'd like them to be able to do anything useful. regards, tom lane ---(end of broadcast)--- T

[ADMIN] Revoking usage of pg_catalog

2007-05-09 Thread Daniel Cristian Cruz
Hi there! Is it possible to revoke usage of pg_catalog for a specific user? The reason is to secure PostgreSQL. If a user can connect to a database, it could query pg_class, pg_attribute, pg_proc search for specific tables and if using dblink, even database passwords... I just made a test, revo