Re: pgadminIII - creating servers

On Apr 25, 2005, at 10:54 PM, Typing80wpm(at)aol(dot)com 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