[ADMIN] Ideas for a read only user access on partitioned tables.

Hello folks: We are using postgres 8.4.4 as distributed in centos 5.5. We have a database that has a number of partitioned tables (http://www.postgresql.org/docs/8.4/interactive/ddl-partitioning.html). We would like to add a read only user who is allowed to access all the tables in the database

Re: [ADMIN] redhat and postgresql management

yum should have replaced potgresql-libs with compatible-postgresql- libs. If not, there may be something wrong with the repo. -- Devrim GÜNDÜZ PostgreSQL DBA @ Akinon/Markafoni, Red Hat Certified Engineer devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org

Re: [ADMIN] redhat and postgresql management

David Bear wrote: I have RHEL 5.4 (64bit) that has a postgresql-lib 8.1 installed to satisfy dependancy for a dozen other packages including apache, php and other apache modules, and subversion. I want to install postresql 8.3 but yum informs me of the version conflict of the library. May i s

Re: [ADMIN] redhat and postgresql management

David Bear writes: > I have RHEL 5.4 (64bit) that has a postgresql-lib 8.1 installed to satisfy > dependancy for a dozen other packages including apache, php and other apache > modules, and subversion. > I want to install postresql 8.3 but yum informs me of the version conflict > of the library.

Re: [ADMIN] redhat and postgresql management

I had a similar situation with other packages depending on /usr/lib64/libpq.so.4 owned by an old version of postgres-libs rpm. I solved this by acquiring compat-postgresql-libs-4-1pgdg.rhel5.x86_64.rpm from http://yum.pgsqlrpms.org/8.2/redhat/rhel-5-x86_64/repoview/compat-postgresql-libs.html T

[ADMIN] redhat and postgresql management

I have RHEL 5.4 (64bit) that has a postgresql-lib 8.1 installed to satisfy dependancy for a dozen other packages including apache, php and other apache modules, and subversion. I want to install postresql 8.3 but yum informs me of the version conflict of the library. May i safely just over write t

Re: [ADMIN] Need recommendation for PostgreSQL core developer/PostgreSQL admin

On Thu, 2010-06-17 at 17:27 -0400, Vineet Jain wrote: > Can someone recommend a PostgreSQL core developer/or experienced admin > who does some on demand consulting. I would like to purchase a 10-20 > hours of support and get support with > implementation/questions/best practices on replication/tab