Re: [ADMIN] Installing PostgreSQL on Fedora from RPM

On Thursday 13 May 2004 09:36, Raul Secan wrote: I just want to install the latest PostgeSQL database server (7.4.2). I am running a Red Hat Fedora Core 1 OS, and I just found a link (ftp://ftp10.us.postgresql.org/pub/postgresql/binary/v7.4.2/fedora/fedora-c ore-1/) where I can download the

Re: [ADMIN] co existance of tsearch V1 and V2 in same database.

Oleg Bartunov wrote: On Tue, 10 Feb 2004, Rajesh Kumar Mallah wrote: Greetings, Can tsearch V1 and V2 exist in the same database simultaneously? I have read in past that its difficult , but is it possible for the desperate? quite peacefully, no problem Thank You, thats a releif to know.

[ADMIN] How do I grant access to entire database at once(schemas,tables,sequences,...)?

Hi ! I administrate a development server for a little team, and people want to be able to grant access to an entire database to other developers/freelancers. Up till now, I see two possibilities : 1. Write a script that queries the postgres internal tables for all

[ADMIN] Data/Index consistency checking in PostgreSQL

Hi, I would like to know if PostgreSQL (7.2.4) supports any scripts/utilities to check for data/index consistency of a database. This could be useful in case of the server crash or some data on the disk getting corrupted. Informix provides the tools 'oncheck' and 'archecker' to perform

Re: [ADMIN] How to determine if ODBC was compiled in?

perhaps you misunderstood my question. I downloaded a binary package off the Debian website. How do I determine what options it was compiled with? That is my question. Jared [EMAIL PROTECTED] (Peter Eisentraut) wrote in message news:[EMAIL PROTECTED]... Jared Evans wrote: How would I

[ADMIN] How do I grant access to entire database at once(schemas,tables,sequences,...)?

Hi ! I administrate a development server for a little team, and people want to be able to grant access to an entire database to other developers/freelancers. Up till now, I see two possibilities : 1. Write a script that queries the postgres internal tables for all

Re: [ADMIN] How do I grant access to entire database at once(schemas,tables,sequences,...)?

Ulrich Meis wrote: 1. Write a script that queries the postgres internal tables for all tables,schemas,sequences,views,functions,... and then executes grant statements for each one of them. This would have to repeated each time a new object is created. Yes, that's the most popular method so

[ADMIN] Log msg

Hi,All, How to config log file to log statement without CONTEXT stuff? I want log query, but not the detail unless there is a problem, e.g. Delete aaa from mytable where mysqlfunction(bbb); I want log this statement, but not any CONTEXT inside mysqlfunction, because it will easily filled up

Re: [ADMIN] Keep a user from creating tables ?

Stephan, Thanks for the info, but alas, no success. I have: List of database users User name | User ID | Attributes ---+-+ testuser | 100 | postgres | 1 | superuser, create database And as postgres I ran: REVOKE

Re: [ADMIN] Keep a user from creating tables ?

On Mon, 17 May 2004, Gregory S. Williamson wrote: Stephan, Thanks for the info, but alas, no success. I have: List of database users User name | User ID | Attributes ---+-+ testuser | 100 | postgres | 1 |

Re: [ADMIN] Keep a user from creating tables ?

Of course ... implicit in the docs if I reread them. Thanks very much for the tip ... G -Original Message- From: Stephan Szabo [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 1:45 PM To: Gregory S. Williamson Cc: [EMAIL PROTECTED] Subject: Re: [ADMIN] Keep a user from creating

[ADMIN] Hardware Platform

Title: Hardware Platform I'm working on a project using PostgreSQL as our database designing a budget system. We are still in the design and testing phases but I thought I would ask advice about a platform to host this system. We aren't a large system, probably no more than 50-75 users at

Re: [ADMIN] Log msg

Jie Liang wrote: Hi,All, How to config log file to log statement without CONTEXT stuff? I want log query, but not the detail unless there is a problem, e.g. Delete aaa from mytable where mysqlfunction(bbb); I want log this statement, but not any CONTEXT inside mysqlfunction, because it will