[ADMIN] IDENT auth. problem

Hi All, I am experiencing strange behaviour with psql. I normally log with authentication type: ident sameuser I have just exited from a psql session where I dropped a table and then immediately logged back in and now I am getting: - IDENT authentication failed for user 'postgres' I have

[ADMIN] Authentication Problems

Hi all, I have a problem that may not be directly to do with postgres but I can't seem to figure it out. I have a linux redhat server with apache and postgres 7.0 runing on the same machine. I am trying to sort out authentication so that local clients can connect to the databases using 'ident

[ADMIN] error Backing up DB

I am getting the following error when using pg_dump (v 7.0 on linux) getTables(): relation 'client': cannot find function with oid 1654 for trigger RI_ConstraintTrigger_7406341 And when I try and look at the functions using /df I get the following error - ERROR: Function

RE: [ADMIN] Index usage ?

I am having similar problems at the moment, the query planner seems to be a little out when deciding which method to use. I disabled the use of seq scans using SET ENABLE_SEQSCAN = NO; and the query that used to take 3.03 minutes now takes 5-7 secs. (v7.0 approx 3.5 million rows) However this

[ADMIN] Still confusion with security...

I am still a little confused as to how the security works in postgres. I am doing the following: - 1) Creating a unix user 'dpdba' who will effectively be the DBA for the database 2) Create the postgres user $createuser dpdba (specifying the same unix ID and all privliges) 3) Change user to

[ADMIN] Authentification problems with local connections

I am trying to restrict access to my databases by adding the following lines to the pg_hba.conf file: - localdpstatisticpassword localdetailspassword host all 127.0.0.1 255.255.255.255