|
Home > Archive > PostgreSQL Discussion > April 2005 > pgadminIII - creating servers
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
pgadminIII - creating servers
|
|
| Typing80wpm@aol.com 2005-04-26, 3:23 am |
| 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.
| |
| Sean Davis 2005-04-26, 7:23 am |
|
On Apr 25, 2005, at 10:54 PM, Typing80wpm@aol.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
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
|
|
|
|
|