Re: pgadmin3 problems

On 13/10/2012 18:25, Vince Miller wrote:
> Hi,
>
> I'm trying to connect with pgadmin3 from my Windows box across my lan
> to my working database on my new working Ubuntu 12.04/postgresql 9.1
> database server, and it isn't working. I've been using pgadmin3 1.8.4
> with my old database server for some time now, without problems. I
> try to upgrade to pgadmin3 1.16.0, and that isn't working either. It
> seems the upgrade needs to see 1.14. Is there a fresh installer for
> 1.16 under windows?

Yes, just ignore the "upgrade.bat" file and run the .msi file directly.

> I'm pretty sure I've got postgresql.conf and pg_hba.conf right. I can
> create a new database server on the server box just fine. I'm getting
> this error message:
>
> 'ERROR: column "datconfig" does not exist LINE 1: ..b.dattablespace
> AS spcoid,spcname,datallowconn,datconfig...'
>
> then another that says
>
> 'Column not found in pgSET: rolconfig'

I vaguely remember seeing this on one of the mailing lists before, and
it turned out to be some sort of version mis-match.... you might find it
in the archives for this list or for pgsql-general.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie