[HACKERS] PAM authentication fails for local UNIX users
Hi all, http://archives.postgresql.org/pgsql-admin/2003-02/msg00301.php I also try to address the same issue.. I run postmaster as postgres user and pg_hba.conf includes the following entry: local all dhanaraj pam However, the authentication fails for this unix local user, whereas it works for LDAP users. bash-3.00$ psql -h superdesktop.india.sun.com -U dhanaraj mydb Password for user dhanaraj: psql: FATAL: PAM authentication failed for user dhanaraj The following error message that I could see in the server log: .. LOG: pam_authenticate failed: Conversation failure FATAL: PAM authentication failed for user dhanaraj LOG: pam_authenticate failed: No account present for user FATAL: PAM authentication failed for user dhanaraj The non-root user does not have the permission to read other unix local user password. I found two solutions: 1. usermod -K defaultpriv=Basic,file_dac_read postgres - Gives privilege to read all files. This solution works. Is it the right way to do? 2. chmod +s processName - This does not work, because postgres never allows this. Is there anyother solution to this problem? Thanks Dhanaraj ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[HACKERS] Replacement of readline by libedit in PostgreSQL 8.1.x
Hi all, In 8.2.x version of postgres, there is a configuration switch --with-libedit-preferred prefer BSD Libedit over GNU Readline. However, I don't see this switch in 8.1.x. Since people still use 8.1.x version, is there any plan to back-port this feature? If so, I like to work on this. Thanks Dhanaraj ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] [PATCHES] Allow the identifier length to be increased via a
Tom Lane wrote: Alvaro Herrera [EMAIL PROTECTED] writes: Dhanaraj M wrote: I am sending the patch for the following TODO item: Allow the identifier length to be increased via a configure option You should use pg_config.h, not mangle postgres_ext.h like that. Or maybe generate postgres_ext.h from an hypotetical postgres_ext.h.in (but I wouldn't do that, really). I'm wondering how this got into the TODO list. It seems rather pointless, and likely to create client compatibility problems (if not, why is NAMEDATALEN exported at all?) Will this TODO item be removed from the list? Or I shall proceed with the suggestions given. Thanks Dhanaraj ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] Clarification needed
In psql, psql\d tableName Query is SELECT pg_catalog.format_type(a.atttypid, a.atttypmod) from pg_attribute a, pg_class c where a.attrelid =c.oid and c.relname='TableName' and a.attname='ColName'; Zdenek Kotala wrote: Look at http://www.postgresql.org/docs/8.1/interactive/catalogs.html Specially on pg_attribute, pg_class and pg_type table. Or you can use some features in the psql. Zdenek Indira Muthuswamy napsal(a): Hai, Can anyone of you help me in finding the datatype of a particular column in a table in Postgres? Thanks and Regards, M.Indira ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[HACKERS] Is there any utility to update the table whenever text file gets changed?
Is there any utility in postgresql which can do the following? The utility must update the table whenever there is any change in the text file. COPY command helps to do that, though this is not straight forward. Can it be automated? Thanks Dhanaraj ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [HACKERS] [PATCHES] Patch - Have psql show current values
For \ds command, this patch displays the current sequence value(last_value) for each sequence. This was suggested during the earlier discussion. Output of the current patch: -- mydb=# \ds List of relations Schema | Name | Type | Owner | Seq Value +--+--+--+--- public | a| sequence | Dhanaraj | 5 public | b| sequence | Dhanaraj | 2 public | c| sequence | Dhanaraj | 1 (3 rows) output without aplying the patch mydb=# \ds List of relations Schema | Name | Type | Owner +--+--+--+- public | a| sequence | Dhanaraj public | b| sequence | Dhanaraj public | c| sequence | Dhanaraj (3 rows) Peter Eisentraut wrote: Dhanaraj M wrote: This patch was discussed a few months ago. I could not complete this patch at that time. I hope that the current version of my patch is acceptable. What is this patch supposed to be doing? ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[HACKERS] Security bugs
I heard that 2 security bugs were fixed in 8.1.4. Since I like to upgrade from 8.1.3, I like to know the bugs. Can somebody give the description of those bugs? Thanks Dhanaraj ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[HACKERS] Turning off disk caching
Hi Is there anybody who knows about Turning off disk caching in solaris machines. If so, pl. reply back. Thanks Dhanaraj ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[HACKERS] Performance Issues
I have the following doubts. 1. Does postgres create an index on every primary key? Usually, queries are performed against a table on the primary key, so, an index on it will be very useful. 2. If 'm executing a complex query and it takes 10 seconds to return the results -- it takes 10 seconds to execute the next time also. I'm wondering if there's any kind of caching that can be enabled -- so, the next time it takes 10 seconds to return the results. Thanks Dhanaraj ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] Performance Issues
Thank you for your help. I found that an implicit index is created for the primary key in the current version. However, it is not done in 7.x version. Mark Woodward wrote: Dhanaraj M wrote: I have the following doubts. 1. Does postgres create an index on every primary key? Usually, queries are performed against a table on the primary key, so, an index on it will be very useful. Yes, a unique index is used to enforce the primary-key. Well, here is an interesting question that I have suddenly become very curious of, if you have a primary key, obviously a unique index, is it, in fact, use this index regardless of analyzing the table? 2. If 'm executing a complex query and it takes 10 seconds to return the results -- it takes 10 seconds to execute the next time also. I'm wondering if there's any kind of caching that can be enabled -- so, the next time it takes 10 seconds to return the results. Not of query results. Obviously data itself might be cached. You might want to look at memcached for this sort of thing. I am looking at this string of posts and it occurs to me that he should run analyze. Maybe I'm jumping at the wrong point. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [HACKERS] Clarification required
The server log file means the files that are in pg_xlog. or some more/some other files? The log files in pg_xlog dir are not human readable. How is it useful on the client side? Dave Page wrote: could not understand the following TODO item. Can anyone explain this. Monitoring: = Allow server logs to be remotely read and removed using SQL commands Does it mean that the server log file should be read by the client? What kind of removal (using SQL)? This is possible using the functions in the adminpack contrib module that's currently in the patch queue: http://candle.pha.pa.us/mhonarc/patches/msg6.html Also I like to know where the server log file is stored. Check your postgresql.conf file. Regards, Dave. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[HACKERS] Clarification required
I could not understand the following TODO item. Can anyone explain this. Monitoring: = Allow server logs to be remotely read and removed using SQL commands Does it mean that the server log file should be read by the client? What kind of removal (using SQL)? Also I like to know where the server log file is stored. Thanks Dhanaraj ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[HACKERS] Need some clarification
I could see the following in TODO list but I am not clear what is expected out of this. Can anyone explain this? 1. *Allow VIEW/RULE recompilation when the underlying tables change * *Another issue is whether underlying table changes should be reflected in the view, e.g. should SELECT * show additional columns if they are added after the view is created. * Dropping/altering column is not allowed in the above mentioned scenario. Only it fails for (select *) What are the other cases in which it fails? 2. *Invalidate prepared queries, like INSERT, when the table definition is altered *Invalidation means recompilation or deletion of the prepared stmt here.* *Both the items look similar. i.e) needs recompilation of the query after altering the table. It is right?* * ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[HACKERS] Need a help - Performance issues
I am currently looking at some performance issues. Our product uses the postgres as the backend and it uses a huge storage space. Is there a script available, which does the following: 1. When you point it to a postgres installation, - 1.the script first identifies what platform (solaris-sparc/solaris x86/ Niagara) it is running on, 2. walks through all known tuning parameters (in /etc/system and postgresql.conf) on the system 3. lists out what parameters are optimal/suboptimal for that platform, and makes recommendations. 4. identifies when the last vaccumdb /fullvacuum (and other such database health maintenance commands) were run 5. comments about the growth of certain tables/databases If any body has the scripts or can give some links which could be useful for our group. Thanks Dhanaraj ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[HACKERS] bug# 2073 - Clarification
Bug- raised: = BUG #2073: Can't drop sequence when created via SERIAL column Answered: Right. We have this TODO item: * %Disallow changing default expression of a SERIAL column? which would prevent you from changing the default expression for a SERIAL column. So the answer is, don't do that, and in the future, we might prevent it. Clarification required: = Pl. look at the following code, which is taken from alter_table.sql (regression test) = mydb=# create table anothertab (atcol1 serial8, atcol2 boolean, constraint anothertab_chk check (atcol1 = 3)); NOTICE: CREATE TABLE will create implicit sequence anothertab_atcol1_seq for serial column anothertab.atcol1 CREATE TABLE mydb=# alter table anothertab alter column atcol1 drop default; ALTER TABLE mydb=# \d List of relations Schema | Name | Type | Owner +---+--+-- public | anothertab| table| dm199272 public | anothertab_atcol1_seq | sequence | dm199272 (2 rows) mydb=# drop sequence anothertab_atcol1_seq; ERROR: cannot drop sequence anothertab_atcol1_seq because table anothertab column atcol1 requires it HINT: You may drop table anothertab column atcol1 instead. = Please tell me whether statement-2 is valid or not (as you say that the default sequence should not be changed). Or the default seq. can be dropped and cant be changed. I like to know the expected output. Thanks Dhanaraj ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[HACKERS] TODO items..
I saw the following in the TODO list. I am currently trying to work on them. I could not understand clearly what needs to be done. Can anybody give me the details for the following so that I can work on? clients-psql = 1. Have psql show current values for a sequence 2. Fix psql's display of schema information (Neil) Please explain me the current feature that is supported and expected out of it. Thanks Dhanaraj ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[HACKERS] How to create the patch?
Hi all I fixed a bug. I downloaded the recent version of postgres using CVS. I made the changes and tested. I dont know how to create a patch. Should i login and execute diff command? Can u explain the steps in detail?? Please help me in this regard.. Thanks Dhanaraj ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[HACKERS] How to put back??
Hi all, I have recented joined and working on postgres. I fixed a bug that I saw in the mailing list. I ran the regression test that is available in postgres. It was successful and now I need the following details.. 1) Test suits that i could get to test my code.. 2) How can I put back my fix into postgres src code.. (or) What is the procedure that I should follow at this stage?? Waiting for your suggestions, Thanks Dhanaraj ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org