From: | "Fred Parkinson" <FredP(at)abag(dot)ca(dot)gov> |
---|---|
To: | "Guillaume Lelarge" <guillaume(at)lelarge(dot)info> |
Cc: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: pgadmin3: can't locate server: what am I doing wrong? |
Date: | 2010-12-13 16:47:06 |
Message-ID: | 4D05DD8A020000A700015202@gwia1.abag.ca.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Thank you for your quick and accurate reply.
I logged in as root, picked the 'add a connection...' option you
suggested and voila! The server is now visible to pgadmin3/root user.
Thanks again, Fred
>>> Guillaume Lelarge <guillaume(at)lelarge(dot)info> 12/13/2010 8:32 AM >>>
Le 13/12/2010 17:20, Fred Parkinson a écrit :
> I am a longtime user of postgersql, using it as a backend and using
odbc to connect and it has been an amazingly stable and useful database
manager.
>
> Now, a longtime Windows user (disgruntled) I am trying to set up a
development platform on a local Suse Linux box which includes a local
install of postgresql.
> Last week I successfully installed postgersql and created a database,
but today pgadmin3 doesn't seem to find it!
> Using the unix ps command I see there are postgre processes running,
so the server is up.
>
> Logged in as user postgre and invoking pgadmin3, 'Server Groups' is
empty.
> logged in as user root and 'server groups' is empty.
> logged in as fredrated and the server is there.
>
> Can someone explain what this means? Why is the server only visible
to this user?
>
Because only this user has configured access to this server. pgAdmin
can
sometimes auto-detect local servers, but you shouldn't rely on this.
Usually, you should add them yourself to pgAdmin (first button on the
toolbar).
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Fred Parkinson | 2010-12-13 17:28:28 | adminpack installed? |
Previous Message | paulo matadr | 2010-12-13 16:46:13 | Res: Cluster with LATIN1 and UTF-8 |