Обсуждение: pgadmin3 problems
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/postgresql9.1 database server, and it isn't working. I've been using pgadmin3 1.8.4 with my old database server forsome time now, without problems. I try to upgrade to pgadmin3 1.16.0, and that isn't working either. It seems the upgradeneeds to see 1.14. Is there a fresh installer for 1.16 under windows? 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 justfine. 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' Any idea what gives? Thanks for any help you can offer. Vince
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@iol.ie
On 13/10/2012 18:44, Raymond O'Donnell wrote: > 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? <snip> >> '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. Actually, I just re-read your email, and realised that you're on pgAdmin 1.8 - that's pretty old, and I'd hazard a guess that when you upgrade this problems will go away. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie