Postgres Pro
Downloads
Home   >   mailing lists

Thread: Too many postgresql process

Too many postgresql process

From
Chris Lee
Date:
Dear All,

When I connect to Postgresql 7.13 server at Redhat Linux 7.2, it found that
pgAdmin II connect all the Database when I click the Databases icon. (i.e.
If have have 10 database, it got 10 postgresql process on Linux).

So, is it possible to ONLY open the Database I want to use?

Regards,
Chris Lee

Re: Too many postgresql process

From
Dave Page
Date:

> -----Original Message-----
> From: Chris Lee [mailto:Chrislee@centurycity.com.hk]
> Sent: 13 November 2001 06:21
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Too many postgresql process
>
>
> Dear All,
>
> When I connect to Postgresql 7.13 server at Redhat Linux 7.2,
> it found that pgAdmin II connect all the Database when I
> click the Databases icon. (i.e. If have have 10 database, it
> got 10 postgresql process on Linux).
>
> So, is it possible to ONLY open the Database I want to use?

At the moment no I'm afraid, though it is something I've been thinking
about. The problem is that when you select an object collection in the
treeview, all of the member objects are listed with their comments in the
listview. This causes the problem you describe, as well as a delay when you
click on the treeview whilst each database is connected and queried.
Unfortunately, each database comment is stored in that database...

Anyway, I'll add it to the official To-Do list.

Regards, Dave.

Re: Too many postgresql process

From
Chris Lee
Date:
Dave,

First, thank for putting it to-do list.
How about just open the table and read the necessary info, store in program
array variable, then close it?

Regards,
Chris Lee


> At the moment no I'm afraid, though it is something I've been thinking
> about. The problem is that when you select an object collection in the
> treeview, all of the member objects are listed with their
> comments in the
> listview. This causes the problem you describe, as well as a
> delay when you
> click on the treeview whilst each database is connected and queried.
> Unfortunately, each database comment is stored in that database...
>
> Anyway, I'll add it to the official To-Do list.
>
> Regards, Dave.
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>