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 RPM's, but I don't know which of them I need, for the server to run succesfuly. At minimum, you will need the main package, -lib, and -server. The reason that they are split like they are is so that minimal clients can be installed: all that custom clients would need is -lib. Slightly more client functionality is available with the main package plus -lib (this adds a lot of documentation and all the man pages), and the minimal server adds -server. From there the pieces are a little more obvious, I hope, from the subpackage name. Also I don't know the procedure to install PostgrSQL from RPM. Download the packages you need, then install them all on a single command line (or using a graphical client). The command line would be something like 'rpm -ivh postgresql*.rpm' Installing all on a single command line is the best way, then rpm can deal with the dependencies properly. If you run across other dependencies you'll need to install those packages separately (for instance, the python subpackage requires the 'mx' package from the main OS install). -- Lamar Owen Director of Information Technology Pisgah Astronomical Research Institute 1 PARI Drive Rosman, NC 28772 (828)862-5554 www.pari.edu ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
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. regds mallah. regds mallah. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---(end of broadcast)--- TIP 8: explain analyze is your friend ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[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 tables,schemas,sequences,views,functions,... and then executes grant statements for each one of them. This would have to be repeated each time a new object is created. 2.(Not sure if this works) Insert a trigger on postgres's internal tables in template1 that grants permission to a group, say dbname_group, to the created object. Developers that need access to the database can then be added to that group. Both solutions require a serious amount of work compared to the simple task. Is there a simpler or better way to do this? Thanks for any ideas and comments! greetings, Uli ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[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 data-/index- and backup-consistency-checks. Are there similar tools available for PostgreSQL? Can anybody help? Thanks in advance... Saket. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
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 determine if the Debian Postgresql package I installed was configured with --enable-odbc option? This is fairly uninteresting, since all this switch controls is whether the ODBC driver gets built. Clearly, there is a Debian package for the ODBC driver. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[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 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. 2.(Not sure if this works) Insert a trigger on postgres's internal tables in template1 that grants permission to a group say dbname_group to the created object. Developers that need access to the database can then be added to that group. Both solutions require a serious amount of work compared to the simple task. Is there a simpler or better way to do this? Thanks for any ideas and comments! greetings, Uli ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
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 far. You could also write a stored procedure. 2.(Not sure if this works) Insert a trigger on postgres's internal tables in template1 that grants permission to a group say dbname_group to the created object. Developers that need access to the database can then be added to that group. Triggers on system tables don't work. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[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 my disk if mytable have millions of entries, meanwhile, the log file become useless. But if I set log_statement = true, log file will log millions of statement in mysqlfunction, but I set log_statement=false, log file won't log query at all. Simply say, I want log what I execute(my query), but not how execute (process) . Jie Liang ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster ---(end of broadcast)--- TIP 8: explain analyze is your friend
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 ALL ON SCHEMA public FROM testuser; Then I connect: psql -d testdb -U testuser (I should not even be able to connect ?) And I run: CREATE TABLE foo (man INT, choo(VARCHAR(20)); And it works ... Am I misundertanding something, or is it simply not possible to prevent users from creating tables ? In Informix this quite easy: REVOKE RESOURCE FROM testuser; I am puzzled at postgres' documentation, and perhaps at its underlying logic. Any help would be appreciated -- this is sort of important. Thanks! Greg W. -Original Message- From: Stephan Szabo [mailto:[EMAIL PROTECTED] Sent: Mon 5/17/2004 8:03 AM To: Gregory S. Williamson Cc: [EMAIL PROTECTED] Subject:Re: [ADMIN] Keep a user from creating tables ? On Sun, 16 May 2004, Gregory S. Williamson wrote: In postgres 7.4, is there any way to stop a user from creating tables in a given database ? Make the user not have rights to create objects in any schemas. Most likely you'd only need to change the public schema, but if you've granted create rights for other schemas you'll need to revoke those as well. ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
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 | superuser, create database And as postgres I ran: REVOKE ALL ON SCHEMA public FROM testuser; I forgot to mention something which led to the confusion. testuser doesn't probably have permissions on the public schema, but public (all users) does. You probably need to revoke it from PUBLIC and grant it to the users who should have creation rights to public. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
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 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 | superuser, create database And as postgres I ran: REVOKE ALL ON SCHEMA public FROM testuser; I forgot to mention something which led to the confusion. testuser doesn't probably have permissions on the public schema, but public (all users) does. You probably need to revoke it from PUBLIC and grant it to the users who should have creation rights to public. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[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 any one time. From a data standpoint I can't guess at the number of gigabytes but suffice to say it is not going to be that large. Our biggest table will probably hold about 1 million rows and is about 120 bytes (closer to about 100). Dell and HP servers are being mentioned but we currently have no preference. Any help you could provide will be appreciated. Thanks, Duane P.S. I've only just begun using PostgreSQL after having used (and still using) DB2 on a mainframe for the past 14 years. My experience with Unix/Linux is limited to some community college classes I've taken but we do have a couple of experienced Linux sysadmins on our team. I tell you this because my ignorance will probably show more than once in my inquiries.
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 easily filled up my disk if mytable have millions of entries, meanwhile, the log file become useless. But if I set log_statement = true, log file will log millions of statement in mysqlfunction, but I set log_statement=false, log file won't log query at all. Simply say, I want log what I execute(my query), but not how execute (process) . Decrease the verbosity of your logs using: log_error_verbosity = terse Regards Gaetano Mendola ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings