[ADMIN] Best practice to create a read-only user?

ect on all tables in schema zzz to uuu; So I only added the grant usage and it worked fine. What do people use day to day? I had frankly never explored the default_transaction_read_only parameter ... -- regards Matthias Ritzkowski -marlinmobile- -- Sent via pgsql-admin mailing list (pgsql-

[ADMIN] introduction

s. So I am not feeling so warm and fuzzy about them. Thank you in advance for any pointers! -- Kind Regards Matthias -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Users and Roles

. > Hello Sidar! Perhaps you should read these pages in the documentation: http://www.postgresql.org/docs/8.2/interactive/user-manag.html and following. Greetings, Matthias ---(end of broadcast)--- TIP 3: Have you checked our exten

Re: [ADMIN] Postgresql Upgrade 7.4 to 8.2

> > Any insights on upgrading will also help. > > Thank you, > Radhika > Hello! About upgrading you should read these links: http://www.postgresql.org/docs/8.2/interactive/install-upgrading.html and http://www.postgresql.org/docs/8.2/interactive/migration.html G

Re: [ADMIN] Upgrading from 7.4 to 8.2

://www.postgresql.org/docs/8.2/interactive/migration.html Good luck! Greetings, Matthias > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Rickard Sjöström > Sent: Tuesday, December 19, 2006 10:04 AM > To: pgsql-admin@postgresql.org

Re: [ADMIN] Troubles with Ident Authetication

Hm, perhaps you should check the logs if the identd is working correctly. Greetings, Matthias > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Rodrigo Tavares > Sent: Friday, December 15, 2006 1:08 PM > To: pgsql-admin@postgresq

Re: [ADMIN] 8.2.0 bug :)

Hm, i can't see any bug here: template1=# \di+ No relations found. template1=# Works also on a database with existing indexes. Greetings, Matthias > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Gábriel Ákos > Sent: Tuesday, De

Re: [ADMIN] FastCgi / PostgreSQL: FATAL: Ident authentication fai

other tests is the environment. With psql your in a shell with the correct user. I hope this help. -- Matthias > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of binberati > Sent: Wednesday, October 18, 2006 4:35 AM > To: pgsql-admin@post

Re: [ADMIN] How to install postgreSQL 8.1.4 on RHEL -ES 4

Title: Nachricht Hello Vinayak!   Unpack the archive and read the INSTALL file inside it for installation instruktions. The administration and user guide you can find here: http://www.postgresql.org/docs/8.1/interactive/index.html   Greetings, Matthias -Original Message-From

Re: [ADMIN] Where is the msi-setup described ?

just rules for localhost. One is for IPv4, the other for IPv6. Further explanations can be found at http://www.postgresql.org/docs/8.1/interactive/client-authentication.html   Greetings, Matthias -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of

[ADMIN] how to handle larger databases?

I am currently creating a database which will have less than 20 quite simple tables. Unfortunately, some of those tables will have more than 1 million entries. In order to maintain fairly good query times I would like to ask for some tips on how I should organize that database, what I should do or