Re: Can pgadmin admin a remote DB? - Mailing list pgadmin-support

From Raphaël Enrici
Subject Re: Can pgadmin admin a remote DB?
Date
Msg-id 41FB7D62.6050802@club-internet.fr
Whole thread Raw
In response to Can pgadmin admin a remote DB?  (Shea Martin <shea@snowsquirrel.ca>)
List pgadmin-support
Shea Martin wrote:

> I installed psql (from source), gtk2(sunfreeware.com), wxwidgets(from 
> source) and pgadmin(from source).  But pgadmin just segaults before I 
> even see a window, despite the fact that ldd shows now errors (see my 
> previous posts).
>
> So I have decided that the solution might be to leave the data base on 
> the machine it is now (I need the DB there), and install pgadmin on a 
> solaris 10 box, which comes with gtk2, and many more modern libs that 
> the solaris 8 box.  Then use pgadmin on the sol10 box to admin psql on 
> the sol8 box.  Is this possible?

Yes it is... At least if pgAdmin runs ok on your sol 10 box. pgAdmin is 
mainly designed to do remote admin although it can administrate a local 
db using a tcp connection.

> If the answer is yes, then what Postgres packages do I have to install 
> on sol 10 box?  there is the postgres-7.4.6 tarball, then the docs, 
> base, opt, and test.  Obviously docs, opt, and test are not needed.  
> Do I need both of the other two or just 'base'?

All you need on server side is: the server part :)
On client side (the sol10 box) all you should need is the libpq and its 
dependencies (openssl for example) and the pgAdmin dependencies 
(libwxgtk2.5.3). You will have to take care to configure your server to 
accept connection from your client just as you would do if you were 
configuring your server to be administrated by a remote psql client.

HTH,
Raphaël



pgadmin-support by date:

Previous
From: Shea Martin
Date:
Subject: Can pgadmin admin a remote DB?
Next
From: "Fernando Aguada"
Date:
Subject: problem with type and varchar