[ADMIN] Compilation error

1998-07-31 Thread Pedro Aguilar
Hi, I'm new with postgres and I want to install the new version. I have Linux RH5.0 with the old version but I never used it. While I'm compiling, after a minute it shows the next error message: > gmake -C parser all > gmake[2]: Entering directory `/usr/src/pgsql/src/backend/parser' > /usr/b

[ADMIN] Authentication Problems

1998-07-31 Thread G.Elangovan
Please suggest me what are all the way i can implement AUTHENTICATION on USER , DATABASE and TABLE. As i have seen, to my knowledge i understood we can implement Grant and Revoke on table But how can we do the same on the DATABASE There is a password attribute in pg_shadow how can this be used t

Re: [ADMIN] Limits on Tables?

1998-07-31 Thread Gerald Brandt
Hi there, Okay, I've created a test. The test has 100 projects, and each project has 500 entries. So basically it created 500 new tables, and 5 records. Speed difference is negligible. I do not notice a slowdown, although I have not done actual timing tests. Today, I will add 50 more pro

[ADMIN] Back-up through SQL!!!!

1998-07-31 Thread G.Elangovan
Hello All, I am looking for the SQL that Alows me to back up databases through SQL and not using pg_dump and pg_dumpall. Has anybody experienced the inconsistency for performance of pg_dump? It is giving me lot of problems while using through Python Interface. Any Help will be highly apprec

[ADMIN] Cannot get debug messages

1998-07-31 Thread Maarten Boekhold
Hi, Last night I had trouble getting user authentication working with type 'password' ('crypt' works just fine), and to see what was going on in the postmaster, I wanted to turn on some debugging. But no matter what option I tried (-d 1--3 for postmaster, -d 1--3 for backend), I couldn't get