Re: [ADMIN] Users and Roles

-Original Message- How can I create a role and some reestrictions on it? The case is that I have many databases and thousands of users, I need to create users and these users can only connect to only one database and no more. Please help me. Hello Sidar! Perhaps you

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 Greetings, Matthias

Re: [ADMIN] Upgrading from 7.4 to 8.2

Hi Rickard! As far as i know you will have to dump and restore the databases for the upgrade since a lot of internals have been changed from 7.4 to 8.2. A description on how to upgrade can be found here: http://www.postgresql.org/docs/8.2/interactive/install-upgrading.html And here:

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@postgresql.org Subject: [ADMIN]

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, December 12, 2006 1:28

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

Hello! Your problem is that you have the pg_hba.conf set to do an ident authentication if the connection comes from localhost - this is the default setting imho. Your password settings the in the settings.py won't work since your process will run under the Apache user, nobody or www-data usually.

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 ?

Title: Nachricht Hi Josef! You need a line looking like this one: host all all 0.0.0.0 0.0.0.0 md5 This would enable every client to connect to all databases on the server with using MD5 hashed passwords. The two lines posted by you are just rules for localhost. One is for IPv4, the