Re: [BUGS] error while starting database

2007-08-17 Thread Douglas Toltzman
If it is true that listing /tmp (ls -a /tmp) returns no such file or directory, then that may be the problem. You should have a world- writable /tmp folder, as Tom already pointed out. Also, an update to a more stable version of PostgreSQL is still highly recommended. On Aug 17, 2007, at 1

Re: [BUGS] BUG #3544: SQLException from JDBC driver

2007-08-17 Thread Kris Jurka
On Thu, 16 Aug 2007, Scott Harper wrote: The following bug has been logged online: Bug reference: 3544 PostgreSQL version: 8.1.9 Operating system: Debian Linux (2.6.18-4-486) Description:SQLException from JDBC driver Details: I have installed PostgreSQL 8.1 via the Debian pack

Re: [BUGS] BUG #3504: Some listening sessions never return from writing, problems ensue

2007-08-17 Thread Peter Koczan
> Hm. To me it looks like the first psql session isn't prepared to gather > async notifies (checking...) indeed, psql only checks for async notifies when > issuing commands (you don't have to issue a NOTIFY in "Connection 1" to > receive the pending notifies -- *any* request directed to the server

Re: [BUGS] BUG #3504: Some listening sessions never return from writing, problems ensue

2007-08-17 Thread Heikki Linnakangas
Peter Koczan wrote: >> Hm. To me it looks like the first psql session isn't prepared to gather >> async notifies (checking...) indeed, psql only checks for async notifies when >> issuing commands (you don't have to issue a NOTIFY in "Connection 1" to >> receive the pending notifies -- *any* request

Re: [BUGS] BUG #3548: When quickly switching between databases the server lags behind

2007-08-17 Thread Tom Lane
"Daniel Heyder" <[EMAIL PROTECTED]> writes: > when I do quick PQconnectdb give the connection something to do PQfinish the > connection and PQconnectdb to another database the database server does not > keep up, neither does PQconnectdb or PQfinish block until the work is > complete. This is annoyi

[BUGS] BUG #3548: When quickly switching between databases the server lags behind

2007-08-17 Thread Daniel Heyder
The following bug has been logged online: Bug reference: 3548 Logged by: Daniel Heyder Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Linux (Red Hat EL4 Update 4 + PostgreSQL 8.2.4 update + compat libraries) Description:When quickly switc

Re: [BUGS] error while starting database

2007-08-17 Thread Tom Lane
"Nitin Saxena" <[EMAIL PROTECTED]> writes: > I am using postgres 7.0 on linux platform. Egad. At first I thought that was a typo, but if psql really spelled its error message just like that, it must indeed be 7.0 or older :-(. Do yourself a favor and get onto a newer version, NOW. Not tomorrow.

Re: [BUGS] error while starting database

2007-08-17 Thread Douglas Toltzman
PostgreSQL version 7.0 is really, really out of date, but as far as I know, it should still work. I generally use "ps -ax | grep postges" to see if there is a postgres process running. Also, I use "netstat -a" to see open sockets and listening servers. Have you removed the socket file in

[BUGS] error while starting database

2007-08-17 Thread Nitin Saxena
I am using postgres 7.0 on linux platform. My java application was running fine ,but i got this message Connection refused. Check that the hostname and port is correct, and that the postmaster is r unning with the -i flag, which enables TCP/IP networking. at org.postgresql.Connection.openConnectio

[BUGS] BUG #3547: getting error during salient Installation

2007-08-17 Thread Abhay
The following bug has been logged online: Bug reference: 3547 Logged by: Abhay Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: XP , window 2000 Description:getting error during salient Installation Details: We need salient installation of

Re: [BUGS] BUG #3504: Some listening sessions never return from writing, problems ensue

2007-08-17 Thread tomas
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, Aug 16, 2007 at 05:41:32PM -0500, Peter Koczan wrote: > Hey, I found something that finally clears netstat's recv-q with async > notifies. I don't quite understand what's going on, so any > enlightenment would be greatly appreciated. As near as

Re: [BUGS] some information

2007-08-17 Thread Pavel Stehule
Hello it isn't bug! PostgreSQL's driver for perl http://search.cpan.org/~dbdpg/DBD-Pg-1.49/Pg.pm look to postgresql.conf (port) and pg_hba.conf (enable access) Regards Pavel Stehule 2007/8/17, rakesh kumar <[EMAIL PROTECTED]>: > > how to connect postgresql database with perl > > > Please if se

[BUGS] some information

2007-08-17 Thread rakesh kumar
how to connect postgresql database with perl Please if server ip:192.168.0.1 server name=abcd we using Slackware 10.2 & kernel 2.6.17 which suport postgresql version rakesh - Looking for a deal? Find great prices on flights and hotels with Yahoo! Fare

Re: [BUGS] BUG #3504: Some listening sessions never return from writing, problems ensue

2007-08-17 Thread Peter Koczan
Hey, I found something that finally clears netstat's recv-q with async notifies. I don't quite understand what's going on, so any enlightenment would be greatly appreciated. As near as I can figure, the client doesn't appear to read the notifies until it sends a notify of its own. Then it reads all