Обсуждение: 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? Regards, Chris Lee
> -----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.
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 >