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

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
[mailtogadmin-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!


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

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
[mailtogadmin-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

If you can query the database with telnet, than the postmaster has to be
running.

The next step is to check pg_hba.conf on that server and insure that
your computers ip addess
is listed as a trusted connection.
eg:
a line similar to
host all all 765.432.111.0 255.255.255.0
trust
^--------------------
replace with your ip address

If nothing else works, I would delete that server connectrion it
pgadmin and just re-add it again.

________________________________

From: pgadmin-support-owner@postgresql.org
[mailtogadmin-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
[mailtogadmin-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