[HACKERS] postmaster.pid not visible
Hi All, I installed PostgreSQL-8.3.1 on my Suse Linux machine, it went on fine without any problems and I was able to create and access the database, even I was able to start, restart and check the status of the service. Since it is my local machine and people are remotly connecting to the database on my local machine, I used to keep the machine up and running. Today I came and checked and It was telling me that the service of postgres is not running, so I went and checked the postmaster.pid file it was not in the data folder, but I was able to get to the psql prompt and execute standard sql statements, even people were able to connect remotly and access the databse on my machine. The only difficult that I was facing was that I was unable to restart or stop the service. So with the help of the ps -ef | grep postgres command I was able to trace out the pid and then manually kill the pid with the kill -9 command, after this I was able to restart, stop or check the status of the service. Can anyone throw light on why the postmaster.pid was not visible, the other intresting factor that I observed was that the postgres service was running on the 5432 port this was visible from the /tmp location. Also I would like to know if theer is any other alternative with which i can restart the service and retain the postmaster.pid file. Thanks in advance Regards Cinu Explore your hobbies and interests. Go to http://in.promos.yahoo.com/groups/
[HACKERS] Switching between terminals
Hi All, I am having an issue with a deadlock scenario in PostgreSQL 8.3.1I have the following database postgres, what I do is create two tables t1 and t2 in this database and I have the following fileds t1(a_id smallint, fn character(20), ln character(20), rt smallint)t2( c_id smallint, c_name character(20));The connection to the "postgres" database is established through two terminals;From the 1st terminal I give the following command1) begin transaction; update t2 set c_name = 'lock' where c_id = 1;From the 2nd terminal I give the following command2) begin transaction; update t1 set ln = 'lock' where a_id = 1;Then I come back to the 1st terminal and execute the following3) update t1 set ln = 'lock' where a_id = 1;Then I come to 2nd Terminal and execute the following 4) update t2 set c_name = 'lock' where c_id = 1;When I come out I get the following error message ERROR: deadlock detected DETAIL: Process 15171 waits for ShareLock on transaction 12738; blocked by process 15183. Process 15183 waits for ShareLock on transaction 12739; blocked by process 15171.This is perfectly fine, but what i am trying to acheive is that I am putting the above four queries in 4 different .sql files and executing it in the same way as displayed above by using two different terminals, please refer below the sequence which I am using.From the 1st terminal I give the following command1) psql -f dl11.sql -U postgres -d postgresFrom the 2nd terminal I give the following command2) psql -f dl21.sql -U postgres -d postgresThen I come back to the 1st terminal and execute the following3) psql -f dl12.sql -U postgres -d postgresThen I come to 2nd Terminal and execute the following4) psql -f dl22.sql -U postgres -d postgresI should be getting the same message about deadlock detection, but I am unable to get that.Could anyone please tell me where I am going wrong and if there is a way I can get the same behaviour that I am getting while I am executing the through psql prompt.Thanks in advanceWaiting for replyRegardsCinu Explore your hobbies and interests. Go to http://in.promos.yahoo.com/groups/
Re: [HACKERS] Installation of Postgres 32Bit on 64 bit machine
Hi, Thanks for the reply...When you are saying that I need to install 32 bit version of Libraries, are you referring to the libraries that are specified in the error message, I infact searched for the libraries and got it installed but some of the libraries are not available for SUSE Linux, if you install any other libraries it does not resolve the error.Please let me know what has to be done to resolve this issue.Thanks in advanceRegardsCinu--- On Tue, 20/5/08, Douglas McNaught <[EMAIL PROTECTED]> wrote:From: Douglas McNaught <[EMAIL PROTECTED]>Subject: Re: [HACKERS] Installation of Postgres 32Bit on 64 bit machineTo: "cinu" <[EMAIL PROTECTED]>Cc: pgsql-hackers@postgresql.orgDate: Tuesday, 20 May, 2008, 3:27 AMOn Mon, May 19, 2008 at 1:40 PM, cinu <[EMAIL PROTECTED]> wrote: > Hi All, > > > > I am trying to install PostgreSQL(postgresql-8.2.4-1PGDG.i686.rpm) on a 64 > bit machine, when I try to install I get the following error message: > > > > :/home/dump/postgres32bit # rpm -ivh postgresql-server-8.2.4-1PGDG.i686.rpm > postgresql-8.2.4-1PGDG.i686.rpm postgresql-libs-8.2.4-1PGDG.i686.rpm > warning: postgresql-server-8.2.4-1PGDG.i686.rpm: Header V3 DSA signature: > NOKEY, key ID 20579f11 > error: Failed dependencies: > libcrypto.so.4 is needed by postgresql-server-8.2.4-1PGDG.i686 > libreadline.so.4 is needed by postgresql-server-8.2.4-1PGDG.i686 > libssl.so.4 is needed by postgresql-server-8.2.4-1PGDG.i686 > initscripts is needed by postgresql-8.2.4-1PGDG.i686 > libcrypto.so.4 is needed by postgresql-8.2.4-1PGDG.i686 > libreadline.so.4 is needed by postgresql-8.2.4-1PGDG.i686 > libssl.so.4 is needed by postgresql-8.2.4-1PGDG.i686 > libcrypto.so.4 is needed by postgresql-libs-8.2.4-1PGDG.i686 > > libssl.so.4 is needed by postgresql-libs-8.2.4-1PGDG.i686 > > > > This installation is being done on SUSE linux 10, please let me know if > there is any alternative with which I can bypass these errors and make the > installation successful. You need to install 32-bit versions of the libraries PG depends on. They can coexist alongside the 64-bit versions. -Doug From Chandigarh to Chennai - find friends all over India. Click here.
[HACKERS] Installation of Postgres 32Bit on 64 bit machine
Hi All, I am trying to install PostgreSQL(postgresql-8.2.4-1PGDG.i686.rpm) on a 64 bit machine, when I try to install I get the following error message: :/home/dump/postgres32bit # rpm -ivh postgresql-server-8.2.4-1PGDG.i686.rpm postgresql-8.2.4-1PGDG.i686.rpm postgresql-libs-8.2.4-1PGDG.i686.rpmwarning: postgresql-server-8.2.4-1PGDG.i686.rpm: Header V3 DSA signature: NOKEY, key ID 20579f11error: Failed dependencies: libcrypto.so.4 is needed by postgresql-server-8.2.4-1PGDG.i686 libreadline.so.4 is needed by postgresql-server-8.2.4-1PGDG.i686 libssl.so.4 is needed by postgresql-server-8.2.4-1PGDG.i686 initscripts is needed by postgresql-8.2.4-1PGDG.i686 libcrypto.so.4 is needed by postgresql-8.2.4-1PGDG.i686 libreadline.so.4 is needed by postgresql-8.2.4-1PGDG.i686 libssl.so.4 is needed by postgresql-8.2.4-1PGDG.i686 libcrypto.so.4 is needed by postgresql-libs-8.2.4-1PGDG.i686 libssl.so.4 is needed by postgresql-libs-8.2.4-1PGDG.i686 This installation is being done on SUSE linux 10, please let me know if there is any alternative with which I can bypass these errors and make the installation successful. Thanks in advance Regards Cinu Planet Earth is in the hot seat. Know more.
[HACKERS] Errors with run_build.pl - 8.3RC2
Hi All, I was running the run_Build.pl script that is specific to Buildfarm and encountered errors. I am listing out the names of the logfiles and the errors that I have seen. Can anyone give me some clarity on these errors? Even though these errors are existing, at the end the latest version is getting downloaded and when I do a regression testing it goes through. Can anyone give me clarity on why these errors are occuring? The logfiles with the errors are listed below, these errors are for the version 8.3RC2: check.log == pgsql.3235/src/test/regress/log/postmaster.log === LOG: database system was shut down at 2008-01-19 17:13:48 EST LOG: database system is ready to accept connections LOG: autovacuum launcher started ERROR: value too long for type character varying(1) STATEMENT: INSERT INTO VARCHAR_TBL (f1) VALUES ('cd'); ERROR: value too long for type character(1) STATEMENT: INSERT INTO CHAR_TBL (f1) VALUES ('cd'); ERROR: invalid input syntax for type boolean: " tru e " STATEMENT: SELECT ' tru e '::text::boolean AS invalid; ERROR: invalid input syntax for type boolean: "" config.log conftest.c: In function `main': conftest.c:62: error: `not' undeclared (first use in this function) conftest.c:62: error: (Each undeclared identifier is reported only once conftest.c:62: error: for each function it appears in.) conftest.c:62: error: parse error before "big" contrib-install-check.log = /home/CINU/new_build/HEAD/inst/logfile === LOG: database system was shut down at 2008-01-19 17:16:39 EST LOG: database system is ready to accept connections LOG: autovacuum launcher started NOTICE: database "contrib_regression" does not exist, skipping NOTICE: type "gbtreekey4" is not yet defined DETAIL: Creating a shell type definition. NOTICE: argument type gbtreekey4 is only a shell NOTICE: type "gbtreekey8" is not yet defined DETAIL: Creating a shell type definition. NOTICE: argument type gbtreekey8 is only a shell NOTICE: type "gbtreekey16" is not yet defined DETAIL: Creating a shell type definition. NOTICE: argument type gbtreekey16 is only a shell NOTICE: type "gbtreekey32" is not yet defined DETAIL: Creating a shell type definition. NOTICE: argument type gbtreekey32 is only a shell NOTICE: type "gbtreekey_var" is not yet defined DETAIL: Creating a shell type definition. NOTICE: argument type gbtreekey_var is only a shell NOTICE: type "cube" is not yet defined DETAIL: Creating a shell type definition. NOTICE: return type cube is only a shell NOTICE: return type cube is only a shell NOTICE: argument type cube is only a shell ERROR: bad cube representation DETAIL: syntax error at end of input STATEMENT: SELECT ''::cube AS cube; ERROR: bad cube representation DETAIL: syntax error at or near "A" ecpg-check.log == pgsql.3235/src/interfaces/ecpg/test/log/postmaster.log === LOG: database system was shut down at 2008-01-19 17:18:15 EST LOG: database system is ready to accept connections LOG: autovacuum launcher started NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "test_pkey" for table "test" ERROR: duplicate key value violates unique constraint "test_pkey" STATEMENT: insert into test ( i , j ) values ( 7 , 12 ) ERROR: more than one row returned by a subquery used as an expression STATEMENT: select i from test where j = ( select j from test) LOG: unexpected EOF on client connection ERROR: relation "nonexistant" does not exist STATEMENT: select * from nonexistant initdb.log WARNING: enabling "trust" authentication for local connections You can change this by editing pg_hba.conf or using the -A option the next time you run initdb. install-check.log == /home/CINU/new_build/HEAD/inst/logfile == LOG: database system was shut down at 2008-01-19 17:15:24 EST LOG: database system is ready to accept connections LOG: autovacuum launcher started NOTICE: database "regression" does not exist, skipping ERROR: invalid input syntax for type boolean: " tru e " STATEMENT: SELECT ' tru e '::text::boolean AS invalid; ERROR: invalid input syntax for type boolean: "" STATEMENT: SELECT ''::text::boolean AS invalid; pl-install-check.log = /home/CINU/new_build/HEAD/inst/logfile === LOG: database system was shut down at 2008-01-19 17:16:27 EST LOG: database system is ready to accept connections LOG: autovacuum launcher started NOTICE: database "pl_regression" does not exist, skipping ERROR: set-valued function called in context that cannot accept a set STATEMENT: SELECT perl_set_int(5); ERROR: set-valu
[HACKERS] Regression testing
Hi All, I am trying to do a regression testing on the version installed. Now on the installed version of postgreSQL-8.2.4 with the service started, and at the regress filder, I run the command "gmake installcheck", when I run this command I get the following message: GNUmakefile:15: ../../../src/Makefile.global: No such file or directory GNUmakefile:78: /src/Makefile.shlib: No such file or directory gmake: *** No rule to make target `/src/Makefile.shlib'. Stop. Can anyone please tell me why am I getting this message and the solution for the same. Thanks in advance Regards Cinu Kuriakose Chat on a cool, new interface. No download required. Go to http://in.messenger.yahoo.com/webmessengerpromo.php ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[HACKERS] run_build.pl ~ By Andrew Dunstan
Hi All, I was exploring through the BuildFarm specific perl script run_build.pl. I executed the perl script and it went on file by downloading the latest PostgreSQL source code that is 8.3Beta2, after successful completion of the script it creates the required set of logfiles in the "lastrun-logs" folder. Now Inside this script there are certain places where the "rmtree"command is used for removing the installation, if I comment these places it should not remove the current installation, but infact it is doing so, it is installing the latest version of PostgreSQL in the location "/HEAD/inst/bin" and after the execution of the script it is cleaning the folder "inst". Please tell me : 1) Is "rmtree" the command used for removing the installation or is there any other command for the same, please specify? 2) Is there any site or portal where I can get detailed description about the perl script run_build.pl? 3) If I rename the perl script "run_build.pl" to some other file like "test.pl" will it execute or will it give errors? For your information : I am running this script through the postgres user. Please let me know if there is any other details required. Thanks in advance Regards Cinu Kuriakose Chat on a cool, new interface. No download required. Go to http://in.messenger.yahoo.com/webmessengerpromo.php ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[HACKERS] grep command
Hi All, I am giving the command cat config.log|grep -w 'PG_VERSION' Which gives the following Output: | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" | #define PG_VERSION "8.3beta2" #define PG_VERSION "8.3beta2" But the output that I would require is PG_VERSION "8.3beta2" that should occur only once, can anyone please tell me the command to get this output. Thanks in advance Regards Cinu Kuriakose ---(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] CVS Commands
Hi All, The ls and rls commands are used to list files and directories in the repository, but we should be logged in to the repository for getting the listing of the same. I use the command "cvs login" to connect to the repository but instead of connecting to the local repository it is connecting to the postgreSQL repository, but when I specify the command -> cvs -d :pserver:[EMAIL PROTECTED]:/u01/Installs/cvsrepository/cvsroot login where /u01/Installs/cvsrepository/cvsroot is the repository path, root is the username and inblr-kuriakcc.eu.uis.unisys.com is the hostname it is asking for the password, now I am not sure what is the password, can anyone please tell me the method to change the CVS password, so that I can change the password and get connected to the local repository. Thanks in Advance Cinu ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[HACKERS] CVS and Eclipse
Hi All, I am trying to configure CVS through Eclipse, infact i was able to do that but when I map the postgreSQL code into CVS through Eclipse, it is displaying the folders but the files in those folders are not getting displayed. Can anyone help me over this.. Thanks in advance Cinu Kuriakose ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[HACKERS] Regression test message
Hi All, I am trying to run Regression test on postgreSQL-7.2.8, it got installed successfully, but the regression test is not going through, it is giving the following errors... == 78 of 79 tests passed, 1 failed test(s) ignored. == The differences that caused some tests to fail can be viewed in the file `./regression.diffs'. A copy of the test summary that you see above is saved in the file `./regression.out'. I am also pasting whatever is listed in the regression.diffs file, it is as follows *** ./expected/geometry.out Fri Nov 30 00:27:31 2001 --- ./results/geometry.out Wed Sep 26 16:13:00 2007 *** *** 150,160 six |box -+ | (2.12132034355964,2.12132034355964),(-2.12132034355964,-2.12132034355964) ! | (71.7106781186548,72.7106781186548),(-69.7106781186548,-68.7106781186548) ! | (4.53553390593274,6.53553390593274),(-2.53553390593274,-0.535533905932738) ! | (3.12132034355964,4.12132034355964),(-1.12132034355964,-0.121320343559643) | (107.071067811865,207.071067811865),(92.9289321881345,192.928932188135) ! | (170.710678118655,70.7106781186548),(29.2893218813452,-70.7106781186548) (6 rows) -- translation --- 150,160 six |box -+ | (2.12132034355964,2.12132034355964),(-2.12132034355964,-2.12132034355964) ! | (71.7106781186547,72.7106781186547),(-69.7106781186547,-68.7106781186547) ! | (4.53553390593274,6.53553390593274),(-2.53553390593274,-0.535533905932737) ! | (3.12132034355964,4.12132034355964),(-1.12132034355964,-0.121320343559642) | (107.071067811865,207.071067811865),(92.9289321881345,192.928932188135) ! | (170.710678118655,70.7106781186547),(29.2893218813453,-70.7106781186547) (6 rows) -- translation == Please tell me what shall I do to resolve this issue. Thanks and Regards Cinu Kuriakose ---(end of broadcast)--- TIP 6: explain analyze is your friend