Re: [ADMIN] Readline support in psql -- worked earlier for me

Loosely related: Fedora is apparently not the only Linux distribution showing a hard-to-explain predilection for messing with readline. With one particular debian-etch-based distro (voyage linux), having ~/.inputrc with just "set editing-mode vi" results into bash using ksh completion keybindings.

Re: [ADMIN] Regarding access to a user

Dear Kevin Thanks for the help. But still the user is able to see all the databases. I defined something like this # IPv4 local connections: hostall all 127.0.0.1/32 md5 hostHMRI_database hmri127.0.0.1/32 md5 in the above case hmri is user and HMR

Re: [ADMIN] Regarding access to a user

> From: [EMAIL PROTECTED]> To: [EMAIL PROTECTED]> CC: [EMAIL PROTECTED]; [EMAIL > PROTECTED]; pgsql-admin@postgresql.org> Date: Thu, 21 Aug 2008 14:23:51 > +0530> Subject: Re: [ADMIN] Regarding access to a user> > Dear Kevin> Thanks > for the help. But still the user is able to see all the d

Re: [ADMIN] Regarding access to a user

Dear Vishal Thanks for the help but by doing this an error is generated at the time when the user is trying to log in with the following message: " Access to database denied The server doesn't grant access to the database: the server reports FATAL: no pg_hba.conf entry for host "127.0.0.1", user

Re: [ADMIN] Regarding access to a user

On 2008-08-21 10:53, Shashwat_Nigam wrote: > hostall all 127.0.0.1/32 md5 > hostHMRI_database hmri127.0.0.1/32 md5 > in the above case hmri is user and HMRI_database. But still when user > is log in as 'hmri' it is able to access all the databases.

Re: [ADMIN] Regarding access to a user

Dear Tomasz I had done the same but still the problem is like that the user is able to access all the databases in the current server. Even the order is like same and if I comment the second line(all access) then the error is there. Please provide solution for the same. Thanks & Regards, Shashwa

Re: [ADMIN] Regarding access to a user

Hi Shashwat, I presume your user is hmri and the database is hmri_database, is it correct? if yes - your pg_hba.conf entry should be as following (if you are connecting to postgres on the same machine) host hmri_database hmri 127.0.0.1/32 md5 Can you tell me what command are you using to co

Re: [ADMIN] Regarding access to a user

On 2008-08-21 11:12, Shashwat_Nigam wrote: > I had done the same but still the problem is like that the user is > able to access all the databases in the current server. Even the > order is like same and if I comment the second line(all access) then > the error is there. You did issue "pg_ctl rel

Re: [ADMIN] Regarding access to a user

Hi Vishal Ya you are right and the order is same and the command is like that only. I am opening it through pgAdmin only.. Thanks & Regards, Shashwat Nigam | Software Engineer | Geographical Information System Satyam Computer Services Limited, Hyd

Re: [ADMIN] Regarding access to a user

From: [EMAIL PROTECTED]: [EMAIL PROTECTED]; [EMAIL PROTECTED]: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]: Thu, 21 Aug 2008 14:55:05 +0530Subject: Re: [ADMIN] Regarding access to a user Hi Vishal Ya you are right and the order is same and the command is like that only. I

Re: [GENERAL] [ADMIN] Regarding access to a user

Shashwat_Nigam wrote: > Thanks for the help. But still the user is able to see all > the databases. I defined something like this > > # IPv4 local connections: > hostall all 127.0.0.1/32 md5 > hostHMRI_database hmri127.0.0.1/32 md5 > > > in the ab

[ADMIN] privilege shedding

Is there a way to non-reversibly shed privilige within a PostgreSQL session? I would like to start a session as a superuser role, set up some views and triggers as superuser, and then change role to a lesser role for the remainder of the session. It seems that if you use 'set role' for this, you

Re: [ADMIN] pg_log directory

On Wed, Aug 20, 2008 at 9:38 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > That's just the server message log. While you could blow away the files > without any ill effect, soon enough you'd have another 40GB. You need > to either dial down the verbosity of your what-to-log settings, or > modify the

Re: [ADMIN] pg_log directory

"slamp slamp" <[EMAIL PROTECTED]> writes: > I am using the PGDG rpms. So it has the default logging configs. its > rotating daily but i have files there since 2007. With the RPM's logging config you should only have seven daily log files in pg_log. Could we see an ls -l of the pg_log directory?

Re: [ADMIN] privilege shedding

>>> dkeeney <[EMAIL PROTECTED]> wrote: > Is there a way to non-reversibly shed privilige within a PostgreSQL > session? > I would like the role > change to persist through the life of the session, without the option > of restoring the superuser role. We could use this in certain circumstance

[ADMIN] Query performance difference

Hello, I have a question regarding query performance from two pgsql applications. PGadmin III 1.8 and Navicat for postgresql 8. Both connected to same server on local machine 8.3 and runs a same query for appox. 1,60,000 rows with one min, one max and addition of the min and max values on two table

Re: [ADMIN] Query performance difference

It may be worth-wile to generate an explain plan http://www.postgresql.org/docs/8.3/interactive/sql-explain.html From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of c k Sent: Thursday, August 21, 2008 2:49 PM To: [EMAIL PROTECTED]; pgsql-admin@postgresql.org Subject: [ADMIN] Query

[ADMIN] ssl support in XA Datasource

Hi, I would like to know if PostgreSQL 8.2 supports SSL via XA datasource. I am using JBoss EAP 4.3 for making jdbc connections. Below is my datasource: Res1 org.postgresql.xa.PGXADataSource 148.147.162.57 5432 postgres true postgres postgres