Thread: Newbie question
Hello everyone, I am quite new to Postgresql and JDBC and started to make my first application to use postgresql. And here comes my doubt/question: is it normal that it takes about 1 - 2 minutes to connect to the database? In my case it actually does take that long, but I thought maybe I made something wrong and you guys could give me a hint... Thanks Chris
Chris, No, it isn't normal, but with the information you have provided it will be difficult to analyze the problem. Can you send us the operating systems involved, firewalls, etc. Dave On Sat, 2003-12-20 at 14:06, Christian Rengstl wrote: > Hello everyone, > > I am quite new to Postgresql and JDBC and started to make my first > application to use postgresql. And here comes my doubt/question: is it > normal that it takes about 1 - 2 minutes to connect to the database? In > my case it actually does take that long, but I thought maybe I made > something wrong and you guys could give me a hint... > > Thanks > > Chris > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html > >
Hi, my operating system is SuSE Linux 9.0 with Java 1.4.2, postgresql 7.3.4 and the jdbc driver is pg73jdbc3.jar. I don't have a firewall set up, so there shouldn't be any problem with that. I have the driver in the lib/ext directory of my Java VM. Chris >Chris, > >No, it isn't normal, but with the information you have provided it will >be difficult to analyze the problem. > >Can you send us the operating systems involved, firewalls, etc. > >Dave >On Sat, 2003-12-20 at 14:06, Christian Rengstl wrote: > > >>Hello everyone, >> >>I am quite new to Postgresql and JDBC and started to make my first >>application to use postgresql. And here comes my doubt/question: is it >>normal that it takes about 1 - 2 minutes to connect to the database? In >>my case it actually does take that long, but I thought maybe I made >>something wrong and you guys could give me a hint... >> >>Thanks >> >>Chris >> >> >>---------------------------(end of broadcast)--------------------------- >>TIP 5: Have you checked our extensive FAQ? >> >> http://www.postgresql.org/docs/faqs/FAQ.html >> >> >> >> > > > >
Ok, the only thing I can think of is you are doing a name lookup that is returning, if you specify the ip address in the url does that speed it up? Dave On Mon, 2003-12-22 at 15:19, Christian Rengstl wrote: > Hi, > > my operating system is SuSE Linux 9.0 with Java 1.4.2, postgresql 7.3.4 > and the jdbc driver is pg73jdbc3.jar. I don't have a firewall set up, so > there shouldn't be any problem with that. I have the driver in the > lib/ext directory of my Java VM. > > Chris > > >Chris, > > > >No, it isn't normal, but with the information you have provided it will > >be difficult to analyze the problem. > > > >Can you send us the operating systems involved, firewalls, etc. > > > >Dave > >On Sat, 2003-12-20 at 14:06, Christian Rengstl wrote: > > > > > >>Hello everyone, > >> > >>I am quite new to Postgresql and JDBC and started to make my first > >>application to use postgresql. And here comes my doubt/question: is it > >>normal that it takes about 1 - 2 minutes to connect to the database? In > >>my case it actually does take that long, but I thought maybe I made > >>something wrong and you guys could give me a hint... > >> > >>Thanks > >> > >>Chris > >> > >> > >>---------------------------(end of broadcast)--------------------------- > >>TIP 5: Have you checked our extensive FAQ? > >> > >> http://www.postgresql.org/docs/faqs/FAQ.html > >> > >> > >> > >> > > > > > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend > >