Thread: Cannot connect to one specific postgres database on a server
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">Hello, </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">I am having trouble connecting to one specific database on my server. I can connect to the server via<span class="SpellE">pgadmin</span> and have <span class="SpellE">pgadmin</span> display 7 or 8 databases I have runningon the server. I can successfully connect to all of the databases except one. This particular database I am tryingto connect to will just cause <span class="SpellE">pgadmin</span> to hang/crash </span></font><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">I have been using <span class="SpellE">pgadmin</span> for over 2 years to connect to this particular databasethat <span class="GramE">wont</span> connect now. This just started happening a week ago and is frustrating me sobad! I have installed/reinstalled/uninstalled about every version on <span class="SpellE">pgadmin</span> with no success.I restarted <span class="SpellE">postgres</span> on the server with no success… </span></font><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">My server is running <span class="SpellE">linux</span>, and I am using windows version of <span class="SpellE">pgadmin</span>…</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">I WOULD REALLY APPRECIATE ANY HELP!!! THANKS SO MUCH!!!</span></font><p class="MsoNormal"><font face="Arial"size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">Matt Busby</span></font></div>
From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Matt Busby
Sent: Monday, January 22, 2007 9:37 AM
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Cannot connect to one specific postgres database on a server
Hello,
I am having trouble connecting to one specific database on my server. I can connect to the server via pgadmin and have pgadmin display 7 or 8 databases I have running on the server. I can successfully connect to all of the databases except one. This particular database I am trying to connect to will just cause pgadmin to hang/crash
I have been using pgadmin for over 2 years to connect to this particular database that wont connect now. This just started happening a week ago and is frustrating me so bad! I have installed/reinstalled/uninstalled about every version on pgadmin with no success. I restarted postgres on the server with no success…
My server is running linux, and I am using windows version of pgadmin…
I WOULD REALLY APPRECIATE ANY HELP!!! THANKS SO MUCH!!!
Matt Busby
Can you connect to it OK using psql on the server's console? If you can, try dumping the database using pg_dump, then restore it as a different database and try connecting via PgAdmin to the new copy. Matt Busby wrote: > > Hello, > > I am having trouble connecting to one specific database on my server. > I can connect to the server via pgadmin and have pgadmin display 7 or > 8 databases I have running on the server. I can successfully connect > to all of the databases except one. This particular database I am > trying to connect to will just cause pgadmin to hang/crash > > I have been using pgadmin for over 2 years to connect to this > particular database that wont connect now. This just started happening > a week ago and is frustrating me so bad! I have > installed/reinstalled/uninstalled about every version on pgadmin with > no success. I restarted postgres on the server with no success… > > My server is running linux, and I am using windows version of pgadmin… > > I WOULD REALLY APPRECIATE ANY HELP!!! THANKS SO MUCH!!! > > Matt Busby > > !DSPAM:37,45b5078b118211361817358!
Hi. I am one idea. Please set up a log as the option of pgAdmin and acquire it. The information on it and the version to be used is required. we have to avoid hang/crash ......:-( Regards, Hiroshi Saito ----- Original Message ----- From: "Andy Shellam (Mailing Lists)" > Can you connect to it OK using psql on the server's console? > If you can, try dumping the database using pg_dump, then restore it as a > different database and try connecting via PgAdmin to the new copy. > > > Matt Busby wrote: >> >> Hello, >> >> I am having trouble connecting to one specific database on my server. >> I can connect to the server via pgadmin and have pgadmin display 7 or >> 8 databases I have running on the server. I can successfully connect >> to all of the databases except one. This particular database I am >> trying to connect to will just cause pgadmin to hang/crash >> >> I have been using pgadmin for over 2 years to connect to this >> particular database that wont connect now. This just started happening >> a week ago and is frustrating me so bad! I have >> installed/reinstalled/uninstalled about every version on pgadmin with >> no success. I restarted postgres on the server with no success. >> >> My server is running linux, and I am using windows version of pgadmin. >> >> I WOULD REALLY APPRECIATE ANY HELP!!! THANKS SO MUCH!!! >> >> Matt Busby >> >> !DSPAM:37,45b5078b118211361817358! > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings
Sent: Monday, January 22, 2007 12:10 PM
To: Melvin Davidson
Cc: pgadmin-support@postgresql.org
Subject: RE: [pgadmin-support] Cannot connect to one specific postgres database on a server
I can telnet to the database and query the database…. The site that is using the database is also running fine
Not sure what postmaster is…. How can I check if its running? I did a google search for it, but not sure how to check it on my postgres db server
I don’t get any errors using telnet … I can access the db every other way it seems, just using postgres
If I restore/rebuild the db, will that cause the database to go down at all? I will try anything to get pgadmin working with the db… it makes my life SOOO much easier!
Thanks very much for taking the time to help me with this issue! Much appreciated!
Matt
-----Original Message-----
From: Melvin Davidson [mailto:mdavidson@cctus.com]
Sent: Monday, January 22, 2007 2:01 PM
To: Matt Busby
Cc: pgadmin-support@postgresql.org
Subject: RE: [pgadmin-support] Cannot connect to one specific postgres database on a server
I cannot tell you what is specificially wrong, but try the following:
Can you telnet to that database and query?
Is the postmaster running for that database?
Do you get any errors returned when you try to connect via telnet? What are they?
Is it possible your database is corrupted and you need to restore/rebuild?
From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Matt Busby
Sent: Monday, January 22, 2007 9:37 AM
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Cannot connect to one specific postgres database on a server
Hello,
I am having trouble connecting to one specific database on my server. I can connect to the server via pgadmin and have pgadmin display 7 or 8 databases I have running on the server. I can successfully connect to all of the databases except one. This particular database I am trying to connect to will just cause pgadmin to hang/crash
I have been using pgadmin for over 2 years to connect to this particular database that wont connect now. This just started happening a week ago and is frustrating me so bad! I have installed/reinstalled/uninstalled about every version on pgadmin with no success. I restarted postgres on the server with no success…
My server is running linux, and I am using windows version of pgadmin…
I WOULD REALLY APPRECIATE ANY HELP!!! THANKS SO MUCH!!!
Matt Busby
Melvin, Your understanding of how to set up a PostgreSQL server is wrong. One server process (it was called the postmaster up to 8.1, since 8.2 it's now called the Server process) can run any number of databases, you don't need multiple postmasters for multiple databases or your server is going to die quickly when you start adding more and more databases, not to mention the admin overhead of managing all the ports, and handling backups. Using PgAdmin you connect to a particular server, connecting to the "postgres" database by default, then once you're connected to a PostgreSQL server, you choose which database/s to connect to. Melvin Davidson wrote: > When you say "The site that is using the database is also running > fine", Do you mean users are accessing > that database? If so, that check the port # you are using to connect. This should be 5432 unless specifically changed during the build. > You might also try adding a new server connection to that database in > pgadmin. If the OP can connect to one database, he should be able to connect to another on the same server. > postmaster is the postgresql process that is needed to access the > database. > Telnet to the server and do > ps -ef | grep postmaster > You should see something like > admin 2986 1 0 Jan12 ? 00:00:00 > /home/pgsql/postgresql-8.0.6/bin/postmaster There are various processes for PostgreSQL, such as the auto-vacuum, stats-gatherer and background writer processes. > You will have a process for each database on a separate port. No - if yours is set up this way, your server is going to be unnecessarily overloaded. One PostgreSQL postmaster/server process can run any number of databases on one port. It's only advisable to run more than one PostgreSQL server process on different ports if you want to run two different versions of PostgreSQL, or want to dump one set of databases to a different server (popular during a major version upgrade.) > If all postmaster(s) are running, then perhaps someone or > something(gremlins) :) has modified the > pg_hba.conf file in the $PGDATA directory? If the OP can connect to one database on the same server, there's no reason (aside from data corruption) why he shouldn't be able to connect to the required one, especially if nothing has changed - he'd get an "no pg_hba.conf entry for <such and such> if the pg_hba.conf file was mis-configured. I'd advise the OP to either turn on debug logging in PgAdmin and re-create the crash, or dump the database from the server, restore as a different database on the same machine and try to connect to it again. Matt, if you follow this method, it won't take the database down as long as you restore the dump to a different database name. If it works, I'd then advise to dump the original database again, drop it and re-create it. That will take it down for as long as the dump takes place. Hope this helps! Andy. > ------------------------------------------------------------------------ > *From:* Matt Busby [mailto:busby@condodomain.com] > *Sent:* Monday, January 22, 2007 12:10 PM > *To:* Melvin Davidson > *Cc:* pgadmin-support@postgresql.org > *Subject:* RE: [pgadmin-support] Cannot connect to one specific > postgres database on a server > > I can telnet to the database and query the database…. The site that is > using the database is also running fine > > Not sure what postmaster is…. How can I check if its running? I did a > google search for it, but not sure how to check it on my postgres db > server > > I don’t get any errors using telnet … I can access the db every other > way it seems, just using postgres > > If I restore/rebuild the db, will that cause the database to go down > at all? I will try anything to get pgadmin working with the db… it > makes my life SOOO much easier! > > Thanks very much for taking the time to help me with this issue! Much > appreciated! > > Matt >
Yes, you are correct, but you can have multiple _clusters_ with different ports, so there would a separate postmaster for each cluster on a server/machine with a different port. Keep in mind the port for the database was not specified in the original description so it s entirely possible the unaccessible database was due to the postmaster for that port being down. BTW, we do have several servers/systems/machines running multiple postmasters on multiple ports so even of my "understanding" of postgresql is different than yours, I must be doing something right. :) -----Original Message----- From: Andy Shellam (Mailing Lists) [mailto:andy.shellam-lists@mailnetwork.co.uk] Sent: Monday, January 22, 2007 2:35 PM To: Melvin Davidson Cc: Matt Busby; pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] Cannot connect to one specific postgres database on a server Melvin, Your understanding of how to set up a PostgreSQL server is wrong. One server process (it was called the postmaster up to 8.1, since 8.2 it's now called the Server process) can run any number of databases, you don't need multiple postmasters for multiple databases or your server is going to die quickly when you start adding more and more databases, not to mention the admin overhead of managing all the ports, and handling backups. Using PgAdmin you connect to a particular server, connecting to the "postgres" database by default, then once you're connected to a PostgreSQL server, you choose which database/s to connect to. Melvin Davidson wrote: > When you say "The site that is using the database is also running > fine", Do you mean users are accessing that database? If so, that > check the port # you are using to connect. This should be 5432 unless specifically changed during the build. > You might also try adding a new server connection to that database in > pgadmin. If the OP can connect to one database, he should be able to connect to another on the same server. > postmaster is the postgresql process that is needed to access the > database. > Telnet to the server and do > ps -ef | grep postmaster > You should see something like > admin 2986 1 0 Jan12 ? 00:00:00 > /home/pgsql/postgresql-8.0.6/bin/postmaster There are various processes for PostgreSQL, such as the auto-vacuum, stats-gatherer and background writer processes. > You will have a process for each database on a separate port. No - if yours is set up this way, your server is going to be unnecessarily overloaded. One PostgreSQL postmaster/server process can run any number of databases on one port. It's only advisable to run more than one PostgreSQL server process on different ports if you want to run two different versions of PostgreSQL, or want to dump one set of databases to a different server (popular during a major version upgrade.) > If all postmaster(s) are running, then perhaps someone or > something(gremlins) :) has modified the pg_hba.conf file in the > $PGDATA directory? If the OP can connect to one database on the same server, there's no reason (aside from data corruption) why he shouldn't be able to connect to the required one, especially if nothing has changed - he'd get an "no pg_hba.conf entry for <such and such> if the pg_hba.conf file was mis-configured. I'd advise the OP to either turn on debug logging in PgAdmin and re-create the crash, or dump the database from the server, restore as a different database on the same machine and try to connect to it again. Matt, if you follow this method, it won't take the database down as long as you restore the dump to a different database name. If it works, I'd then advise to dump the original database again, drop it and re-create it. That will take it down for as long as the dump takes place. Hope this helps! Andy. > ---------------------------------------------------------------------- > -- > *From:* Matt Busby [mailto:busby@condodomain.com] > *Sent:* Monday, January 22, 2007 12:10 PM > *To:* Melvin Davidson > *Cc:* pgadmin-support@postgresql.org > *Subject:* RE: [pgadmin-support] Cannot connect to one specific > postgres database on a server > > I can telnet to the database and query the database.... The site that is > using the database is also running fine > > Not sure what postmaster is.... How can I check if its running? I did a > google search for it, but not sure how to check it on my postgres db > server > > I don't get any errors using telnet ... I can access the db every other > way it seems, just using postgres > > If I restore/rebuild the db, will that cause the database to go down > at all? I will try anything to get pgadmin working with the db... it > makes my life SOOO much easier! > > Thanks very much for taking the time to help me with this issue! Much > appreciated! > > Matt >
Melvin Davidson wrote: > Yes, you are correct, but you can have multiple _clusters_ with > different ports, > so there would a separate postmaster for each cluster on a > server/machine with > a different port. > Yes, you can, but the way you've worded your response was that you have one postmaster process per _database_, which isn't correct. A cluster is a group of databases, not one, therefore your response to the OP was misleading. > Keep in mind the port for the database was not specified in the original > description > so it s entirely possible the unaccessible database was due to the > postmaster for that > port being down. > The OP said they can access other databases on the same server OK, plus PgAdmin wouldn't crash - they'd get a "the server is not listening..." message. > BTW, we do have several servers/systems/machines running multiple > postmasters on multiple ports > so even of my "understanding" of postgresql is different than yours, > I must be doing something right. :) > If you have legitimate reasons for doing so, fine, but I was responding to the way you worded your question, which was you were saying you have one process per port per database, which is by no means ideal. Regards Andy. > -----Original Message----- > From: Andy Shellam (Mailing Lists) > [mailto:andy.shellam-lists@mailnetwork.co.uk] > Sent: Monday, January 22, 2007 2:35 PM > To: Melvin Davidson > Cc: Matt Busby; pgadmin-support@postgresql.org > Subject: Re: [pgadmin-support] Cannot connect to one specific postgres > database on a server > > Melvin, > > Your understanding of how to set up a PostgreSQL server is wrong. > One server process (it was called the postmaster up to 8.1, since 8.2 > it's now called the Server process) can run any number of databases, you > don't need multiple postmasters for multiple databases or your server is > going to die quickly when you start adding more and more databases, not > to mention the admin overhead of managing all the ports, and handling > backups. > > Using PgAdmin you connect to a particular server, connecting to the > "postgres" database by default, then once you're connected to a > PostgreSQL server, you choose which database/s to connect to. > > Melvin Davidson wrote: > >> When you say "The site that is using the database is also running >> fine", Do you mean users are accessing that database? If so, that >> check the port # you are using to connect. >> > This should be 5432 unless specifically changed during the build. > >> You might also try adding a new server connection to that database in >> pgadmin. >> > If the OP can connect to one database, he should be able to connect to > another on the same server. > >> postmaster is the postgresql process that is needed to access the >> database. >> Telnet to the server and do >> ps -ef | grep postmaster >> You should see something like >> admin 2986 1 0 Jan12 ? 00:00:00 >> /home/pgsql/postgresql-8.0.6/bin/postmaster >> > There are various processes for PostgreSQL, such as the auto-vacuum, > stats-gatherer and background writer processes. > >> You will have a process for each database on a separate port. >> > No - if yours is set up this way, your server is going to be > unnecessarily overloaded. One PostgreSQL postmaster/server process can > run any number of databases on one port. It's only advisable to run more > than one PostgreSQL server process on different ports if you want to run > two different versions of PostgreSQL, or want to dump one set of > databases to a different server (popular during a major version > upgrade.) > >> If all postmaster(s) are running, then perhaps someone or >> something(gremlins) :) has modified the pg_hba.conf file in the >> $PGDATA directory? >> > If the OP can connect to one database on the same server, there's no > reason (aside from data corruption) why he shouldn't be able to connect > to the required one, especially if nothing has changed - he'd get an "no > pg_hba.conf entry for <such and such> if the pg_hba.conf file was > mis-configured. > > I'd advise the OP to either turn on debug logging in PgAdmin and > re-create the crash, or dump the database from the server, restore as a > different database on the same machine and try to connect to it again. > Matt, if you follow this method, it won't take the database down as long > as you restore the dump to a different database name. If it works, I'd > then advise to dump the original database again, drop it and re-create > it. That will take it down for as long as the dump takes place. > > Hope this helps! > > Andy. > >> ---------------------------------------------------------------------- >> -- >> *From:* Matt Busby [mailto:busby@condodomain.com] >> *Sent:* Monday, January 22, 2007 12:10 PM >> *To:* Melvin Davidson >> *Cc:* pgadmin-support@postgresql.org >> *Subject:* RE: [pgadmin-support] Cannot connect to one specific >> postgres database on a server >> >> I can telnet to the database and query the database.... The site that >> > is > >> using the database is also running fine >> >> Not sure what postmaster is.... How can I check if its running? I did >> > a > >> google search for it, but not sure how to check it on my postgres db >> server >> >> I don't get any errors using telnet ... I can access the db every >> > other > >> way it seems, just using postgres >> >> If I restore/rebuild the db, will that cause the database to go down >> at all? I will try anything to get pgadmin working with the db... it >> makes my life SOOO much easier! >> >> Thanks very much for taking the time to help me with this issue! Much >> appreciated! >> >> Matt >> >> > > !DSPAM:37,45b52fd0118219813838351! > > > -- Andy Shellam NetServe Support Team the Mail Network "an alternative in a standardised world" p: +44 (0) 121 288 0832/0839 m: +44 (0) 7818 000834
<div class="Section1"><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:navy">I can telnet to the database and query the database…. The site that is using the databaseis also running fine</span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:navy">Not sure what postmaster is…. How can I check if <span class="GramE">its</span> running?I did a <span class="SpellE">google</span> search for it, but not sure how to check it on my <span class="SpellE">postgres</span>db server</span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><spanstyle="font-size: 10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:navy">I don’t get any errors using telnet … I can access the db every other way it seems,just using <span class="SpellE">postgres</span></span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><spanstyle="font-size: 10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:navy">If I restore/rebuild the db, will that cause the database to go down at all? I willtry anything to get <span class="SpellE">pgadmin</span> working with the db… it makes my life SOOO much easier!</span></font><pclass="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:navy">Thanks very much for taking the time to help me with this issue! Much appreciated!</span></font><pclass="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:navy">Matt</span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><spanstyle="font-size: 10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal" style="margin-left:.5in"><font face="Tahoma" size="2"><spanstyle="font-size:10.0pt;font-family:Tahoma">-----Original Message-----<br /><b><span style="font-weight:bold">From:</span></b>Melvin Davidson [mailto:mdavidson@cctus.com] <br /><b><span style="font-weight:bold">Sent:</span></b></span></font><font face="Tahoma" size="2"><span style="font-size:10.0pt;font-family:Tahoma">Monday,January 22, 2007</span></font><font face="Tahoma" size="2"><span style="font-size:10.0pt;font-family:Tahoma"></span></font><font face="Tahoma" size="2"><span style="font-size:10.0pt;font-family:Tahoma">2:01PM</span></font><font face="Tahoma" size="2"><span style="font-size:10.0pt;font-family:Tahoma"><br/><b><span style="font-weight:bold">To:</span></b> Matt Busby<br /><b><spanstyle="font-weight:bold">Cc:</span></b> pgadmin-support@postgresql.org<br /><b><span style="font-weight:bold">Subject:</span></b>RE: [pgadmin-support] Cannot connect to one specific postgres database on a server</span></font><pclass="MsoNormal" style="margin-left:.5in"><font face="Times New Roman" size="3"><span style="font-size:12.0pt"> </span></font><pclass="MsoNormal" style="margin-left:.5in"><font color="blue" face="Arial" size="3"><spanstyle="font-size:12.0pt;font-family:Arial;color:blue">I cannot tell you what is specificially wrong, but trythe following:</span></font><p class="MsoNormal" style="margin-left:.5in"><font face="Times New Roman" size="3"><spanstyle="font-size:12.0pt"> </span></font><p class="MsoNormal" style="margin-left:.5in"><font color="blue" face="Arial"size="3"><span style="font-size:12.0pt;font-family:Arial;color:blue">Can you telnet to that database and query?</span></font><pclass="MsoNormal" style="margin-left:.5in"><font face="Times New Roman" size="3"><span style="font-size:12.0pt"> </span></font><pclass="MsoNormal" style="margin-left:.5in"><font color="blue" face="Arial" size="3"><spanstyle="font-size:12.0pt;font-family:Arial;color:blue">Is the postmaster running for that database?</span></font><pclass="MsoNormal" style="margin-left:.5in"><font face="Times New Roman" size="3"><span style="font-size:12.0pt"> </span></font><pclass="MsoNormal" style="margin-left:.5in"><font color="blue" face="Arial" size="3"><spanstyle="font-size:12.0pt;font-family:Arial;color:blue">Do you get any errors returned when you try to connectvia telnet? What are they?</span></font><p class="MsoNormal" style="margin-left:.5in"><font face="Times New Roman"size="3"><span style="font-size:12.0pt"> </span></font><p class="MsoNormal" style="margin-left:.5in"><font color="blue"face="Arial" size="3"><span style="font-size:12.0pt;font-family:Arial;color:blue">Is it possible your databaseis corrupted and you need to restore/rebuild?</span></font><p class="MsoNormal" style="margin-left:.5in"><font face="TimesNew Roman" size="3"><span style="font-size:12.0pt"> </span></font><div align="center" class="MsoNormal" style="margin-left:.5in;text-align:center"><fontface="Times New Roman" size="3"><span style="font-size:12.0pt"><hr align="center"size="2" width="100%" /></span></font></div><p class="MsoNormal" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom: 12.0pt;margin-left:.5in"><b><font face="Tahoma" size="2"><span style="font-size: 10.0pt;font-family:Tahoma;font-weight:bold">From:</span></font></b><font face="Tahoma" size="2"><span style="font-size:10.0pt;font-family:Tahoma">pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org]<b><span style="font-weight:bold">On Behalf Of </span></b>Matt Busby<br /><b><spanstyle="font-weight:bold">Sent:</span></b> </span></font><font face="Tahoma" size="2"><span style="font-size:10.0pt;font-family:Tahoma">Monday,January 22, 2007</span></font><font face="Tahoma" size="2"><span style="font-size:10.0pt;font-family:Tahoma"></span></font><font face="Tahoma" size="2"><span style="font-size:10.0pt;font-family:Tahoma">9:37AM</span></font><font face="Tahoma" size="2"><span style="font-size:10.0pt;font-family:Tahoma"><br/><b><span style="font-weight:bold">To:</span></b> pgadmin-support@postgresql.org<br/><b><span style="font-weight:bold">Subject:</span></b> [pgadmin-support] Cannot connectto one specific postgres database on a server</span></font><p class="MsoNormal" style="margin-left:.5in"><font face="Arial"size="2"><span style="font-size:10.0pt;font-family:Arial">Hello, </span></font><p class="MsoNormal" style="margin-left:.5in"><fontface="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial">I am having troubleconnecting to one specific database on my server. I can connect to the server via pgadmin and have pgadmin display7 or 8 databases I have running on the server. I can successfully connect to all of the databases except one. Thisparticular database I am trying to connect to will just cause pgadmin to hang/crash </span></font><p class="MsoNormal"style="margin-left:.5in"><font face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial"> </span></font><pclass="MsoNormal" style="margin-left:.5in"><font face="Arial"size="2"><span style="font-size:10.0pt;font-family:Arial">I have been using pgadmin for over 2 years to connectto this particular database that wont connect now. This just started happening a week ago and is frustrating me sobad! I have installed/reinstalled/uninstalled about every version on pgadmin with no success. I restarted postgres on theserver with no success… </span></font><p class="MsoNormal" style="margin-left:.5in"><font face="Arial" size="2"><spanstyle="font-size:10.0pt;font-family:Arial"> </span></font><p class="MsoNormal" style="margin-left:.5in"><fontface="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial">My server is runninglinux, and I am using windows version of pgadmin…</span></font><p class="MsoNormal" style="margin-left:.5in"><fontface="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"style="margin-left:.5in"><font face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial">IWOULD REALLY APPRECIATE ANY HELP!!! THANKS SO MUCH!!!</span></font><p class="MsoNormal"style="margin-left:.5in"><font face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial"> </span></font><pclass="MsoNormal" style="margin-left:.5in"><font face="Arial"size="2"><span style="font-size:10.0pt;font-family:Arial">Matt Busby</span></font></div>
From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Matt Busby
Sent: Monday, January 22, 2007 12:10 PM
To: Melvin Davidson
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Cannot connect to one specific postgres database on a server
I can telnet to the database and query the database…. The site that is using the database is also running fine
Not sure what postmaster is…. How can I check if its running? I did a google search for it, but not sure how to check it on my postgres db server
I don’t get any errors using telnet … I can access the db every other way it seems, just using postgres
If I restore/rebuild the db, will that cause the database to go down at all? I will try anything to get pgadmin working with the db… it makes my life SOOO much easier!
Thanks very much for taking the time to help me with this issue! Much appreciated!
Matt
-----Original Message-----
From: Melvin Davidson [mailto:mdavidson@cctus.com]
Sent: Monday, January 22, 2007 2:01 PM
To: Matt Busby
Cc: pgadmin-support@postgresql.org
Subject: RE: [pgadmin-support] Cannot connect to one specific postgres database on a server
I cannot tell you what is specificially wrong, but try the following:
Can you telnet to that database and query?
Is the postmaster running for that database?
Do you get any errors returned when you try to connect via telnet? What are they?
Is it possible your database is corrupted and you need to restore/rebuild?
From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Matt Busby
Sent: Monday, January 22, 2007 9:37 AM
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Cannot connect to one specific postgres database on a server
Hello,
I am having trouble connecting to one specific database on my server. I can connect to the server via pgadmin and have pgadmin display 7 or 8 databases I have running on the server. I can successfully connect to all of the databases except one. This particular database I am trying to connect to will just cause pgadmin to hang/crash
I have been using pgadmin for over 2 years to connect to this particular database that wont connect now. This just started happening a week ago and is frustrating me so bad! I have installed/reinstalled/uninstalled about every version on pgadmin with no success. I restarted postgres on the server with no success…
My server is running linux, and I am using windows version of pgadmin…
I WOULD REALLY APPRECIATE ANY HELP!!! THANKS SO MUCH!!!
Matt Busby