On Apr 25, 2005, at 10:54 PM, Typing80wpm@xxxxxxx wrote:
I just now tried creating a second server with pgadminIII. I am confused as to why one would have more than one server. There does not seem to be any way to "switch" from one server to another, or to log into one particular server (and not the other), or to create tables specifically for one server. I find the concept rather confusing. I understand that if I limit myself to one server, then I may define different database, and log to a particular database, and see only the tables in that database. Any explanation regarding more than one server will be appreciated. Thanks.
You can't just "create" a second server with pgadminIII. The server needs to exist already. PgadminIII just connects to existing server(s). As for why have more than one server, many folks have, for example, a development server and a production server. The process of creating the server is installing postgres again, not simply "adding a server" in pgadminIII. "Adding a server" in pgadminIII just means creating a set of connection parameters to another postgresql server.
As for how to create new objects in pgadminIII, it is probably worth reading some of the help for pgadminIII, but I don't use it enough to be sure that all your answers are available in the manual.
Sean
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster