Re: [ADMIN] Cannot connect to the database (PG 7.3)

it is at connect-time, so there is nothing done with set session authorization. I just want to connect, and read data from a table to which the group the user is in has read-access. I have tried if it would differ when I try to connect with a user created like: CREATE USER 20020003 WITH ENCRYPTED

[ADMIN] Index Scan Backward

Hi all, I'm experiencing a strange problem in the usage of indexes for query optimization. I'm runnig a forum application that uses a PostgreSQL DB. The version on the DB is 7.2.3 but I've also tested it under 7.3.1 but I had no luck :( The problem is always the same. Linux distro is Slackware

Re: [ADMIN] Cannot connect to the database (PG 7.3)

Michiel Lange [EMAIL PROTECTED] writes: it is pretty strange... might it be a bug? I'm quite sure it's a bug in your code. Try turning on query logging so you can see what queries are being issued; maybe that will help solve the problem. regards, tom lane

Re: [ADMIN] Index Scan Backward

Luca Fabbro [EMAIL PROTECTED] writes: It seems that the problem is in the Backward scan of the index :( It looks like a pretty reasonable plan to me. Could we see the output of EXPLAIN ANALYZE, not just EXPLAIN? regards, tom lane ---(end of

Re: [ADMIN] Index Scan Backward

At 09.39 27/01/2003 -0500, you wrote: Luca Fabbro [EMAIL PROTECTED] writes: It seems that the problem is in the Backward scan of the index :( It looks like a pretty reasonable plan to me. Could we see the output of EXPLAIN ANALYZE, not just EXPLAIN? Thanks Tom for your interest. It looks

Re: [ADMIN] Index Scan Backward

Luca Fabbro [EMAIL PROTECTED] writes: Limit (cost=0.00..1003.36 rows=1 width=454) (actual time=806.78..2097.61 rows=1 loops=1) - Nested Loop (cost=0.00..392651.18 rows=391 width=454) (actual time=806.77..2097.59 rows=2 loops=1) - Index Scan Backward using

[ADMIN] help about postgres

Hi, My name is Oscar, and i am working with Postgres. I want to know if: can i change of lenguage error's menssages of Postgres? I need spanish menssages no english menssages. Can you help me, please. ---(end of broadcast)--- TIP 6: Have

[ADMIN] New User - Please Help

I know this is extremely remedial and trival for most of you - but I am a very new user, and need to know what I have to do to get my database instance created? Anyone that has a cheatsheet or something they can send me would also be greatly appreciated. I am a 10+ year veteran of Oracle 6.0

Re: [ADMIN] Cannot connect to the database (PG 7.3)

but, but it is even with the psql command... it will differ if I put a -U parameter with postgres or 20020003 postgres, michiel or most other names will connect fine, however the user 20020003 will not... I get that FATAL error... all users should be able to connect to the database,

[ADMIN] FSM settings -- how to tell if they are working?

We have both test and production databases, about 10 GB total in each. Recently, I learned about max_fsm_pages and max_fsm_relations. To get a feel for what changing these settings would do to our production database, I set the following values in the test database: max_fsm_relations = 100

Re: [ADMIN] Replication

Andrew Sullivan [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... We are currently using eRServer for the .info registry, and starting next week it will also underpin the .org registry. Dunno if that's good enough performance for you. It works for us. the

Re: [ADMIN] Length of Varchar

Also, it only really works well for lengthening columns. If you shorten them, the old values will remain their original longer length. --- Tom Lane wrote: Robert Treat [EMAIL PROTECTED] writes: There is a gamblers

Re: [ADMIN] New User - Please Help

Michael, This is a good place to start: http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/tutorial- start.html If you're still having trouble after reading all the docs, please feel free to post a question to the list. --Jeremy On Monday, January 27, 2003, at 08:44 AM, Michael

Re: [ADMIN] VACUUM warning message.

I assume this is 7.2.X. I know this is fixed in 7.3.1 but I am not sure what release we fixed it in. The HISTORY file doesn't have a specific mention of the fix. It is not something to be worried about, as I remember.

Re: [ADMIN] Cannot connect to the database (PG 7.3)

Michiel Lange [EMAIL PROTECTED] writes: but, but it is even with the psql command... Hmm. You didn't by any chance put a SET for session_authorization into the per-user settings for 20020003, did you? Or the per-database settings for whichever database he's trying to connect to? Look at

Re: [ADMIN] VACUUM warning message.

Bruce Momjian [EMAIL PROTECTED] writes: I assume this is 7.2.X. I know this is fixed in 7.3.1 but I am not sure what release we fixed it in. The HISTORY file doesn't have a specific mention of the fix. It is not something to be worried about, as I remember. Mmm, I'm not sure. The known

Re: [ADMIN] Replication

On Mon, Jan 27, 2003 at 07:38:29PM +0100, Gaetano Mendola wrote: the eRServer is for free or not ? Not, as far as I know. Its baby cousin is in contrib/rserv in the source tree. I haven't tested it with 7.3, so I don't know whether it works. A -- Andrew Sullivan

[ADMIN] Python DB-API problem with PostgresSQL pgdb.

The Python DB-API (2.0) specifies that on creation a connection object is to start a transaction if the database supports them. The pgdb implementation of the DB-API does this: Begin Listing 1 class pgdbCnx: def __init__(self, cnx): self.__cnx = cnx

[ADMIN] restricting identd to just the loopback adapter.

I have installed running pg 7.2, and it apparently would like to have an identd server to help it establish who is who. I installed pidentd from the red hat 8.0 distribution and started it up but, but looking over the conf files, there is apparently no way to restrict identd to listening/binding

[ADMIN] New User - Please Help

I know this is extremely remedial and trival for most of you - but I am a very new user, and need to know what I have to do to get my database instance created? Anyone that has a cheatsheet or something they can send me would also be greatly appreciated. I am a 10+ year veteran of Oracle 6.0

Re: [ADMIN] VACUUM warning message.

[EMAIL PROTECTED] writes: Hmm i do the below daily to this table. And this is pgsql 7.3 TRUNCATE TABLE public.site_search; Drat. Now that I look at it, 7.3 TRUNCATE doesn't send any kind of relcache inval message, so it's got the same kind of problem that the nailed-in-cache catalogs do: other

Re: [ADMIN] Replication

On Mon, 27 Jan 2003, Andrew Sullivan wrote: On Mon, Jan 27, 2003 at 07:38:29PM +0100, Gaetano Mendola wrote: the eRServer is for free or not ? Not, as far as I know. Its baby cousin is in contrib/rserv in the source tree. I haven't tested it with 7.3, so I don't know whether it works.

Re: [ADMIN] Replication

I would give /contrib/dbmirror a try. --- Marc G. Fournier wrote: On Mon, 27 Jan 2003, Andrew Sullivan wrote: On Mon, Jan 27, 2003 at 07:38:29PM +0100, Gaetano Mendola wrote: the eRServer is for free or not ?