PostgreSQL Database Forum

Dear all, I have a trouble with the pam authentification for PostgreSQL. I have add in the pg_hba.conf the good line ... and I have create a /etc/pam.d/postresql file which contains : auth required pam_unix.so nullok_secure account required pam_unix.so

We're developing a java app and are using postgres as the database. On our dev server I started the app, closed it, but the java process was still open so I killed it, which caused the above error. I've had to do this in the past but have not had this happen before. I've searched the archives and found a message/reply from Andrew Sullivan...

Hi, can anyone help me with this error: ERROR: missing chunk number 0 for toast value 14227980 Is there a solution? -- Diogo Biazus diogob@gmail.com http://www.postgresql.org.br

set pgsql-general digest ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend

digest-status LISTNAME ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly

Ok, I've tried a number of things here and I know I'm missing something but at this point my head is spinning (i.e. lack of sleep, too much coffee, etc...) My environment is PG 7.4.3 on Linux with 512Mb of ram and swap. This was just upgraded from 7.4 (just to make sure I'm current). Some of my settings in postgresql are giving fatal...

Hi all, I´m using postgreSQL in WinME and i had a very strange problem. When i start the postgres the process postmaster starts, but it stops soon after. So i can´t use the bd. Does someone know the problem? Tks

Hi there, I am using Postgresql 7.3 and I want to grant select rights to a user on all tables in a schema, including those that may be created in the future but whose names are not yet known. I want to do something like: GRANT SELECT ON <schema>.* TO <user>; but select isn't a valid privilege on a schema and I don't see how wildcards are...

Hi all, I want to know about open source GUI clients available for windows machines. The server is running on a Linux machine. rgds Antony Paul ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster

Hi: I'm getting this error when accessing a table with certain WHERE condition: "server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. The connection to the server was lost. Attempting reset: Failed." I've read through the posts but found no answer to the...

Hi all, I had installed postgresql in WinME. When i start postmaster the process starts and soon after stops ( alone ). So i can´t use the postgresql. Does someone know this error? Tks, ______________________

I can't seem to get right the regular expression for parsing data like these four sample rows (names and addresses changed to ficticious values) from a text-type column: Yolanda Harris, 38, of 40 South Main St., Newtown City, was charged Sunday with breach of peace and interfering with a police officer. Allen K. George, 30, of 88 Beverly...

Hi, i am using PostgreSQL 7.3.2 there's a bug for the date '2005-03-27' !!!!!!!!!!!!!!!!!!!!!!!!!!! SELECT to_char('2005-03-27'::date,'DD/MM/YYYY'); to_char ------------ 26/03/2005 (1 row)

I am getting ready to try to add image viewing into my postgresql browser... I am probably going to start with storing a thumbnail and a URL for the actual image in the table. Is there any demo code for loading binary (actually images...) data into a bytea field. The data is going to come from a file....

Hi, I'm trying to write an application to allow a user to edit an arbitrary table. How can I determine the type of a particular field and figure out whether or not I should be quoting the value? I found PQftype() and have reviewed pg_type and pg_attribute, but don't see

Would it be possible to determine the last time data in a database was added/updated/deleted? Whether via checking the system catalogs, creating a trigger, or something else? CSN __________________________________

If I bought one of these boxes/OS combos as a postgresql database server, would postgresql be able to make the best use of it with a huge (e.g. 40GB) database? Box: HP ProLiant DL585, with 4 AMD64 CPUs and 64GB of RAM. (other vendor options also exist) OS: SUSE enterprise 8 linux for AMD (links to product info at bottom)

I'm sure this has been discussed many times. I can find references to the problem in the archives, but decided to query the list here instead of sifting through archives all day. Is there a way to automate backup (perhaps using cron)? Of course, I am having problems when requiring passwords. I do not want to provide passwordless access via...

Hi, Looks like alter table does not tells about the indexes it dropped PG version: 7.4.3 Regds mallah.

My boss was asking about incremental backups. I was scratching my head, thinking that the transaction log and a backup policy (script) for each record set (sorry about the archaic terminology) was the usual solution. But there is a some resistance against writing more code, so I'm wondering what the current state of affairs with postgresql...

Hi all, I'm restoring a database from 7.3.4 FC1 to 7.4.2 FC2: $ pg_restore -d KakaoStats KakaoStats.dump pg_restore: could not execute query: ERROR: could not access file "$libdir/plpython": No such file or directory The dump was generated with the command:

Hi all, I am trying to mimic a table's behaviour on a view thru rules. More precisely, I have a table (say, my_table(field1,field2)) and a view (my_view as select my_field from my_table). For allowing inserts into the view, I have create a rule on "insert into my_view" doing instead insert into my_table(field1,field2) values...

Hi! I am trying to build PostgreSQL 7.4.3 with Java enabled; I've got Apache Ant version 1.5 and j2sdk1.4.1_05 installed: Verifiying ant: # which javac /usr/java/j2sdk1.4.1_05/bin/javac # ant -version Apache Ant version 1.5 compiled on October 15 2002

Hi i have an ordered table of dates let's say: 1/1/2004 8/1/2004 15/1/2004 29/1/2004 5/2/2004 12/2/2004

Just a quick question. Am I mistaken, or was multi-language support for upper(), lower() and friends recently added to 7.5? I could have sworn I saw mention of this on hackers, but, the TODO is not marked as done. Thanks, Ara Anjargolian